|
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...
|
|
|
|
|
+5 for the art!
Jeremy Falcon
|
|
|
|