Ok I guess in order to be sure about the setup I need to recreate a disaster :D'

Oh one more Q, hope last one, I am looking at the mirroring...

OK I got it, one more thing, is there any way to test the setup without actually taking down the principal server?

So do I setup witness on mirror server, principal, or both?

The error is "The server network address: "TCP://sqlsvr2.domain.com" can not be reached or does not exists. Check the network address name and that he ports for the local and...

Anyone, pllllllllllllllleeeeeeeeeease!!!!

I assume that "chanel" is looping with the rest of the records, is there a way to set "chanel" to be a root of the xml just like "rss" is?

I got it figured out, i misspelled the folder name.

Another issue thou, didn't see it before cuz I was selecting only one record.

This is my SP:

WITH XMLNAMESPACES (

...

Anyone?

ok, here it is; It's all about users creating/saving job searches and based on their setting they get results emailed to them. So i have USER table which contains...

$$ is negotiable, after I give details you can tell me what will it take.