In a recent blog, Kalen Delaney said she is frequently asked why is there a need to understand the internals of SQL Server. I think this question illustrates why. The...

Guess what? I came back to this problem today after a few days off and the problem has gone away.

Logged on to SSMS this morning, tried the drop database command...

But my problem starts in VS2005, long before I get to the deployment stage.

After creating a new SQL-CLR project, I can't find any way of adding a refernce to MapPoint....

We solved this problem by creating a 'Tools' database which is in SQL2005 mode, and hosting CLR objects and other 2005 stuff there. You can then call them from the...

I have encountered similar problems in the past, also with tables where the clustered primary key was a somposite of 3 char fields. In each case I solved the problem...

AS VFP allows the use of triggers, that is probably the best way. Make sure that the VFP trigger does a full compare of the records in both the dbf...

I tried backup with truncate_only and backup with nolog (which I think does the same anyway) but neither helped!

Thanks for the suggestion though. I will go and checkout that script now.

I couldn't get it to shrink even after playing around with different settings of the recovery mode!

I recently had a similar experience where I had made a copy of an 8Gb database for a demonstration and needed to anonymise the data. After a heavy session of updates,...

You could schedule a new job which starts after the expected (usual) finish time of the maintenance tasks. The new job could have two steps:

1. A step which checks that...

It is possible to use sp_MSforeachtable in this context. You just need to strip out all the extraneous characters when you pass the name to the function call. For example,...

There should be no problem as long as you pass the correct paths to sp_attachdb.

I use this process to work both at home and at the office using 4 databases...

Another possibility may be to create a view which only brings back non-null records and then set a unique index on the view.

The question stated that "The backup sets are set to expire after eight days and you have room on disk (by your estimate) for 12 days worth of backups to...

A word of warning... wherever you put the share, make sure that you use Cluster Administrator to create it. If you create a share using file manager and then try...