I used the Errors and Warnings event and i see quite a few of sort warning
throw up.. Only problem is thats all I see too. For starters what does it
mean ? And how do I figure whats causing it ?

Thanks

Hi Hassan

The sort warnings event class is described in Books Online or at
http://msdn2.microsoft.com/en-us/library/ms178041.aspx

If you are profiling at statement level you can use the SPID to find the
statement start or end event.

John

Show quoteHide quote

Snapshot size
SQL Server better than DB2
Date Sql 2000
sql 2005 - which role allows to read ddl but not to modify it?
I dont see any hostname in sysprocesses
Sybase Linked Server Error
Is SQL Express 2005 by default a single connection db?
Database Maintenance Plans
Tempdb - Device not ready
Sql Server 2005