Viewing 15 posts - 316 through 330 (of 872 total)
Disregard, using IDENT_CURRENT.
Thanks
December 16, 2008 at 9:28 am
Well, I did a repair on the Backwards Compatibility ... and it appears I'm working now.
December 15, 2008 at 11:46 am
Nicholas Cain (12/15/2008)
Has one of the servers that you are monitoring been upgraded at all?
The problem isn't on the destination server(s), it's on the source server running my script. Yet...
December 15, 2008 at 10:17 am
You can not assigned a default schema to an NT group.
Read up in this thread[/url], as you'll see, this has been quite an inconvenience for many people.
December 15, 2008 at 9:06 am
Same server (for now anyways).
Anyways, I went through with the install and all is well ...
Thanks
December 10, 2008 at 10:10 am
You can query sys.objects and anything with a is_ms_shipped = 1 is a system created object.
December 9, 2008 at 1:39 pm
I do not believe you're able to do that in 2005 ... 2008 offers transparent data encryption, so perhaps this could be good justification to upgrade :). Don't quote me...
December 9, 2008 at 1:31 pm
Are you asking to as whether or not a user altered the size of the database by increasing the space allocation or if the database simply grew by it's grow...
December 9, 2008 at 1:28 pm
What is your event viewer telling you? Usually this happens due to running a service under an account which has had a password changed, but I doubt you did that...
December 9, 2008 at 1:26 pm
SQL_Easy_btn? (12/9/2008)
Can you uninstall the default instance and leave the remaining named instances intact?
Yes, you can.
December 9, 2008 at 1:25 pm
kebrith (12/9/2008)
thank you for your reply, please give me more detail, URL or something .Regards,
John Marsh (12/8/2008)
In SQL 2000, it is possible to disallow Page Level locks for an Index....
December 9, 2008 at 1:23 pm
exec msdb..sysmail_help_account_sp
Is your servername your exchange server?
December 9, 2008 at 1:17 pm
Crazyness, I know everyone is going to scream user error ... but toggling that on and off yesterday had no effect. Came in today, restarted my computer for other issues...
December 9, 2008 at 12:30 pm
Shinny (12/8/2008)
Did you try with the following menu"Script Stored Procedure as" --> "Alter To" --> "New Query Editor Window"
Yes, as stated all variations ... create / alter / drop,...
December 8, 2008 at 2:47 pm
Yeah, being that I still have to have explicit permissions on a user system marked procedure, there is no reason to keep it in the master database anymore.
December 4, 2008 at 1:10 pm
Viewing 15 posts - 316 through 330 (of 872 total)