Viewing 15 posts - 16 through 30 (of 67 total)
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...
September 8, 2010 at 8:36 am
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...
July 8, 2010 at 7:22 am
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....
November 6, 2007 at 9:09 am
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...
November 6, 2007 at 8:35 am
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...
January 26, 2007 at 2:47 am
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...
December 28, 2005 at 5:52 am
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.
October 11, 2005 at 7:29 am
I couldn't get it to shrink even after playing around with different settings of the recovery mode!
October 11, 2005 at 5:59 am
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,...
October 11, 2005 at 3:54 am
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...
October 11, 2005 at 3:47 am
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,...
February 4, 2005 at 6:24 am
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...
August 3, 2004 at 6:10 am
Another possibility may be to create a view which only brings back non-null records and then set a unique index on the view.
July 9, 2004 at 9:49 am
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...
June 2, 2004 at 5:02 am
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...
May 25, 2004 at 6:17 am