Thanks for the answer..the links have helped. the error i got is as follows

[Microsoft][ODBC SQL Server Driver][SQL Server]I/O error 240(The session was cancelled.) detected during read of BUF pointer =...

Thanks very much for your response. I will re-install

Scott

ok..I am running (Build 1381: Service Pack 6)

I run profiler from start menu. Click on tools, Index tuning wizard..etc etc. Select the workload file I created earlier. Select the table...

i was following some MS documentation to demonstrate how to use profiler and index wizard. I have actually come across this error a few times now.

I have checked all of...

Now i'm coming to understand the principles of this. My original query i was checking out is as follows for finding duplicates in a table;

SELECT Surname, Address1, Address2, Address3

FROM tblCustomerData

WHERE...

I'm really sorry..i'm just as confused.. Can you explain the following query for me

USE Northwind

GO

SELECT CategoryName

FROM Categories

WHERE EXISTS (SELECT NULL)

ORDER BY CategoryName ASC

GO

and how the (SELECT NULL) comes into play.

Thanks...