Thanks Greg. Link works out for me....

Thank you...

Greg Charles (5/27/2009)

---

Please clarify whether this is a DTS package or an SSIS package. In either case, logging must be enabled in the package before any logging takes place...

Gents,

I really APpreciate your suggestions. I'll update you all if I anything works out for me.

Rishabh

unfortunately Client is not paying for Witness server.

Thanks to All for your replies. I'll update you if I come with any automatic solution. otherwise I'll run sp_change_suers_login Command manually.

Thanks

Rishabh Gupta

there are some users which I have to create and it is giving me

Windows NT user or group[....Server name....]not found. Check the name again

am totally confused now.

I ran sp_help_revlogin on Primary server and copy script and run onto Secondary server.

It gives error that SPID is in use. and when I change query from Create login to...

we are using SQL auth 🙁

Yes,

I have Mirroring ON. Only problem is I have to run sp_change_users_login everytime to make Secondary work as Princiapal when Primary is down.

I have to run sp_change_users_login on Secondary server every time Primary server goes down. I am looking for automatic solution that when ever Primary goes down. Secondary will start working...

I checked at Support.microsoft.com

here is the link http://support.microsoft.com/kb/918992

in the remarks it said

"If server A and server B are in different domains, you have to modify the output...

Nicholas,

Can you tell me how to run "sp_helprev_login " and how to apply script on standby server?

Am pretty new to SQL server.

Grumpy DBA (11/6/2008)

---

I think you have a couple of options (feel free to correct me if any of these are not feasible):

* Log onto the local machine as a local...

I think you can install SQL in C drive and save the data (mdf) file and log (ldf) file in D drive.

Jeff Moden (10/28/2008)

---

rishgup (10/28/2008)

---

Jeff,

By identity column you mean IS IDENTITY = 'TRUE' which will...