I see you are getting more and more helpfull to those in need.   Thanx for sharing all the usefull information.

.. or they just didn't think it through.  But I agree that this is a somewhat strange requirement.

So what ?! just use microseconds instead of milliseconds in the results .

This seems to do it (didn't test it).

http://www.sqlservercentral.com/scripts/viewscript.asp?scriptid=1332

I now remember why I don't have a set based version for this one... I just can't beat the loop into submission .  This...

2 options come to mind at the moment :

1 - sp_updatestats

2 - Create a table variable with the key column(s) of the table.

Insert into @TV (KeyCol) Select KeyCol FROM...

And now to answer myself .

DECLARE @a int

DECLARE @sql AS VARCHAR(100)

set @a = 0

SET @sql = 'EXEC ?.dbo.sp_MyWork ' + CONVERT(varchar(10), @a)

EXEC sp_MsForEachDB...

Yes the command parameter is a nvarchar, so you can pretty much do whatever you want.  The difference lies with the fact that ? is a placeholder for the current...

Thanx for the tip.  Is there any link you can provide with information on the low level performance tuning like this one?

It's good to be it's own boss .

Yup that sums it up pretty good!

If it is forbidden in your environement, then just use a loop or cursor and build the dynamic sql string just like in the command.  The results will be the...

I'm sure there is but the only thing I can find on short notice is in the index tab of the books online when you can scroll to functions and...

Lol, now you may be going a little too far !

Surely you could find something close to that in books online but I have no clue of where to get you started looking for this!