If you can afford some read-only recordsets during the work day, then analysis services may be of interest.  You can build your results during the night for the next day's...

Check the services Logon As.  The MSSQLServer and Agent services may be staring/logging on with insufficient permission.  Also check DCOM permissions.  You have have corruption or incorrect DCOM permissions for...

Do you need to test the application's connection string to the mirror, specifying the failover or do you plan on retrieving the failover as part of the initial connection process?

Do...

I believe you are encountering the loop due to the underlying data being updated by the cursor.  My suggestion would be to modify the code for a static cursor.

DECLARE

 @TCOUNT    INT,

 @BARCODE...

I have seen a similar behavior in Query Analyzer as well as SSMS.  If the Set Parse Only is turned on actual execution of the statement(s) never occur.  Also if the ansi_defaults...

I would also look at your logical/physical IO channels.  This may be a case where you need to have your OS on a physical channel and raid drive, separate channel...

Since 1999, I have not seen one EDI project profit from the use of XML.  I have seen many revert back to a well defined fixed width or delimited file. ...

I have spent the last three years developing a multi-server, multi-database plat formed system, using similar techniques.  We have had various performance penalties, most of which were unacceptable and have...

I would look at the windows event log first, then the sql log files, typically here:  C:\Program Files\Microsoft SQL Server\MSSQL\LOG.

You will probably find a disk write issue.

This is obsolete by M$: