If you have trunc. log on checkpoint option set for the DB in 7 it is similar to SIMPLE in 2000, if not then is similar to FULL. There is...

Try BEGIN TRANS and COMMIT TRANS in the trigger. I don't remember if this will work and cannot test tright now but it may.

"Don't roll your eyes at me. I...

Actually depending on the number of tables you may want to do a subselect with unions (each union select does a max on it's own table). Then do a max...

Shut down your SQL Server so the file will no longer be locked. Then copy the db files to a test copy of SQL 7 and use sp_attach_db to see...

Duplicate thread please see responses in http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=4625&FORUM_ID=24&CAT_ID=1&Topic_Title=backup+problems&Forum_Title=Backups

"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

Have you tried a backup using BACKUP DATABASE dbname TO TAPE = tapename WITH (See SQL BOL for more detail). You may need to drop your maintenance plan, but run...

This should help. Check out "INF: How To Transfer Logins and Passwords Between SQL Servers (Q246133)" http://support.microsoft.com/default.aspx?scid=kb;en-us;Q246133

"Don't roll your eyes at me. I will tape them in place." (Teacher on...

Ok I had a chance to research a bit this morning, see http://support.microsoft.com/search/preview.aspx?scid=kb;en-us;Q268361 which is titled "INF: Effects of Moving a Database from SQL 2000 Enterprise Edition to SQL 2000...

Please do not cross post. Duplicate messgae please see responses in http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=4628&FORUM_ID=23&CAT_ID=2&Topic_Title=compare++tables+in+dbs&Forum_Title=General .

"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

Or once you ID the differences you can then use ALTER TABLE to make the changes via script to production. (See SQL BOL for more detail). Also to help compare...

Other than replace I know of nothing. As for ' use '' to replace, REPLACE(col,'''','') will do the trick. Also just so I fully understand can you explain how translate...

The suggested method is highest selectivity first to lowest, the reason is that statistics are stored only for the first column. So in order for the query manager to properly...

The logins and their associated passwords will not exist on the other server as this is located in master and you may need to run sp_change_users_login with autofix to connect...

The actual passwords are stored in master in syslogins table. DTS most does not pull over the password in the wizard. You should be able to move the passwords directly.

"Don't...

I have never seen a density of 0. I don't think that is normal. Have you tried sp_updatestats and run DBCC again. ALso may try runnign DBCC UPDATEUSAGE to make...