Thanks, I'll do that.  Interesting that it's never been an issue prior to this recent security patch.  Or, I guess it may be a case where it has always happened,...

Yes they are on the same filegroup.  Now I see the EMPTYFILE option in BOL in DBCC SHRINKFILE.  Thanks!!!

Thanks for the replies.  The transaction log is already on another drive.  This is the only database on this drive. 

So, I will set auto grow off and alter the database...

Three things that worked best for me. 1) Being lucky enough to have a good mentor. 2) Liking to read.

3) Being thrown from the frying pan into the fire,...

One of the advantages of using FT search is that you can rank the search results, and, therefore, display the results in order of relevance. The FT catalog is...

Thanks. I looked all over BOL, but didn't come across this. Since we don't run in fiber mode, it would imply that firing up a worker thread on...

If you see anything running in the Distributed Transaction Coordinator, you may also be able to kill it from there.

It is a Microsoft Press book. Authors are Alan Hirt, Cathan Cook, Kimberly Tripp, and Frank McBath. The ISBN is 0-7356-1920-4. It came out a little more...

Sales people who give a demo of our website without telling us that they are doing so. You know the kind of demo...150 people in a room in front...

I'm surprised that nobody has mentioned the new SQL Server 2000 High Availability book. It is awesome!

Let me phrase my question another way, based on things that I'm seeing in profiler traces. We have a web application (IIS/ASP) that calls a COM layer, which executes...

You can specify collations at several levels in SQL 2000. The default collation that you select when you install SQL Server, on the database level when you create the...

In EM, check the Properties of the SQL Server in question. Go to the Processor tab, and check to see if the "Use Windows NT fibers" check box is...