Steve,

I've been a member for quite a while now and have seen this site go through many changes. The best part of all is that the changes really haven't...

Since things are 'hosed' already, try this:

Do what the previous poster said...create a shell database with the same name. However, DO NOT detach it. Stop the SQL Server services. Delete...

Doesn't matter which disk it's on. The sqldiag.txt will grow until all the disk space is gone.

It isn't happening consistently enough, but I do have an idea of what...

Which SQL Server version are you running? With 2005, QA is not separate. You need to open SSMS, right click on a database and select NEW QUERY. Or conversely, in...

I'm not positive, but I believe you need to change this:

c.includeincatalog=-1

to

c.includeincatalog='-1'

Without the single quotes, it will treat the - sign as a subtraction.

-SQLBill

10% of 400 is only 40GB. Depending on how fast and large it needed to grow, it would have to expand three times to make another 100 GB of space....

1. do you have jobs running? If so, those are connections (users). Stop the SQL Server Agent service while you need it in single user mode.

2. did you open Query...

In SQL Server 2000, the SQL Server Error Log can be found in Enterprise Manager at >Management>SQL Server Logs. Running the command sp_cycle_errorlog in Query Analyzer cycles the log....

This may actually an easy one. You are not looking for two characters. You are looking for a range of characters. I'll bet if you check, the...

Next time you lose the post, click on the Back button. That should take you back to what you typed, highlight it (Ctrl A) and copy it (Ctrl C) then...

1. the owner's login got dropped/deleted

2. the owner had their permission revoked. If the database box got unchecked for their login or the dbowner box was unchecked, this will happen.

3....

Is there an insert trigger that might be causing the issue?

-SQLBill

Yes, /PAE is set and we did adjust the min/max memory (100 MB & 2,147,483,500 MB). We always set it a bit higher than the default min and a bit...

Are the client tools on the same server as the database? If so, they should have been upgraded when you upgraded the databases.

Either way, running the SP installer will...

It autogrows "as needed". Lets say you have a database that is 100 MB and set to autogrow 500 MB. You have 1 MB left, but the database isn't...