Anu,

You can write the query output to an output file like .txt or .doc etc. by using OSQL or SQLCMD utilities. These are command line utilities used to execute sql...

Perfect. you are not moving the logins. Just creating the same logins using script i.e copying the logins in another server. Same were existed in A server and B...

Same query by using joins.

SELECT 'customer', count(Customer_id),'SalesOp',COUNT(salesOp_id) FROM Customer JOIN SalesOp ON Customer.CountryCode='vn' and

(SalesOp.programCode='lt' and SalesOfficeCode like 'vn%')

Regards,

Naveen:)

Hi,

From  the above thread, I found that this issue is due to the latency of tlog files that were copied from the primary server to secondary server. To overcome this, disable...

please check the server network addressses of principal, mirror and witness servers and  configure security settings in Mirroring.