Forum Replies Created

Viewing 4 posts - 1 through 4 (of 4 total)

  • RE: Comparing two tables

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

  • RE: Cloning Databases

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

    regards,

  • RE: Cloning Databases

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

  • RE: shrink trans log

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

Viewing 4 posts - 1 through 4 (of 4 total)