Then just add the declaration and inserts of the table variable into the dynamic string, so that it's the entire thing you posted originally.

What is the exact value of @SQLString? It's not the string built up in previous statements as far as I can see because that contains no reference to the table...

Would you mind posting the code so that it's readable?

DECLARE @string NVARCHAR(MAX)

DECLARE @UserMidListTable TABLE

(

Id INT ,

...

I'm fairly sure you did.

RESTORE DATABASE <database name> WITH RECOVERY

If that brings your database online then you did select the option...

Worth noting that a restore clears the plan cache for the restored database, so plans could not have persisted from before the restore.

Are you absolutely sure that you didn't check the option to allow more log backups to be restored?

You have to alias table variables, and wrapping the table variable name in [] tells SQL that the table in question is a real table in the user database with...

Wouldn't it be faster to run it and see if it works?

What goes inside the brackets in your INSERT () are the column names in the table you're inserting into. You have a bad mix of the INSERT ... VALUES form...

Different companies will ask different questions. Hell, I used to ask different questions depending on my mood and the candidate's CV. There's no fixed set of questions.

You say all google...

Log in to the DB with the credentials your administrator provides for you, if you're not allowed admin rights, then he'll have set up some lower permission level for you

Because you referenced a column without a FROM clause.

select @LastDate=MAX([LastUpdate]) FROM exhibitor.dbo.Maintable.

What was the exact restore command/options that you used?

No where near enough information. Determining optimal IO placement takes a lot of work, a lot of analysis of virtual file stats, index usage, drive latency, etc, etc.

kapil_kk (11/29/2013)

GilaMonster (11/29/2013)

kapil_kk (11/29/2013)

Sorry to mention that I also have update the record if data...