This sproc was pushed to the back burner until now. Now that it is resolved on my end, I just wanted to update the post with the solution I used....

There is no harm in using it. I've been using that sproc (and the sp_MSForEachTable) for quite a long time with out any problems. But officially MS doesnt support it....

My bad!!

There is line in there that says

and name like ''tester''

you have to comment out that specific line, replace it with

/*and name like ''tester'' */

This like of...

Two things:

1. The script (2nd) was not giving the db name earlier, so had to make a small edit to the script. I wonder if you have picked...

Actually, here is the complete script for all the databases.

IF EXISTS (SELECT TOP 1 *

FROM Tempdb.sys.objects...

I got this below code from sp_helpuser sproc.

This will server your purpose, but you will have to run it on each db seperately.

you can try using "sp_MSForEachdb" sproc...

you can use sp_helpuser

exec sp_helpuser 'tester'

results:

UserName GroupName LoginName DefDBNameDefSchemaNameUserIDSID

tester db_datareader NULL ...

Actual database files are organized on D:,E:,F:,G:

And this crash occured due to multiple power failures. Which makes me think that its the boot sector thats corrupt.

I was thinking that...

Thank you Lynn.. It worked beautifully...

🙂

🙁

Tested that and realized...

Thanks tho..

Thanks Lynn, I will try that!!

Also, Since i already have restored the Full backup can't I do,

RESTORE DATABASE [db1]

NOUNLOAD, NORECOVERY;

and then restore the Differential

Will try both and...

If you have figured out a way to come here with out clicking on the post name(which is blank). I think u have some patience.

Apologise for double posting, but...

Thanks Paul!!

I will test it using the permanent tables.

At this point I think it has to do with the Parameter Sniffing. For this reason (i think), the SQL server...

I tried this, it takes...

Thanks for the response Mohammed!!

I tried the WITH RECOMPILE option, with no effect.

Also, SP_Recompile will recompile the sproc once, in effect doing what With Recompile option is doing...