The better way would be...incase if you know that you already have a login for the orphaned user. You can use this command alter user <username> with login = <login...

If you can't take an exclusive lock on the db, try kicking off users out of this db (make sure by running sp_who2) nobody is using that db, place it...

Could you pls. provide some more details from the logs.

Regards,

Faisal

Check out this link, it's almost a replica of what you're facing. I hope this helps!!!

http://manage-sqlserver.blogspot.in/2011/06/unable-to-install-sp4-due-to-missing.html

Regards,

Faisal

sqlfriends (1/17/2013)

---

Thanks, that works for SQL 2008. But it seems you cannnot export that from sql 2008 to SQL 2012.

Also can anyone explain what is the difference about local server...

I'll only enable TF 1118...only if I have TempDB contention and even if splitting the files doesn't help. However, as Sql Server Best Practice Analyzer suggests you should add this...

Unless your users have specific interest in using that index as an hint, thereby forcing the optimizer to think that you're smart enough to trick it. Apart from this I...

I believe read/write permission should go well with the account that you're using to back those db's of your's onto a shared path. If you know how to configure the...

[font="Comic Sans MS"]Hi tpprometer.

As per your question "I just can't figure out how to get a job that is running on server A to restore the database on server B.".As...

Thanks. for a quick response Ignacio.

To answer your questions, no I didn't search anything on google yet. I suppose these forums are meant to help others find what they are...

Thanks. a lot once again, and really do appreciate what you guys say. I'll try to figure out how best I can utilize the info provided by "sestell1". Pls. pardon...

Hi Lynn,

You are absoultely right here, that one gets a better understanding of things when they write the code themselves, and I really respect that. Currently, I am in a...

Thanks. for pointing that out, but I may have ended up requesting this accidently. Is there any option to delete this post from this section?

Regards,

Faisal Farouqi

Thank you guys, but frankly speaking I kind of need a general script which can be run by changing some parameters, and then it should loop through all linked servers,...