Could you use

Script database users and database roles

Script SQL Server logins

in Generate SQL Script ... in SQL 2000?

F8

Try the following script to find whether or not this account owns any object.

SELECT su.uid, su.name, so.name FROM sys.sysusers su, sys.sysobjects so WHERE su.uid = so.uid AND su.uid <> 1...

Did you have any chance to read the discussion in the link below?

http://www.sqlservercentral.com/Forums/Topic440567-5-1.aspx

Waht are your errors?

You can use the built-in debug tool for stored procedure in QA.

Also, you may add some PRINT commands between your code and see whether or not you...

You need to take some time for your transactions rolling back. Even though you restart your SQL Server services, you still need to wait for the rolling back.

In QA

Click Tools\Options...;

Click Connections tab;

Look at Query Time-out (seonds);

...

Normally, not unless you insert "Jumbo" data and your tables have many some weird indexes.

Your inserts are for different tables. You will only have table locks if there is no...

Check whether or not your data in your subscribers have been updated.

You raised an interesting question.

Duplicates in a database is against the concept of database normalization. If you really would like to retrieve data in one way or another of duplicates,...

You can cooperate with your DBA to check the version of your SQL Server, and its setting of max connections.

You bet.

Although you have regular transactional backup, your transactions are kept for your replication. Therefore, we cannot say the transactions are really inactive until you drop the replication, or your...

A single database is enough because it is designed for multiple users.

No matter whether or not you

SET IMPLICIT_TRANSACTIONS ON

The system will roll back any imcompleted single transaction when it is restarted.

When you run

SET IMPLICIT_TRANSACTIONS OFF

The system write the data...

Disable the constraints;

Change their data types;

Enable the constraints.