They are additional functions on the website I posted earlier.

You will need the DatabaseSelect function and maybe the CommandExecute.

you may want to look @

http://ola.hallengren.com/

You can configure the IndexOptimize script to match your needs...

there is a simlar discussion going on...

http://www.sqlservercentral.com/Forums/Topic1002532-263-1.aspx

You could try SQLPing

Glad to hear...

I would follow Gail's advice and run CHECKDB, just to be sure. Plus I alway do this when upgrading a DB.

Enjoy

I would personally apply the latest SP as a minumum. Normally when setting up a new server I add the...

Just to Add to the info Gail has added for 2005... Failover is only automatic of you have a wintess to act a quorum (2 v's 1 vote). In addition...

Just a quick question, have you applied the latest SP/CU?

JL

This link confirms what a few other are says..

Schema options allow you to specify how attributes and objects associated with tables, such as indexes and constraints, are replicated. The behavior...

In addition to the above...

- Check that the Logins exist on the failover partner.

- If you dont have a WITNESS server then consider this msdn article...

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

Steve,

Seems ok now.. Think the dev team worked on an issue this morning... Possible cause?..

It was while you guys in the US was all warm in bed 😉

http://ask.sqlservercentral.com/questions/18299/cant-open-the-spread-phreak-question

Not sure if merge allows it, but in transactional replication you can test the latency of replication with a "trace toker". Just google'd and it isnt. Doh

With a varying number...

Would have pref to see

http://lmgtfy.com/?q=%22isolation+level%22+%22sql+server%22

😉

R2 can be the mirror, but when/if it fails over to the R2 version then it will upgrade the database therefore failing back will not be an option to 2008.