My "what's running" points were all CYA issues. If you've got your superior's backing to your decisions, cool.

Personally, I've always been leery of putting SQL Server into single-user mode. What...

The quickest source of infomration on these and all the data types is SQL Server Books Online. Under the Index tab, go to the "data types-SQL Server, described" entry, then scroll...

If "...the plant is closed and offline", I'd first want to know what on the system is up, running, and using the databases in a way that defeats fairly routine...

That's the trick--identifying what I need to push beyond Development. If the developers can do any old thing on their box (and, having been a developer, I know they will), then...

I've never had hands-on experience doing this; given that, here's how I'd proceed (messing around with a quickly created and corrupted "test" database).

sp_attach_db creates a formatted CREATE DATABASE statement. Mess...

I have to mention, this solution would make it difficult to intentionally add new tables to your system...

When you run the third party app (say) the second time, does it...

When you attach a properly detached database, SQL looks in SysFiles (or one of those) for the physical name and location of the other files used by the database, and...

Thank you for the "in the field" report. The few reports I have heard are negative, and I haven't heard anything factual on the positive side, so consider me convinced.

Sadly,...

I was hoping to write to a file for two reasons. First, as near as I can tell SQL 2000 traces can only be manually configured to write to files (which...

Yeah, that was it on the nose. We ran out of disk space because of all the indexes on our largest data warehouse fact table.

   Philip

I hit a situation similar to this a ways back--tried to reindex the database, and it triggered a database autogrow that failed due to lack of space. The exact details...

Any and every SQL Login that has been granted SysAdmin rights (through membership in the SysAdmin server role) has complete, total, and absolute rights, permissions, and access to everything within that...

A most excellent article. Two more cents more than two years late, but who's counting?

Glad to see that I'm not the only person using "leading comma" format. One reason to...

Are the products considered (or nominated) for each category and the number of votes each actually recevied listed anywhere? I would consider that very useful information...

   Philip

I too thought the article was wordy.  It was quite refreshing, getting a plateful of detail and depth on a subject I've burned a lot of thought on, instead of...