Has anyone had the experience of c2 auditing being the bottleneck on an OLTP system?

On 2003 I used the forfiles utility via xp_cmdshell to list the files and properties and then load this information into a table. I do a compare of the...

Ordering the objects by creation date will get you most of the way there.

INIT will overwrite the existing backups in the set. NOINIT will preserver the exisiting backups.

GO to url ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/89a4658a-62f1-4289-8982-f072229720a1.htm in Books OnLine (BOL) the SQL Server help files for information...

This is all not the same machine no remote connection issues. SQL Server service is also running uner local system and is running. SQL Executive cannot start because of this...

Not associated with a trusted sql server connection.

Have you thought about openrowset.

I don't like them because of the inability to customise what they produce without annoying the wizard. The main benefit is the speed with which a beginner can set up...

You need to assess the risk of it happening against the consequences if it does. If you want to leave the system up take a backup immediately before the work...

Be careful using word automation on a server. It'll throw up interactive message boxes here there and everywhere which canhave some shocking results! 

Where are you checking the dates when you see them reversed?

Could you post the execution plans for the two date ranges you mentioned so that we can see what is happening?

 

You could use Index hints to try and force the...

Setting the ISOLATION LEVEL is the way to go but just to answer your question  the locking hint would work within the transaction as you required.

You can test this by opening...

F @iCount > 1

 BEGIN

  RAISERROR( 56000 , 1 , 1) WITH SETERROR

  ROLLBACK TRANSACTION

 END

go

 

should this not be

 

IF @iCount > 0

 BEGIN

  RAISERROR( 56000 , 1 , 1) WITH SETERROR

  ROLLBACK TRANSACTION

 END

go

After the first insert iCount...

You have to compare like with like. Oracle has many features that can be added on and cost many more dollars. I know that ther are issues with SQL and clustering....