In a scenario where you do a "select ... into", you will get an error if you do not use column aliasing.

I noticed something in your post regarding storing images and documents. If these are being stored in the database, you might want to explore the possibility of storing them on...

If you are going to delete 15 million rows out of 20 million, then there is a possiblility where you can instead insert the remaining 5 million into another table, then...

No - you werent dreaming.

The utility is called Read80Trace and you can get it at

http://support.microsoft.com/default.aspx?scid=kb;en-us;887057

Regards

CK

You could run a trace using SQL Profiler and get all the activity that was done during a specified timeframe.

You can query the syscomments table as follows

select distinct object_name(id) from syscomments with (nolock)

where ctext like '%Your_Column_Name%'

However, if you have the same column name in multiple tables, you may not...

There is a set based method to do this - but you would need to create a permanent table created that has one column having 8000 rows with values 1...

Assuming you have the same Primary Keys on all 4 tables, you can use the following to get rows in A that dont exist in either of B, C or...

Use BEGIN and END after the outer IF..ELSE construct.

You can use the DATEPART function to extract a component of a datetime variable.

To stick it back together, you would need to CONVERT them into a string datatype and concatenate...

I havent used it much myself - but the debugger can be launched from the Object Browser in Query Analyzer.

You can get step-by-step instructions in BOL by searching under "Transact-SQL Debugger...

Although this may not be a perfect solution - you can use the following as a workaround.

I have tested it out in the Northwind database and used the Employees...

Your way (set based approach) would defintiely be better and faster.

If I may make a suggestion, In addition, you could also try using EXISTS instead of IN. Generally, I...