Could you use SQL 2005? There is a pivot function there. Or you export your data to 2005, pivot, then, import back to your SQL 2000?

I do not think you can. MS SQL Server runs transactions as atomicity. It is similar to standing on a staircase. You stand either on one step or another. But...

Steve:

Thank you for your input. Sybase is really headache in manipulation. But it is much more stable than MS SQL Server.

Managing the space of database devices and segments in...

I never heard the domain change of SQL Server in mixed mode. Could you explain a little bit more in detail?

Many thanks in advance.

If you are talking about the change...

Most likely, it is a security issue. Ask your DBA ro check.

It may also be the mess of database configuration. But it is weird.

Here are some links for your future...

Do you use SP4? If so, it is a bug inside. Try to apply the latest hotfix.

Did you have any chance to read the article in the following link?

http://www.microsoft.com/technet/prodtechnol/sql/70/proddocs/diag/part3/75528c13.mspx?mfr=true

AD: Active Directory. A term in Windows Server.

If you use SQL 7, you may try to expand your database. There is a bug there. But first of all, you had better try your best without changing your...

You may try to create a role in a database level, and include it as an application role. You need provide password for this role.

What is replication type between your server1 and server2, snapshot, or transactional, or merger? push or pull?

Are your 3 tables among those 50 replicated tables?

Did you have chance to read the article in the following link?

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=322173&SiteID=1

Basically, try to restart your SQL Server Agent.

Did you try to run DBCC OPENTRAN? It can tell you whether or not your transaction is still running?

I cannot see any reason why you cannot.

Did you check the range of identity in the affected column? The snapshot shows your insert hit the ceiling of its range.