|
I tried to modify a table in the database, and when I clicked "Design" in the context menu, I got this:
"You're not currently logged in as owner or administrator."
and this:
"You can change the table but the changes won't be saved."
The really intersting part of this is that I'm the user that created the database in question, as well as every component (table, stored proc, function and view) in said database, which, last I checked, makes me the "owner".
I can't do anything but laugh...
EDIT ===========================================
The change I'm trying to make in the database supports code I've already put into the application. I'm waiting for someone to suggest I remove the new code so I can continue working, just so that I can tell them that's not even in the realm of possibility. If they want to stop me from working, I'll happily oblige them.
".45 ACP - because shooting twice is just silly" - JSOP, 2010
-----
You can never have too much ammo - unless you're swimming, or on fire. - JSOP, 2010
-----
When you pry the gun from my cold dead hands, be careful - the barrel will be very hot. - JSOP, 2013
modified 28-Jan-15 10:57am.
|
|
|
|
|
Wasn't this covered by those oh-so-valuable qualifications you just got?
|
|
|
|
|
I mentioned that to the HMFIC down in the DBA office... If I have the required sysadmin certification, why am I not a sysadmin?
".45 ACP - because shooting twice is just silly" - JSOP, 2010
-----
You can never have too much ammo - unless you're swimming, or on fire. - JSOP, 2010
-----
When you pry the gun from my cold dead hands, be careful - the barrel will be very hot. - JSOP, 2013
|
|
|
|
|
Something similar happened to me once. I tried to change my default schema. Couldn't because I was part of the sysadmin group. So I removed myself from that group. I didn't think however, that now I can't get those rights back. 
|
|
|
|
|
You can if you're a local administrator on the server. 
Starting SQL Server in single-user mode enables any member of the computer's local Administrators group to connect to the instance of SQL Server as a member of the sysadmin fixed server role. For more information, see Connect to SQL Server When System Administrators Are Locked Out[^].
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
That was exactly how I reinstated my rights and then created a new user so I have admin and user with different schema
Thanks for the link
|
|
|
|
|
There is a setting that needs modified. I cannot remember at this time but I will look for it.
Look under tools\options\designers\Prevent saving changes that require table re-creation.
|
|
|
|
|
I'm not an admin - I can't change sh*t...
".45 ACP - because shooting twice is just silly" - JSOP, 2010
-----
You can never have too much ammo - unless you're swimming, or on fire. - JSOP, 2010
-----
When you pry the gun from my cold dead hands, be careful - the barrel will be very hot. - JSOP, 2013
|
|
|
|
|
I believe the prevent change flag needs modified by a sysadmin
|
|
|
|
|
I am not going to tell the sysadmin how to do his job. I'm assuming he is at least equally as certified as I am.
Meanwhile, I'm sitting here slappin around ol' Mr OneEye...
".45 ACP - because shooting twice is just silly" - JSOP, 2010
-----
You can never have too much ammo - unless you're swimming, or on fire. - JSOP, 2010
-----
When you pry the gun from my cold dead hands, be careful - the barrel will be very hot. - JSOP, 2013
|
|
|
|
|
John Simmons / outlaw programmer wrote: I can't do anything but laugh...
Well, you could, but it would probably mean you lose your gun license.
cheers
Chris Maunder
|
|
|
|
|
The U.S. Constitution is my license - can't lose that...
".45 ACP - because shooting twice is just silly" - JSOP, 2010
-----
You can never have too much ammo - unless you're swimming, or on fire. - JSOP, 2010
-----
When you pry the gun from my cold dead hands, be careful - the barrel will be very hot. - JSOP, 2013
|
|
|
|
|
|
No - I'm on a DoD network running as a normal user. My credentials/access has not changed at all since the time I created the database.
".45 ACP - because shooting twice is just silly" - JSOP, 2010
-----
You can never have too much ammo - unless you're swimming, or on fire. - JSOP, 2010
-----
When you pry the gun from my cold dead hands, be careful - the barrel will be very hot. - JSOP, 2013
|
|
|
|
|
Don't you have to collect 50 rings to do that?
I wanna be a eunuchs developer! Pass me a bread knife!
|
|
|
|
|
John Simmons / outlaw programmer wrote: The really intersting part of this is that I'm the user that created the database in question
What did you do, switch from Windows 7 to Windows 8 in between then and now? 
Marc
|
|
|
|
|
I think if I had done that, I'd be shooting the place up by now.
".45 ACP - because shooting twice is just silly" - JSOP, 2010
-----
You can never have too much ammo - unless you're swimming, or on fire. - JSOP, 2010
-----
When you pry the gun from my cold dead hands, be careful - the barrel will be very hot. - JSOP, 2013
|
|
|
|
|
When will you start writing your own comics? Johnbert, maybe?
My blog[ ^]
public class SanderRossel : Lazy<Person>
{
public void DoWork()
{
throw new NotSupportedException();
}
}
|
|
|
|
|
A few years ago, I actually came up with a concept for a programmer cartoon strip.
".45 ACP - because shooting twice is just silly" - JSOP, 2010
-----
You can never have too much ammo - unless you're swimming, or on fire. - JSOP, 2010
-----
When you pry the gun from my cold dead hands, be careful - the barrel will be very hot. - JSOP, 2013
|
|
|
|
|
The cost of blood red ink too high? 
"the debugger doesn't tell me anything because this code compiles just fine" - random QA comment
"Facebook is where you tell lies to your friends. Twitter is where you tell the truth to strangers." - chriselst
|
|
|
|
|
Well, you've got enough inspiration, get to drawing! 
My blog[ ^]
public class SanderRossel : Lazy<Person>
{
public void DoWork()
{
throw new NotSupportedException();
}
}
|
|
|
|
|
I just ran into it for the first time a few minutes ago (for something that I'm 99.9% was my fault).
http://www.codeproject.com/Images/evil-hamsters.jpg[^]
Did you ever see history portrayed as an old man with a wise brow and pulseless heart, waging all things in the balance of reason?
Is not rather the genius of history like an eternal, imploring maiden, full of fire, with a burning heart and flaming soul, humanly warm and humanly beautiful?
--Zachris Topelius
Training a telescope on one’s own belly button will only reveal lint. You like that? You go right on staring at it. I prefer looking at galaxies.
-- Sarah Hoyt
|
|
|
|
|
Dan Neely wrote: (for something that I'm 99.9% was my fault
Nah it's a picture of Sean in the Mankini if it's your fault.
|
|
|
|
|
|
It could be worse: he's got a new costume for this years MVP award deliveries. 
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
