Thanks Steve.

Thanks for the help Phill and Carl. I'm able to get all the information that I need now.

Darias

Thank you for your reply. I actually have the hard copy of the SS2K Operations Guide. I was looking more for someone's implementation of the Guide to use as a...

Thanks for the query. It works perfectly.

Darias

And so it does. Thanks for all the feedback.

DB

I know that Sybase allows you to lock the logins so that they are disabled. Maybe that's what I was thinking of.

We are retiring a Dev server and I...

Thanks for looking in to this Dan.

Darias

Thank you very much!

Darias

Here is the link to the Microsoft fix for your issue. http://support.microsoft.com/directory/article.asp?ID=KB;EN-US;Q288411&LN=EN-US&rnk=1&SD=msdn&FR=0&qry=there%20is%20an%20incorrect%20syntax%20near%20Collate&src=DHCS_MSPSS_msdn_SRCH&SPR=SQL2K&

In a nutshell, Microsoft says you need to either apply the latest Service Pack for MSSQL2K or...