I'm not completely clear on what you intend to do. Is this a single, 2 node cluster with 2...

Off the top of my head.

Index fragmentation

Statistics out of date

Different excecution plan

Different settings (arithabort, language etc)

Its a standard database so all the same rules apply. You may want to consider stopping the logreader and distribution agent whilst doing this to speed things up but...

Use sp_help_revlogin to reverse engineer the instance's logins (see ms website)

I use this to generate the statements to reapply the server roles to logins.

select 'exec master..sp_addsrvrolemember @rolename = N''' +...

I've done a number of things since school

College years

McDonalds "crewmember"

Supermarket stacker

Computer store cashier

Circumstances caused me to leave college and do manual work

Warehouse line worker

Forklift driver

Completed MCSE Win2k

Network technician (jack of...

I'm always amused these discussions as "best practice" says we should always provide committed accurate data but as always it depends. It goes against the grain for many.

You should...

Is this as simple as refreshing object explorer since the restore is at 100%?

Is the query still showing as "executing"?

You can.

The subscribers can only be the same version or 2 lower to the publisher. You need to be aware of datatype and feature differences used across versions.

Otherwise its...

Stephen Keating (11/4/2011)

---

I am having a problem adding a column to a table that is replicated using transactional replication.

There are custom insert and update stored procedures for the table, and...

Have you checked which article the id ties to in sysarticles in the published db? You could find invalid meta data is the cause.

What other investigations have you done?

It will be a network issue rather than sql server and based on the location it is likely to be network lag causing the error.

We get this on occasion going...

Sorry, the answer to this particular question is, no...

Chuck Hottle (11/2/2011)

---

Does anyone know if it is possible to change the distributor for a publisher without dropping and re-creating replication or running new snapshots? It doesn't appear that...

Depends a little on what your business is willing to accept or spend.

I run a weekly full backup and daily diffs. I also run 5 minute transaction log backups...

SQLArcher (10/28/2011)

---

The article doesn't state that it is not recommended on a cluster, the article states that it is not recommended to configure SSIS as cluster resource.

To install SSIS on...