Viewing 4 posts - 1 through 4 (of 4 total)
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...
August 27, 2003 at 9:07 am
Thanks, Mark. It seems to work. Now I can have the security and passwords back!!
regards,
August 7, 2003 at 6:39 am
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...
August 6, 2003 at 7:41 am
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...
July 18, 2003 at 6:40 am
Viewing 4 posts - 1 through 4 (of 4 total)