I don't know off the top of my head but I did come across this article by Kalen Delaney which seems to be along the right lines.

http://www.windowsitpro.com/SQLServer/Article/ArticleID/27520/27520.html

Hope it helps,...

To answer one part of your question you can check to see what is failing in a maintenance plan by enabling the report writing option (just specfiy what you want the...

I'd be looking to do something in profiler to monitor activity in each DB and the NT username/login being used.

You'd probably need to leave it running for quite a while...

Thanks for that Colin, it's a handy thing to know

We're working on 64-bit Itanium2 servers here so I don't need to use boot.ini...

Couldnt have put it better myself (but thats probably the wines fault )

Can I ask if you have active directory in place because I've seen this a couple of times before and have used the information from the following article to resolve...

Yes SQL 2000 Enterprise edition deals with more than 2 GB, however, you also need to look at the memory availability for the OS.

Assuming you're on advanced server or above...

I've just expained that in order for the tables to be merged they'd all need the same structure, my time is way too expensive to waste on it; so if...

Taken from BOL

The deleted table stores copies of the affected rows during DELETE and UPDATE statements. During the execution of a DELETE or UPDATE statement, rows are deleted from the...

I'd start by actually setting the variable, that might help you a little

SET @Counter = 1

(don't forget to set in in the while...

Must not comment.........

Obviously the getting drunk and impressing the ladies were refering to 2 entirely seperate parts of the evening (or if some of the sorry states i've seen people in are...

At least you're doing it for the right reasons, to get drunk and impress the ladies

Although comming from the North East of England...

The only time I would think about shrinking the transaction log is when someone had done something stupid to fill it up (occasionally even me).

So long as you make sure...

I'd have to agree with Frank, why waste valuable drinking time looking to design a DB to track the wines you like/have drunk