I do believe Citrix can use SQL to store information about users.  Mostly an issue where you have a Citrix farm I imagine.

And people wonder why I have copies of all install CD's from 7.0 and up at home

You would have to code it into the procedure.

At the 2 companies I have worked that had a failover server we tested at least once every 3 months, pluss whenever we had patching of course.  The every 3...

Good reason: Brain fart?

I have a few tables without indexes, but those are for like where I am storing information about logins and I am more worried about inserts being...

I put this into production this weekend, and seems to be working fine so far.  Here are the additional steps I took to lower the risk of a potential server...

I think the ability to jump into something you are unfamiliar with and make it work might be the biggest thing for a senior DBA.  After 12 years of this...

Yes.  Just use two seperate update statements

create procedure usp_UpdateTwoTables

as

begin

update table1

set Column1 = 'a'

update table2

set Column2 = 'b'

end

After 6.5 I don't think I have had scheduled reboots of servers with SQL on it, and then mostly because of a memory leak in a custom made XP.  Of course...

oops missed the part about doing it to fix collation. NM me

Any reason why you can't do a backup/restore?

Well that was interresting.  Either the documentation needs to be better or I missed something.

Restarted the server with -f -m flags (minimal, single user).  Then I could log on and...

ok found the reason, failed to put in the database name the table was in.  Now, is there any way to bypass this?  Even DAC won't work.....

You can use a variable with XML data type to pass XML into another stored procedure.

Use SQL Profiler.  Under Security Audit there is a Audit Backup/Restore Event.  Will tell you, among other things,  HostName from where the backup was initiated, the login name and the...