SQL server does not support this. You can implement the constarint by triggers.

(Sysbase has this feature)

This is the expected behaviour.

If a tran gets rolled back on the linked server, the MSDTC rolls back all involved local transactions. The return value of the remote SP is...

One trick to debug triggers. You can have some PRINT command in the trigger to print out some debug information. The information will be showed up when you run the SP...

XACT_ABORT is a run time setting. Check the SP you are calling whether it has SET XACT_ABORT ON.

Did you try to use double quotes before and after the unc path? If the UNC path has characters such as '&', you will receive the error you mentioned.

SET QUOTED_IDENTIFER OFF

GO

Execute xp_cmdshell...

In this case MSDTC must be running. And in both your SP, you need to have ANSI_NULLS set to ON, and XACT_ABORT set to ON.

Can you post the error you...

Put "Excel 5.0" in Provider string;

Check RPC and RPC out in server option.

Found it.

If you set XACT_ABORT ON, when time out, the trasaction is rolled back.

If you set XACT_ABORT OFF, when time out, the trasaction is not rolled back.

When transactions are controlled...

SQL server does NOT rollback a transaction if it's timeout.

It's client side responsiblity to roll it back if time is expired.

Check your code, it may be rolled back or committed...

When the server or connection is not available, you will have this "General network error".

If you can ping the server from the client, you can check the connection string (server name,...

You can use performance monitor on a client box and connect to the production. Use the counter log to monitor SQL/Database/Transactions / sec counter. You need to select this counter...

As Mike said, the disk counter is not accurate for SAN, especially the disk time. I sometime got 200%. I found using SQL server function fn_virtualfilestats is much helpful. You...

If i am not wrong, crystal report supports excel format (not 100% sure)

Another way is to create another sp, open excel as linked server, call ur existing SP for crystal...

A more straight way is to capture the running duration for the two queries by running sql profiler. it can tell you logical reads and phsical writes etc as well.

msdb has jobs, dts packages, and replications system data.

Has someone scheduled some jobs with high running frequency?-- select * FROM msdb..sysjobs

Has someone saved lots of DTS packaes there?

Has someone setup...