Anyone using Management Data Warehouse out there?

thx for you replies Grant, I would have thought profiler would help me identify the reason by batches are failing.

How about the User Error Messages event under the Error and...

I'm trying to monitor the server when I know queries are failing.

I know my batch is failing with an error, there is a SQL:BatchCompleted event, but it does not show...

the query was exactly the same and was using literal values.

hi, a fellow DBA sorted it by updating the statistics on one of the table.

dont ask me why stale statistics affected one user and not the other???

sorry I forgot to mention...I use this this on SQL Server 2000, I'm not if it will work on 2005

Something like this might help...

DECLARE @sql NVARCHAR(1000)

DECLARE @outsidecount INT

SET @sql = N'SELECT @insidecount = COUNT(1) FROM TableA'

EXECUTE sp_executesql @sql, N'@insidecount INT OUTPUT', @outsidecount...