Too easy?

Ah well, we are here to help people out after all.

You can select them and return then as a recordset.

Edit. I need to read better.

A better way to debug than mess with dynamic SQL, which in this case is going to cause errors that didn't exist before, is to...

Take this lot out from just before the exec. The GO breaks the batch and afterwards, the SQL1... variables are not defined.

GO

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

Firstly, this....

Please don't create multiple threads on the same problem. It just fragments replies and annoys the regulars.

Since this is a continuation of your old thread, please continue it there

Union

Since you're using SQL 2005, you can use the Row_number function. makes this kinda thing very easy.

Since I also suspect homework 😉 at least until told otherwise, consider this

ROW_NUMBER() OVER...

Autoclose means that when the last connection is dropped from a DB, the DB is shut down cleanly, just as if the server had shut down. While the DB is...

Hint

DECLARE @Var1 INT

SET @Var1 = NULL

SELECT

CASE WHEN @Var1 = NULL THEN 'Var1 = Null' ELSE 'Var1 <> NULL' END AS EqualityTest,

CASE WHEN @Var1 <> NULL THEN 'Var1...

colin Leversuch-Roberts (12/21/2007)

---

I wasn't having a go it's just that I can't believe that a production database wouldn't have an update stats job run every day( night / quiet period...

Oh you certainly did. Almost to the coffee over keyboard point. Especially the bat.

What error?

Shut down the server (if its running) and move the tempdb files back to where they were (and any other files that you moved) then restart SQL. It should come...

Do you have any indexes other than the one you posted? Especially, do you have a clustered index?

If you don't have a cluster, I would suggest a clustered index on...

The DB restore would have been the cause of the cache flush that you saw in the error log. In this case it's nothing to be concerned with. It's just...