Did you try executing DBCC SHRINKDATABASE with a percentage for free space, such as 10%?

Also, you can drop and recreate the clustered index after trimming the strings to compact the...

From that description it sounds like MSDE, the desktop edition of SQL Server. Have you actually got Reporting Services installed on your SQL Server? If so, then it is the...

Not sure what you mean by "runtime version" or "product version", but Reporting Services can be obtained from Microsoft and is 'free' to use with an existing SQL Server...

http://www.connectionstrings.com/ is a great resource.

Take a look in Enterprise Manager, right-click a procedure and select All Tasks, Display Dependencies. Uncheck the box that says "Show first level dependency only". You should get a list...

In your connection string, add "Application Name=app_name;"

Calvin is absolutely correct, SET ROWCOUNT should be avoided especially for modifying statements. Even though it has the same effect as TOP and the example Calvin uses, SET ROWCOUNT is...

What kind of locks are we talking about here? If it is compile locks then you should check if the UDFs are being recompiled a lot and try to avoid...

Something like this perhaps:

SELECT fileid

, name

, CEILING((size * 8) / 1024.0) AS SizeInMegabytes

, CASE WHEN growth = 0 THEN 'No' ELSE 'Yes' END AS...

Setting the recovery mode to simple would not make any difference here. That only lets SQL Server delete the log records before the MinLSN after a checkpoint is made. The...

See my reply in the other thread, and please do not cross post.

Following Remi's answer, the answer is definately yes it does halt database operation. The specified database will not be able to be modified if the log file is full. Other...

A couple of questions to work with:

Does the account that SQL Server is running as have the lock pages in memory policy?

Did you have AWE enabled (and working) prior to...

Right-click the job in Enterprise Manager and select All Tasks, Generate SQL Script. Then change the name of the job in the script, and either make your modifications there as...

That was what I was thinking of when I said you might be able to keep a read-only copy of your database files on a CD. But it still does...