Hi there,
I hope someone can help me here as this is driving me nuts...! Ok - I have an application which calls stored procedures from two machines:
1. Windows 2003, SQL 2005
2. Windows 2003, SQL 2000
If I call the stored procedure on server1, everything works ok. If the same stored proc is called on server2, I get the "syntax error or access violation" error reported. As far as I can see, I have the same setup in DTC permissions on both machines and the user running the stored proc is DBOwner. I feel like I have missed something simple and this is taking WAY too much time to sort out so can someone please help?!
By the way the stored proc contains a query running a simple select statement (not even any parameters) - and is most definitely not a problem. Additionally, the query can be run fine from query analyzer.
I hope someone can help me here as this is driving me nuts...! Ok - I have an application which calls stored procedures from two machines:
1. Windows 2003, SQL 2005
2. Windows 2003, SQL 2000
If I call the stored procedure on server1, everything works ok. If the same stored proc is called on server2, I get the "syntax error or access violation" error reported. As far as I can see, I have the same setup in DTC permissions on both machines and the user running the stored proc is DBOwner. I feel like I have missed something simple and this is taking WAY too much time to sort out so can someone please help?!
By the way the stored proc contains a query running a simple select statement (not even any parameters) - and is most definitely not a problem. Additionally, the query can be run fine from query analyzer.