UPDATE <table_name>

SET <field_name> = 'Haverhill'

WHERE <filed_name> = 'haverhill'

Yep.  It was smart enough to realize I screwed with it and refused to attach.  The link above worked out for us though.

Thanks.  That file works swell!

Do you have any startup paramaters that try to look at that drive, or have the default data or log location set to a location on that drive?

You are right...they are only one hour off.  That makes me a lot less concerned.  Thanks!

If using SP2 SSMS to talk to servers that do have SP2 installed, is there still the maint. plan issue?

When you use Windows authentication, it doesn't let you enter a password or check that box

When we change our Windows passwords, and then start using SQL Server Management Studio, using windows Authentication, it ends up locking out our Windows accounts.

It does it for a day...

I don't remember the syntax off the top of my head, but there is also a way to create a view that will prevent a user from making inserts/updates/deletes against...

Has anyone tried an in-place upgrade fro SQL2000 Standard to SQL2000 Enterprise. 

I am looking into it because I want to be able to use more than the 2GB of...

I know that it runs as the sql server agent account.  But I've had the network guys set that account up to have the same permissions that my account has...

SQL Server has command line support.  You could probably create a batch file that executes the stored procedure (or DTS package), and put a shortcut to that batch file on...

Right after I posted this, I noticed the little banner for APEXSql tools (apexsql.com) and have been playing arround with a trial version of their ApexSQL Doc product. 

It doesn't...

I get this problem every now and then.  I've pretty much narrowed it down to java apps (especially if the connections are managed by Tomcat) not closing connections properly.

The only...

I've never done this with MySQL, but have done it with DB2, Access, Excell, and Text Files.  I would imagine if you can find an ODBC driver that will talk...