Viewing 5 posts - 1 through 5 (of 5 total)
Would now be a good time to bring up the "SQL-Server-2000-only-recognizes-every-3rd-millisecond" limitation? That one used to bite me in the butt. BOL covers this topic for those who are interested...
July 7, 2005 at 2:02 pm
There are several scripts on the web that kill SQL Server connections; here are a couple to try:
http://www.extremeexperts.com/SQL/Scripts/default.aspx (look for the Kill Connections script)
or
http://www.databasejournal.com/scripts/article.php/2110211
Blake
June 15, 2005 at 3:47 pm
Accounting for NULL values can be tricky. Do you have a date that would make a good substitute for NULLs? For instance, if you know that DateSubmitted could...
May 4, 2005 at 5:12 pm
As an aside, I'd recommend using over != since is part of the SQL-92 standard, but != is not. Both operators provide equivalent functionality.
May 4, 2005 at 4:03 pm
It sounds like all you need is the schema -- when you say you want all data removed, you do mean all data, correct? If so, you could write the...
April 28, 2005 at 2:30 pm
Viewing 5 posts - 1 through 5 (of 5 total)