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...

Have you looked in the SQL Server errorlog of the offending server?  Have you tried going to SSMS and running the query directly that fails directly against the server?  Are...

Without any table DDL and sample data from you, we're just guessing.  But, assuming you have exactly one row for each 15 minute period, all you need to do is...

Does each table have a primary key or unique constraint that's on a column (or set of columns) with similar data types?  If so, you can do something like this:

Could it be as simple as this?

SELECT * FROM MyTable
WHERE time_stamp IS NOT NULL

John