I did not want to do backup on the primary because I did wanted to off load the backup cpu load to another server.

As far as database mirroring is concerned,...

Yeah, I have seen numerous examples of a CLR stored proc, the problem is that I need a function.

I was hoping to pass an informational message back to the client...

So I am accurate in saying that only Index rebuilds (thanks Andras), Deletes, Inserts and Updates cause the transaction log to grow, right?

There are no SQL Server Agent Jobs running during this time frame.

Are there other areas where jobs can be scheduled and or run?

Sorry

TOO many acronyms.

DC=Data Center

That is really good information. Thanks

How about this variable as well. Our DC (of which we have 3 now) typically houses many DBs. These would probably be...

SET

TRANSACTION ISOLATION LEVEL READ COMMITTED

that was the trick, Thanks Gopi.

Only problem with this is that GO throws a syntax error in ADO.NET

Yes I have.  It seems to be a latency problem when running this as a batch.

I assume that you are using a SQLCommand object.  Couldn't you just set the timeout value to something other than 0 so that the update would fail with a timeout...

I had thought of that, but wouldn't the overhead caused by inserting the data into two temp tables be greater than doing a direct row by row insert directly from...

You could use a replace statement on the string to convert it to XML. '<value>comment1</value><value>comment2</value><value>comment3</value><value>comment4</value><value>comment5</value>' and then use the OPENXML command in SQL server to view the information as a...

If you have an ODBC connection configured to access your mySql instance, then you could access that connection through Sql Server.

Have you looked into disconnected record sets?  If you don't want to requery the data each time a new page is selected then you can query once and set the connection...

SUCCESS

Thanks a ton Farrell.  I was able to do it without all those "fancy" declares that you suggested just by changing my contitional a little bit.

The Final Result works like...