Sachin Nandanwar (7/29/2012)

---

Theoretically yes it should work.

But for some reason if you have to re-run the snapshot agent and re-initialize the subscriber then I believe you will need to reset...

I could but have you tried reading about in books online?

http://msdn.microsoft.com/en-us/library/ms175477.aspx

Someone may correct me, but you cant unless its previously been inserted into a table as a filestream. It's not quite the same but as close as you'll get.

You...

If you want to be notified straight away you could create a Server DDL trigger using the ADD_SERVER_ROLE_MEMBER event and use it to send an email and/or log it in...

You could also replicate it to your reporting environment if there...

No problems with it at all.

dan-572483 (7/27/2012)

---

The easiest way is to have the application write values to modifeddate & modifiedby columns when data is changed. You can also create triggers to do this...

I'm a little surprised by this as Transactional and Merge both replicate identities. The destination is usually just a non-identity column.

Are you accidentally using vertical filtering?

It is a requirement for replication that you must use the actual servername.

There are several database roles in MSDB which should facilitate this.

http://msdn.microsoft.com/en-us/library/ms188283.aspx

SQLCrazyCertified (7/23/2012)

---

if you are looking for performance wise it is recommended to create multple secondary(.ndf) files. I am not really sure what's the best practice, I will see...

Making work for yourself there.

This is the preferred method for any migrations involving SQL Logins as the SID's are included and remove the need to fix orphaned logins

I'll follow up by saying that replication to 3rd party customer sites will likely be a logistical nightmare with access policies etc.

Do what you need to do to make the...

Are you effectively providing a reporting mechanism for you customers to look at their history?

Can you publish SSRS reports securely?

Alternatively you could consider

-an XML report delivered by a secure...