I took a different approach and here is how I set up my service account.

service account is a domain user account.

the login is added to the USER group on the...

Big boy,

I do my stuff like DAB's way too because I manage more server then you and more databases.  I also have a job...

I had similiar problem earlier and what we had to do was reinstall the latest NT/Windows service pack on the same server and it all came back.

mom

how about try to uninstall sql 2000.  After uninstall, make sure go to c:\program files\microsoft\sql server and delete everthing in SQL Server folder so that there is no leftover stuff...

How about backup database 1st and then truncate the log?

mom

hm... this is an interesting issue.  What type of Sys Admin are we talking about.  Our NT sysadmin are not allow to get into SQL Server.  They have no rights...

sp_changedbowner will change it back to what you need.  I would check with your co-worker first before making the change because at where I am, it depend on what is...

Correct me if I am wrong, I think EventLog would show you the information you need.  You won't be able to find it in Sql server errorlog.

mom

Interesting question, here we have a group of DBAs that has SA's privelege and 5 or more group of DBAs that does development work and has no SA's privelege, yet...

1st.  I am not sure what type of backup you are doing.  Let's get you going by creating a new backup device.

USE masterEXEC sp_addumpdevice 'disk', 'mydiskdump', 'c:\dump\dump1.bak'

after you create the...

I am confused.  Let me clearify what you are trying to tell us.  OK, you made a copy of production database and put it on test servers.

1.  You remove users...

It is a good start with trace, by doing trace you find out what your application use as login, based on the login you could go into the actuall database,...

Congratulation on both the baby and the promo.  I am sure everything will be fine.  As far as leaving development I know the feeling.  I used to missed being development...

Here is what I usually do when I got that type of error.

Try

EXEC sp_revokedbaccess 'Corporate\GeorgeW'if the user own objects, you would have to change ownership of that table,view,stored proc...

Don't your company has spare server?  I don't like playing the way your NT Admin is function because you could risk losing data, corupting database and no backups.  I haven't...