You need to restart the SQL server after turning off ANSI_WARNINGS. Forgot to mention that.. Joe
----- Original Message ---- From: "Opela, Gary L Contr OC-ALC/ITMA" <[EMAIL PROTECTED]> To: [email protected] Sent: Wednesday, March 21, 2007 4:26:30 PM Subject: Re: MS SQL on Win 2k -> Win 2k3 issue Well, I'm at a loss.... I've tried everything I can find on ARSList, Nabble, mattrienfelt.com, as well as MS website. I have asked the DBA if he can check with a server guy to see if the remote server has windows firewall running. One of MS's articles said the firewall blocks outgoing DTC traffic, which also seems that it could cause what I'm seeing. For some reason, I'm doubting that this will resolve anything. Oh, by the way, I opened my ticket with remedy 8 days ago, 7 days ago they asked me for log files, which I promptly sent them, and they've yet to respond to me, even though I've emailed them twice more since then... What great support. They can probably see that I'm working on it here, so they've put it on hold I'll bet... Gary ________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Joe DeSouza Sent: Wednesday, March 21, 2007 3:14 PM To: [email protected] Subject: Re: MS SQL on Win 2k -> Win 2k3 issue Try switching off ANSI warnings.. It may help.. Joe ----- Original Message ---- From: "Opela, Gary L Contr OC-ALC/ITMA" <[EMAIL PROTECTED]> To: [email protected] Sent: Wednesday, March 21, 2007 3:50:00 PM Subject: Re: MS SQL on Win 2k -> Win 2k3 issue ** Wow, thanks. I can believe that, judging by the mass confusion of all of my DBAs. Stephen has pointed out several other posts where users had similar issues. I’m going through and trying all of their different things right now that helped them. So far, no luck. I’ll look at the MS article below in a minute. I already sent one MS article I found on similar issues with DST to my DBA, and he tried configuring the DST service the same way that the article said, and that’s what got us to where we were. Before I started getting this error, my query would just hang. I’ll keep you guys posted. ________________________________ From: Action Request System discussion list(ARSList) [mailto: _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" ____________________________________________________________________________________ Sucker-punch spam with award-winning protection. Try the free Yahoo! Mail Beta. http://advision.webevents.yahoo.com/mailbeta/features_spam.html _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
