+1 to all the comments that pointed out the answer is incorrect. Good question to examine the defered name resolution idea - but need to verify code? Made it ambiguous...

Can you explain what the intention of this piece of code is?

IF NOT RStimes.EOF THEN

storeTime = RStimes("city_time")

END IF

It would seem that the predicate is failing here and your store_time...

Is there more than one result that satisfies your where clause?

Yes, great read and advice as always Gail. I would still be tempted to move the original mdf file away and create the dummy database with the same name, and...

repoint that path to your actual mdf file

Okay - I'm assuming that you don't have a recent backup here - because that would be the best option. Short of that you need to do a bit of...

Apologies if I'm belabouring this bus does the file MEDICALSTORE_log.ldf exist in that path?

Does the path:

C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA

exist on your machine?

CREATE DATABASE <database name>

ON (FILENAME = 'full path to the mdf')

FOR ATTACH_REBUILD_LOG ;

GO

That's pretty cleaned up all right! Does it run on 2012?

I'll add my voice to the clamour - as the question is worded tempdb is a correct answer to the question. Did not realsie that fact about the master database,...

Thanks Gail, great article and explanations. Clear and concise. Appreciate you clearing up that question for me.

Thank you Gail for the excellent article.

I do have one question: in the final demo where you looked at the log usage for an index rebuild, you mentioned "log reservation...

Something like:

SELECT Customer_Number FROM Customer_Offer

WHERE Product_Offer = '1'

and Customer_Number NOT IN

(

SELECT Customer_Number FROM Customer_Offer

WHERE Product_Offer = '2' OR Product_Offer = '3'

)

Can I use that sproc for an already existing trace?