Yes, you can be confident that your inserts, updates and deletes will be reversed assuming your using a script something like:

BEGIN TRAN

EXEC your_proc

ROLLBACK

Join onto the system table trace_events:

SELECT TE.name, T.*

FROM trace T -- table that contains the trace results

...

sp_dropserver 'oldname'

go

sp_addserver 'newname', 'local'

go

You don't need to change the -d option unless you are moving the master database.

There is no need to stop the SQL Server service before using DBCC TRACEON. If...

Using DBCC TRACEON then restarting the SQL Server service will immediately disable the trace flag.

If you only want the trace flag enabled until the SQL Server service is restarted...

Open SQL Configuration Manager, click on SQL Server 2005 Services, then right-click on the SQL Server service and select Properties. Click on the Advanced tab and in the Startup...

Are you using a linked server?

For text data types it's a bit more complicated. There's a good article on how to do it here: http://www.sqlteam.com/article/search-and-replace-in-a-text-column

This script will remove single quotes, if that was what you were asking?

UPDATE tablename

SET col1 = REPLACE(col1, '''', '')

I've replaced the CTE with a set-based method instead as suggested earlier. That has sped up the stored procedure a bit so thanks for that suggestion. It was...

The execution time is different on the server, which I saw in the trace. There were no recompiles.

No, as I mentioned in my first post, the same plan is being reused. That's why I can't understand the difference in the execution time.

I'll look into...

Yes, it does. There are several instances on the same machine all with different IP addresses.

Yes, I was trying via the "database engine query" button. I don't have time to try everything in that DTC article at the moment but thanks for the link....

I read the BOL article. It says that you can connect via a client on the server which is exactly what I'm doing. It only works if I...