You can also try the following (Two tables containing the following columns: ID, UserID (initials), FirstName, and LastName)

Tables are names UserTable and UserTable1.

select * from usertable

where userID not in...

Thanks, Mark. It seems to work. Now I can have the security and passwords back!!

regards,

Question: I tried this using mssqlserver -c -m. The DOS information sais the server is running in single-user mode, but when I connected with Enterprise Manager, it still had...

Had this problem also. First do a complete backup, then set the database properties options - recovery to simple, then run the dbcc shrinkdatabase. Reset the recovery back...