Use SQL Server authentication and grant the SQL login access to both servers and it will work perfectly fine

Regards,

Nesma Mounir

http://nesmamounir.wordpress.com/

Hi,

You can use either SQL transactional or Snapshot replication but i recommend transactional type and based on the size of the database you need to decide the method of initializtation.

if...

Hi,

To see the real memory used by sql server it is enough to execute (on master db):

select * from sys.sysperfinfo

where counter_name like '%Total Server Memory (KB)%'

and if this server...