This link is for a US government department, it doesn't mention Microsoft or SQL.

I was more asking if anyone has used Microsofts service for SQLRAP or knew anything about it.

Thanks...

I've worked with active - passive, active - active, active - active - active and active - active - active - passive, sorry to labour the point a bit but...

When I did it I initially did but was having problems with the text fields but the small application I found above managed to so all this for you but...

I usually use the job approach on each server but I've just started working at this company and they wanted a more centralized way of controlling the maintenance so it's...

Hi

If you do Yelenas suggestion above remember you need to drop any constraints on any columns you alter first and then put them back on afterwards.

Thanks for the reply.

I'd not used msx/tsx before and it's supposed to be improved on 2005 so I thought I'd give it a go, so far I've been running it...

I had to change collation on a lot of databases a while ago and I used this free open source utility, it saved me a lot of time and from...

I found the answer to this and it's to use sp_msx_enlist on the server you want to become the target.

Hi, thanks for the reply but it's the making a server into a target server and then selecting the master server rather than the event forwarding, I tried your suggestion...

What I was trying to say above was is there anyway of avoiding the time it takes for the maintenance plan to start up or is this just the same...