First and foremost with the Profiler client data is being transfered to the client live which means the client will be using memory and if across a network it will...

As far as fixing the issues in 2 that is an issue of reviewing the execution plan, making index decisiion (which you can try the index tuning wizard), possibly rewriting...

I would go with option 3. But to really know the impact you will need to test it to be sure it provides you with what you want.

You need to do a cast on the results from count to a decimal because it will return an INT value. And personally I would right as one query and...

Actually this is one of those gotcha items.

The OUPUT parameters are only available after the recordset is processed.

User a client side cursor and do a MoveLast then get your parameters...

Might, just test it, but also test impact on any other queries as well.

Instead of having each thread do the all the work of getting the data and such you might want to consider using a diconnected recordset (still might want a stage...

Oops, should include SQL Server 2000, not 7.

Nevermind just found

Topic is

COLLATE

and

Collation Precedence (example found here)

You can use several other places.

Yep I may just not have caught the change.

Try this

DECLARE @Run_Time INT

    SET @Run_Time = 9

 SELECT STUFF(STUFF(@Run_Time,5,0,':'),3,0,':')

The value is INT type yes, but if it ran for 9 seconds it is 9 not 000009. You will understand the...

Then try

STUFF(STUFF(Right('00000' + Cast(run_duration as varchar(6)),6),5,0,':'),3,0,':')

Check the logs as suggested first, could be an error is blowing out the system and if you can duplicate the issue yo can pinpoint what is happening right before...

I have always found the Oralce OLE driver to give the least issues. But make sure your driver revision is comparable to the server you are attaching too. I have...

Or break you SP donw into pieces and build back slowly to see if you can find what pushes it over the edge towards this error. Considering you say 10-20...