You might want to check your backup strategy.

I bet it started at 4am and your database was locked because of it.

That might be the root cause of your failure.

Lowell

Thanks Allen That's good to know; maybe Brian Knight could update his article to mention something about how it is not possible to rename SQL server Instances;

It would make...

This does what you wanted; the select at the end shows how you can find the # days before /number of days until the users next birthday:

CREATE VIEW UserBirthDay

AS...

OK I'll bite;

I've never seen anything like WITH TIES;

I looked to see if it was a query hint, but it looks like its a named set, right? i found something...

I found an answer from a Microsoft Guru that seems to explain how to fix your issue:

Hope it helps:

From: "Bill Hollinshead [MS]" (billhol@online.microsoft.com)

Subject: RE: SQL 2000 Enterprise manager unknown error...

there's at least 3 scripts in the script library of this site that compares table structures; i used "Compare Tables" in the search engine to find them here, and this...

Other's have suggested this and it's worked well for me;I take no credit for the idea itself: The question is can you change the way the data is "deleted" ....

Info you are going to use a temp teable, then the Identity() function might help you out. I've used it before and It provides the identity field for the column....

Essentially, that is exactly what I was wondering;

For fun, I wrote a script that would create an index for every foreign key that did not have an index yet; but...

I would suggest using XACT_ABORT; it will automatically rollback a transaction, and stop further statements from executing in the transaction when an error is encountered:

SET XACT_ABORT ON

BEGIN TRAN -- with...

@@fetch_status is the problem here; it doesn't revert back to the outer loops 'previous' fetch status after it complete's the inner loop.

wouldn't @@fetch_status only allow the inner loop to run,...

I just contributed a script that does this; everyone always points at tools to do it, but I felt it was a good challenge to try and write a SQL...