Hey Jessie,

The code is great but it seems that it doesn't do what I wanted. I don't want to set it up across all the instances, instead I would rather...

Thanks. for that code Jessie.

I really need the body part formatted that can give me the details what I am looking for the way it's there in the image...

Great!!!

Guys, if you have something different pls. do come up with some other useful stuffs maybe something more in t-sql or powershell. I still need to get only dbcc...

Hi Vedran,

Thanks. for those piece of advice. Could you document one way to do this along with the code & procedure to run it successfully. I would really appreciate!!!

Regards,

Faisal

Thanks. a lot anthony.

May I know where I can find this table "config.alertemails" mentioned with this statement "SELECT @EmailAddress = EmailAddress FROM CONFIG.AlertEmails WHERE Alert = 'DBCC.CheckDBDetailsEmailTrigger". I don't see...

Thanks. to all you guys.

I've finally come up with a script that does the trick for me, and can be helpful for others as well. Now, here are the problems...

How can you be so sure that the values which are generated at the publisher could be same at the subscriber as well. Did you check what's being replicated at...

Hi Ratheesh,

If that's a prod box then you have 2 options left, either restore a copy of that db to a test environment, and run dbcc checks on that. In...

Thanks. a lot anthony. I really appreciate your help. I'll still test this thing up, in my environment and will get back to the topic in a few days. One...

Hi anthony,

Thanks. for the reply I can get a send mail function, but I just need a complete structure in order to get this working. I believe setting up a...

I think you seem to be a bit confused here. If you want to create a linked server from suppose server a to server b, as you mentioned the only...

Try disabling UAC:

Here is the complete process on how to proceed with this:

Go to Command prompt and run the below command to disable the UAC

Reg.exe ADD HKLM\SOFTWARE\Microsoft\Windows\CurrentVersion\Policies\System /v EnableLUA /t...

Hi charipg,

Execute the script from the support document: http://support.microsoft.com/kb/969052

It will tell you the information about the missing msi/msp files along with the location where you can find it. Probably...

I believe your topology suggests that you should go with manual identity management.

Since, you are trying to manage identity values manually, first & foremost you should be sure enough that...

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