Thank you! Now, here is my next problem.

I also have jobs I need moved from one server to another. Just like before, I need a painless and effective and efficient...

I am doing an access to SQL Server conversion of queries, and Last() is used on columns on string type, and I was not sure if you still could use...

I had SQL Server 2000 Enterprise Edition on this box, with SP3. I uninstalled SQL Server and was trying to install MSDE instead, but I do not think I ever...

I looked at the Sybex book for 228 at the bookstore today and it looks like excatly what I need. A lot of hands on tutorials and examples. Thanks for...

When I ran @@version, I got

Microsoft SQL Server  2000 - 8.00.760 (Intel X86)   Dec 17 2002 14:22:05   Copyright (c) 1988-2003 Microsoft Corporation  Developer Edition on Windows NT 5.0 (Build 2195:...

I just purchased that book. Thanks!

More information from real world DBA's is still wanted and appreciated though

SQLBill,

Just so I understand, in SIMPLE mode, the transaction log only holds the current transactions being issued, then releases that space when the transaction is complete

but in FULL mode, the...

Greg,

Could you please send me the template as well? cmptrnerd9@charter.net.

Thanks,

Michael