This problem came about because the remote server had been redeployed and the new linked server object I had created did not work in the same way as the old...

thanks for the help. It was the linked server setting to use remote collation that was causing my conflict(it was set to false). once set to true, I no longer...

That worked great. Thanks.

Any idea why I would have to specify collation when they both were indentical?

check out this link as well.

http://technet.microsoft.com/en-us/library/ms190730.aspx

can you post me the out put of your sp_configure for the awe enabled and max server memory rows, before and after you change settings?

as i stated I have no experience with A/A clusters (only A/P) so i don't know if is changing settings on one affect the other or not. In A/P i...

I have no experience with active/active cluster but is it possible that one active server causing the other to revert settings back.

as for the 64GB of RAM, Enterprise...

worked perfectly. Thanks alot Michael

thanks rberry, thats an interesting option except i dont have the luxury of changing the behavior of the application from using a view. Personaly, it gives me more insight on...

Thanks for your replies. Answers my question perfectly. I will have to find a different way to accomplish what i am trying to do. thanks

I found a solution. I used sp_help_revlogin SP to create script of login on primary server which includes SID, which was the piece i was missing to associate the login...

Thanks for the reply.

what it looks like to me is there are articles in the publication but no tables, only views. I went through the publication setup again and I...