OK...in the spirit of SQL questions being answered the last couple days, i have one that i could REALLY USE SOME HELP WITH.
I am about to tear my hair out here.
In a basic explanation, we are trying to setup a test environment for an application I am building. There are some existing Stored Procedures and they reference a linked server to do some of the work.
For Example:
the stored procs reference dbname.dbo.table where "dbname" is a linked server.
For the test environment, we want to create a linked server by the same name, only it points to the test db on another server "testname" that is exactly the same as production. So do avoid having to change all the names in the stored proc
The problem is we get all kinds of DTC errors depending on what options we try, but they are basically all like "cannot find 'dbname' in syslinks" or "cannot start Distributed Transaction."
its driving me crazy...can anybody give me a link or a step by step on how to do what i am describing above. PLEASE...
drew
You can always create a vew, which selects a linked table. This would be helpful transitioning from development to production environments. Create the view with same name in both environments which point to the corresponding linked table, dev or prod. In SQL 7 and later, you can do inserts, updates and selects on views.
CREATE VIEW viewName
AS
Select *
from linkedtabe
does the linked server run on a non-standard port?
i *always* use a port other than 1433 for production SQL servers, even if they're not in the open and firewalled.
if so, it could be that it's missing a setting and tries to access it through the standard port ...
just blurting out stuff ...
Andy
I'm back..sorry fighting a cold i had to rest for a bit.
i appreciate the blurting im sending along everything you guys are saying to the DBA.
I am going to try a couple more things ill get back to you.
Powered by Invision Power Board (http://www.invisionboard.com)
© Invision Power Services (http://www.invisionpower.com)