I fully understand what you are saying sjcsystems, I to have experienced queries which cause problems on SMP machines and have had to use then OPTION(MAXDOP n) option.

I think that...

As far as I am aware SQL Server 7.0/2000 are both fully SMP aware.

Having additional processors increases the number of available processor threads which increases the number of concurrent tasks...

Execute the following and it will tell you which version you have installed.

SELECT @@version

I think you are just seeking a discussion topic, but just in case you are looking for a solutions.

You could write a trigger to allow only unique non-Null values.

Tim, have you got an example of that you can post here?

Are you sure you are not running something like the Personal Edition of SQL Server.

For a production environment you should be running the Enterprise or Standard Edition.

Have you checked the "Maximum concurrent user connections" setting SQL Server Properties, Connections?

It should normally be set to 0 (zero) - this gives you unlimited connections.

The most usual way to output data from SQL Server to an Excel file would be to use a DTS Package.

One solution would be to build a distinct list of Key values in a subquery using a union statement for each column you need to search. Then join this...

How many of the columns within your table have full text indexes built on them?

Ok I see your point (I am fully aware of variable scope and the scope of dynamic statements).

Just to give another view point, how about using the temporary table and...

You could try using a subquery within your dynamic sql, this would eliminate the need to use a temporary table and allow you to use the now recommended TOP method.

DECLARE...

I agree with Scorpion_66, your code appears to be syntactically correct.

However, in terms of performance, why are you getting the count of rows from the inserted table before performing the...

SQL BOL (SQL 2000) states the following regarding the SET ROWCOUNT command.

"It is recommended that DELETE, INSERT and UPDATE statements currently using SET ROWCOUNT by rewritten to use the TOP...

Mkumari, I think you missed the fact that in akhaibari's code, the param @flights_table is actually a TABLE variable.

Therefore SELECT * FROM @flights_table is perfectly valid.