Heh... thanks, John... smelled a bit like Ice Cream, too. 😀

It's even simpler than that... if for every byte of data lost, the manager had to pay a fine of $100, how soon do you think that lame-o backup strategy...

Outstanding! Nothing like positive feeback to start the day! Thanks, Marvin!

You can't do it that way... if you insist on doing this the wrong way (with a cursor), then you need to FETCH from the cursor into some variables and...

M.van Leewen (3/11/2008)

---

OK Jeff and Matt,

I have deactivated autoshrink and I will plan better :D. I learned a lot in a few post from you all. Thanks.

I ran the estimated...

My answer would be, do your own interview. These answers are in Books Online.

Ya beat me to it, Andras... 😀

I believe you just need to make the column in the target table wider to hold that information.

Heh, too much VARCHAR in that for me, Gail... 😛

SELECT DATENAME(mm,DATEADD(mm,...

Heh... use ALL the features! Force Upgrades! Make your friends jealous! Keep up with the Jones'! 😀

Now... THAT I absolutely agree with! And for the very same reasons!

Yeay... sorry Adam... I see that now.

Sorry folks... was in a hurry and didn't see the earlier suggestions when I posted about sp_MSForeEachDB.

I'd rather not use triggers if I can help it... by the same token,...

J Sitz (3/11/2008)

---

I already had this function created for another application, and thought it would be easier than looking up the holiday dates in the future. I suppose if...

Event's table should have it's own PK and a unique index on the other two columns you spoke of.

SQL Server 2005 does have a ranking function. 2000 does not....