And what security settings are you using on the linked server?

If you can audit it in SQL server, why would you need to repeat the same task with the same results in Oracle?

In addition it should be SQL 2005 64 bit edition accessing SQL 2000 32 bit edition.

Easiest solution is:

On SQL 2000 side run the following script:

create procedure sp_tables_info_rowset_64 @table_name sysname, @table_schema...

This is Crystal Reports related error (usually means some DLL are missing from a folder) and it is not related to the SQL server.

Sounds like a standard Audit solution on a database?

Something like this: http://www.sqlteam.com/article/centralized-asynchronous-auditing-with-service-broker

And shouldn't the variation of "100 ms" in execution be random ?

In test I ran (using your code) for the table with 3 columns and 3 parameters I am receiving...

These are two distinct solutions I suggested.

Either use OUTPUT and INSERT OUTPUT to a temp table and then process the data inserted to a temp table to insert in any...

Gail,

would it be then proper to consider that on a table with search on an unindexed column the

'WHERE @param = something or field = @param" and

"WHERE field = @param or...

1. OUTPUT INSERTED INTO temptable.

2. Create a trigger.

Update is a Delete and Insert.

Your only bet is to change a design.

I remember reading in one of the blogs that SQL Server does short-circuit evaluation, but it was not specified under what conditions.

The /3GB and /userva parameters are valid only on boot entries for 32-bit versions of Windows on computers with x86 or x64-based processors.

Can you check your error log? Do you have any error messages stating "insufficient memory"?

Also, just from curiosity: why are using SP1?

Just my 5 cents.

There is no prevailing wisdom. There is a situational wisdom.

You are bringing it from a conversation link where you are suggesting to use a NOLOCK in a...

Can you try changing the order in your WHERE clause to 'WHERE (@num1 = 0 or colOne = @num1)'?