In execution or in the batch file?

Batch file will need a seperate tool.

In SSIS, google "SSIS event handlers". There is an error event and this can include an email...

Stefan Krzywicki (4/20/2012)

---

GilaMonster (4/19/2012)

---

Personally I'm voting for 'ignore the trolls'

#declare NewTopic;

Who plays MMOs and which ones?

I've just quit the one I played for a few years, they added a...

liteswitch (4/20/2012)

---

Thanks for the responses. And yes, just to clarify, my requirement would be to have both clusters available for read/write operations simultaneously, with the write operations synchronised between the...

I jumped the gun above by assuming this was for business continuity.

liteswitch (4/20/2012)

---

The two clusters may or may not be in the same physical datacentre. However, if I wanted both...

For simplicity in the set up there's no reason for this to be two clusters. This can be a single cluster spread over two sites using SAN replication to...

Does the job have a retry or multiple schedules?

Can you script out and supply the job?

george sibbald (4/18/2012)

---

I intend to apply SP1 to a SQL2008R2 RTM active\passive geocluster.

Due to current issues with the disks with automated failover the passive node is paused to allow manual...

Check this table for the duplications

SELECT *

FROM [msdb].[dbo].[sysmail_mailitems]

I've never had it where SQL would send two emails. This is all driven by database tables and an executable. I would er towards checking my email client...

There's no way round it because of this statement. You have to set up a scheduled restore on "Server B"....

We use it and it works very reliably in our enviroment. Never had an issue with it to my knowledge.

If theres an issue with a server in the load...

We do it via transactional replication and Citrix netscalar.

This is only readonly so you would have to do your homework on making it work as a read/write solution. It...

SQL version numbers for both instances please?

Also, how is the data getting "refreshed"?

Has the data changed in live since the refresh so that the query returns only on live?...

My largest system is currently running with 3 billion rows in single unpartitioned heap. It still works just fine as a backend to an extremely busy website.

In terms of...

SQLKnowItAll (4/16/2012)

---

My guess is that they are identical in structure, but not in terms of data; i.e. rules for primary keys can be managed by (just as an example) IDENTITY(1,3)...