thanks for the reply. I am capturing events rpccompleted, spstatementcompleted and sqlbatchcompleted. none of these have plan handle as their column. but it works fine to filter by duration. i...

I have used similar approach for other scenarios. I always tend to create a view for all the base tables and have the stored procedure to refer to the view...

I have used textcopy.exe which comes with sample extensively and it works like a charm. the simple way would be insert the rows in the destination table with the file...

I can see the use of this CTE in many places. Since I don't have the sql 2005 installed, is it possible to use variables inside the CTEs? The below...

Do you want to save the content of a word file to an image column in a table? Is this what you meant. Please elaborate.

Thanks

Ramsh

I would suggest creating a DTS package in this scenario since this needs some tweaking to the extended properties of the excel connection. You can let the import wizard create...