Mohit,

I got it. Thanks for/to ALL !:-)

Mohit,

One more question, if the original database has userid [sever01\JoeSmith] and the copied/moved database is not named under [Serve01] but under [Server02] with user id [Server02\JoeSmith], does the mentioned sp...

100 databases to be mirrored! I got my response from the right guy. Thanks again guys !!!:-)

In regards to my suggestion to map the Admistrator/sa to the new SID, the new box/server is just for testing purpose and it is an individual body by itself. ...

Further to my previous response, could I run the sp to the new server's system Administrator or sa instead of "JoeSmith " in order for the application to recognize...

All right! You're the best. Thanks.

Thanks again. This is clear.

The following is SID related but have nothing to do with mirroring.

If the database is moved/copied to another box/server, which has totally nothing...

Thanks again. In regards to the "SID", I have another question which I have not solved so far. I understand, as you have mentioned, within the same domain...

First, thanks to all. I am concentrating on the mirroring database. I have two databases (where there are more databases but only two are my targets) which I need...

Thank you guys for the help. I would test it.

Aapka Dhanyavaad !

I have done the same path you mentioned. I could open everything the database under Server02, and the only left to be done is the application recognized...

😉 I do mean to kill them cause I am not be able to complete the daily backup !

😛 Thanks for the formula, how could I apply the cyanide process,...

Thank you.

Thank you for the suggestion. I am using the "SQL Server Management Studio Express", in which when I right-click the table I do not see "Import/export" as used to...

Thank you guys for the suggestion. Might be I explain like this.

users would choose by checking for either a single salesman or "Select all", when I receive from Reporting...