You could also use the ISNULLL(@param1, 'enter default value here') to replace any nulls with the default value within your insert statement.

Catherine

You could possibly use the statement:

Set RowCount 50000

instead to stipulate the number of rows rerurned instead of the TOP 50000 statement.

I encountered this problem once before using views as the views I was querying were actually covering a large number of tables and underneath one was cross referencing the other...

Once you attach your files to SQL 2005 you will not be able to attach them to earlier versions on SQL. You could take a back up copy prior to attaching...

If you are using SQL 2000 you can use the Detach/Attach options. First detatch your DB and then copy to your new Server and attach once again.

Catherine