Well, it's clear that we have different opinions on this. Because this solution works in our shop, I'm not inclined to revert to more tedious technical solutions, but thanks...

My experience is:

- We deployed replication on our clustered 64-bit SQL 2005 nodes.

- We used the built-in GUI to configure transactional replication without incident.

- This is a production environment.

-...

On EMC SANs:

- it it NOT necessary to reboot the server to see a new LUN

Rather:

- open Computer Management;

- click on Disk Management;

- select Rescan Disks from Actions...

- I believe most of your objections refer to earlier versions of SQL Server.

- Please review the following brief discussion in Redmond Developer New of the Replication implementation in SQL...

Question: Why not save yourself a lot of trouble and simply replicate the database tables you need from your ISP to your office SQL server?

- In our shop, we...

Microsoft notes:

- "After migrating an account and maintaining the SID history of the source domain account, when a user logs on to the target domain, both the new SID and...

A brief overview of the process follows:

- Microsoft changed their Cluster terminology a while back: current terminology is "Multi-Node" rather than "Active-Active" or "Active-Passive".

- Each node is...

Fix duplicate parameters in sp_addpublication:

Msg 8143, Level 16, State 1, Procedure sp_addpublication, Line 0

Parameter '@status' was supplied multiple times.

[/*Addition of the publication*/

sp_addpublication

Working sample code to review at:

http://www.replicationanswers.com/Script3.asp

- Hardware upgrades don't clear log files.

- Log archives are not created by default. You can increase the permitted size.

- Different logs have different levels of activity, so their...

The bad news:

- Any user account (Windows or SQL) granted access to a database will have the ability to connect using an ODBC connection. Users can also use scripting code...