Ah yes, our old friend the catch-all query.  Not easy to code your way around when you have so many optional parameters.  I think the ORDER BY is the lowest-hanging...

The error message tells you what you're doing wrong.  Use the link that Sergiy posted to get the exact syntax and some use cases.

John

And the shrink command?

OK, so your database is full up.  Since your table results look very similar to your database results, I'd say that's the only table in...

No.  Only if you restored the full backup with the NORECOVERY option.

John

Deleting rows doesn't reduce the size of the mdf file.  The only operation that can do that is a file shrink.  What command are you using to do the shrink?...

Still no CREATE TABLE or INSERT statements, either in this topic or the new one you started to ask what appears to be exactly the same question.  But this should work....

There's no way round it, I'm afraid.  You have to drop the column and recreate it with an identity property.

John

That's exactly what sp_executesql is for.  It's no good just saying it doesn't work.  What did you try, and what happened - error message, unexpected results, something else?

John

Yeah, it's possible.  Work through this - it should get you to the cause.  Just as a matter of interest, how many rows are in the table and...

SELECT
  'Table1' AS 'Table'
,  'FullName' AS PKColName
,  CAST(FullName as nvarchar(128)) AS PKValue -- choose a data type that all your PK cols can be...

Well, we can't see any more than you can, so you're going to have to get that error message by hook or by crook.  How about running a trace against...

Yes.  The "..." is an ellipsis - that means there's stuff missed out.  You need to fill that in yourself (unless you only have two tables, of course, in which...

I'm not sure what you mean by that, but if you need any more help, please provide table DDL (CREATE TABLE statement), sample data (INSERT statement(s)) and expected results based...