We are actually using (Standby/Read-Only) as there is a group reporting against that server, opposed to against production. Of course, they cannot as the restores are taking too long...

We are not compressing anything, no. The file copy is seldom the bottleneck. Yes, a large logfile takes a little while to copy, however that is not the...

In the other databases, which the users can get into, when I run the select from sys.database_principals, the 'qc' user does appear as a SQL_USER.

Thanks for the suggestions.

sp_droprolemember 'db_owner', 'qc' gave me the same "user or role 'qc' does not exist in this database".

sp_dropalias 'qc' gives me a "no alias exists for the specific...

Our system administrator login is the database owner. It is the same on the other databases as well. I did run the sp_helpdb to double-check, but that is...

Thanks for your reply. That is not the issue. Let me try to explain again.

The login "qc" has rights to 16 different databases. For 13 of the...

I cannot remove the login from the test box as it is set up properly for perhaps half of the databases and it is a fairly active test box. ...

Great links, thank you. That is the stuff I was mining the web for yesterday and missed.

I see, thank you. Our box is 2 quad cores with 8 gig of RAM. So is there any reason for us to go to Windows Enterprise...

Mark - did you ever receive a reply? I have a 64 bit windows server running 64 bit enterprise SQL 2005, and my NT administrators came running to me...

That is exactly my error as well, however we did have replication running on the server ... then they moved the server into our production environment, re-aliased and re-IPd it...

Thank you - actually I found (from the vendor notes) a reference to linked servers, which led me back, eventually, to the replication area where right-clicking I saw a "disable...

Thank you all -- I wound up discussing with the vendor and they sent me a whole set of DR stuff ... supposedly the world will survive in the current...

Ok - BOL helped there. I found in the properties box under subscription that it is a pull subscription and updatable is FALSE. I'll dig through that more...

Thank you. It is transactional.

Is there an easy way to find out if the publisher/subscribers are updateable? (I was following a checklist from the vendor and...