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.

All Forums  SQL Server 2008 Forums  Transact-SQL (2008)  Linked server - UPDATE AND INSERT dilema

Author  Topic  koo9 Starting Member 1 Post Posted - 2013-11-28 : 16:10:46 hi all, we are using linked server and use stored procedure to update data in another sql server. the problem is there are a few environments here. Dev, UAT and prod. the problem is in each environment the sql server database is different. so if hardcoding the fully quality object name in the distributed query in the stored procedure, it won't work for the next environment. I try not use EXEC to execute dynamically built query because that's too painful since openquery does not support parameters. it seems like the category and schema part of the distributed query can be skip like this linkservername...[tablename], but don't seem to work. any ideas? Thanks Mike