Thanks Steve.  I was thinking that a call to PSS would be in order too.

We run Enterprise Edition.

Ben

No.  It's not clustered.  Normal install.  Default SQL Server instance.

Thanks,

Ben

Thanks for the reply Brian. I have been inclined to think the same thing. MS would likely frown on a server-wide trace huh? Probably not a "best...

good idea. Thank you.

Thanks for your replies. This helps a lot!

Thanks!

Here's the function that I have to do the conversion:

CREATE FUNCTION dbo.fnHexToInt (@Hex varchar(8))

RETURNS int

-- Ver. 1.0.0 28.Oct.2001, Ofer Bester

AS BEGIN

DECLARE @i ...

Guarddata,

It didn't work for me. I thought it did, but then I realized that it returned the wrong value.

Timingskey

Thank you so much! Converting to varbinary and then to int worked.

I wish it was that easy. I'm getting an error when I that says I can't convert varchar to int.

The app developer that I am working with...

Thanks Frank. This helps. Th eonly other thing is that I'm trying to do this without putting anything in a variable.

The original query returns many rows....

DrBuckingham,

Please tel me if this is what you had in mind. I tried the following:

set nocount on

declare @cpu_busy int

declare @IO_BUSY int

declare @IDLE int

declare @percent decimal

set @cpu_busy = (select @@CPU_BUSY)

set...

Thank you very much for your replies. I will try your suggestions.

Thanks a lot! I'll give it a try!

Thanks very much for your responses! I'll give it a try Allen. I'm assuming that following your steps won't bother SQL Server.