Folks, Does anyone have any suggestions on how to ALTER a replicated stored procedure? I can create a new procedure, add it to the publication (&...
I'm posting this because I haven't had time to learn SMO and port my DMO based stuff to it yet and am still having to use the 'old' kung-foo on the...
If you run profiler via sp_trace_create, be aware that you cannot have an INT as the last character of your @TraceFile parameter if the @Options is...
So, I had to write a script today to grant localserver users access to a clustered dbserver. This presents an unusual situation, as the SQL VIP does...
This script is for 2005... Here is the flowerbox, script is at the link below....
I can get the SQLDataRoot path from a DMO object called Registry.SQLDataRoot. Does anyone know if there's a way to get the default log path as well,...
So, I've got alerts defined on a 9002 (logfile full) event. When that happens on a SIMPLE recovery database a 'BACKUP LOG FooDB WITH NO_LOG' is...
http://www.thedailywtf.com/forums/55454/ShowPost.aspx<br /><br />Isn't it obvious? The answer is 42! [<img src='/community/emoticons/emotion-4.gif'...
I'm trying to automate an index usage trace. I setup the trace in profiler, validated that it's what I want and then scripted the trace out....
Has anyone else noticed this behavior? I'm seeing local temporary tables still created when the calling connection has disconnected. The behavior...
Is it generally considered good practice to use parens () around set operations that do not require a SELECT statement? SET @Foo =...
I'm putting this out here mostly to find out if I'm doing things 'right' in SQL2K5. This script is based on Kalen Delaneys` article from SQLMagazine...
Looking for advice on changing the password of SQLServer & Agent for a 2-node active/passive cluster. Previous password is unknown and mail is not...
I'll post more scripts of this type if this one cuts the mustard with other DBA's.<br /><br />Compile in master or your own DBA database. This...
Separate names with a comma.
