Hi,

If you look closely you will see Peer to Peer replication is a twisted flavor of Transactional replication where in every node is a publisher and every node is subscriber.

In...

Dear Arooj,

It is a reported BUG. Here is the link for Bug posted on msdn.

You can try your luck with workarounds provided.

https://connect.microsoft.com/SQLServer/feedback/details/342763/sql-server-management-studio-solution-explorer-doesnt-remember-sql-authentication-password

Hope it Helps..!!

Kindly mark it as solution if it...

Dear Arooj,

Which version of SQL server are you using?

Dear Gauri,

You will have to use a table valued split function to cater to this requirement.

A split function will take up the string as 'val1,val2,val3....' and a delimiter which will...

Thank you Jeff and Gila for the clarification. :blush:

No, Simple insert operations does not come under minimally logged operation.

Here is a list of all the minimally logged operations.

http://technet.microsoft.com/en-us/library/ms191244(v=sql.105).aspx

To mention a few

1. Create index

2. Alter index

3. Bulk Insert...

Oops...!! :crazy:

Apologies didn't paid heed to recovery model. Need full Recovery or Bulk logged.

Dear Pradeep,

Not really sure about this, Maybe Gila Can help...

Hi,

Check SQL Server Browser service. Is it ON?

Hi Qira,

Please refer to the below mentioned link for help on how to create a linked server.

http://learnsqlwithbru.com/2012/01/06/create-linked-server-to-connect-to-another-sql-server-part-i/

Very descriptive, Will surely Help.

Hi,

Just a thought..!!

Why not use MERGE to get the data from these tables in your local database.

You can schedule a Job using Sql server Agent to run the Merge command...

Dear Deepak,

why are you using same alias for both the tables??

Share the query so that we can have a better idea of the issue.

Hi,

Work Loss Exposure means how much data will be lost in case of DR scenario.

Bulk logged Recovery model has log backup enabled but use minimal logging for Bulk logged operations....

Dear Arooj,

How did you resolve it?

Hi,

What do you mean when you say

I am guessing you want to restore a copy of the replicated database on...