Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
pareshmotiwala
Constraint Violating Yak Guru
323 Posts |
 Posted - 2011-07-15 : 12:08:22
|
| I had a job that was working great till 2 days ago.It run a stored procedure from a win 2008/sql 2008 server to a sql 2005 linked server.2 days ago, it started failing with this message:" The partner transaction manager has disabled its support for remote/network transactions."Google search resulted in stuff that is already there.any insight will be highly appreciated.I also learn that you cannot run stored procedure with transactions on a remote linked server.CheersParesh MotiwalaRegardsParesh MotiwalaBoston, USA |
|
|
yosiasz
Master Smack Fu Yak Hacker
1635 Posts |
Posted - 2011-07-15 : 13:58:54
|
| who owns the linked server?If you don't have the passion to help people, you have no passion |
 |
|
|
pareshmotiwala
Constraint Violating Yak Guru
323 Posts |
Posted - 2011-07-18 : 08:15:12
|
| Hi Yosiasz, thanks for the response. Not sure what you mean by "who owns the linked server" they are all internal servers only.RegardsParesh MotiwalaBoston, USA |
|
|
|
Ambika
Starting Member
4 Posts |
Posted - 2011-07-18 : 08:20:00
|
| fhAmbik |
|
|
|
Ambika
Starting Member
4 Posts |
Posted - 2011-07-18 : 08:23:56
|
| HiIam new member to this forum.I have a database which is not having any configurations like logshipping/mirroring.In that one transactionlog backup job is running.if i take another tlog backup manually.what will happens? will if affect the lsn number and furthur restore proceduresthanks in advanceAmbik |
|
|
|
yosiasz
Master Smack Fu Yak Hacker
1635 Posts |
Posted - 2011-07-18 : 13:56:48
|
| I Meant to ask do you own the linked servers or another team. either way has something changed on those linked servers?If you don't have the passion to help people, you have no passion |
|
|
|
pareshmotiwala
Constraint Violating Yak Guru
323 Posts |
Posted - 2011-07-19 : 07:39:57
|
| I own both servers, but System updates are done by Windows team. It is like a needle in a haystack. I have asked around. Awaiting responses. Most of the tips on MSDN point to MSDTC security configuration which is already there and had never been changed.RegardsParesh MotiwalaBoston, USA |
|
|
|
|
|
|
DTC Error