That error message suggests that it's not an issue with any users being set for read-only permissions, but that the database itself is in read-only mode.  Did you check that?

(From...

I've done several .adp applications pointing at SQL2005.  The only problems I have hit is when trying to create/drop/modify objects.  If you are just doing selects/inserts/updates to data in existing...

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...