[SQLDownUnder] Cross server queries, and database movement.

[Clint Colefax]

Hi all,

 

We have a series of stored procs that do cross server queries, this is fine and works with no problem, however, we regularly restore this production database to dev environments, and the sp’s break due to pointing to the live db.

 

I am wondering how other people handle this sort of issue. When have a couple of solutions, from dynamic sql, to agent jobs that update the sp definition once moved, but there has got to be a better why.

 

Thanks

 

 

Clint Colefax   |  Solution Developer 
Microsoft Certified Solution Developer (MCSD)

Application Services Department
Data Aspects Pty Ltd

Level 2
87 Upton Street
Bundall QLD 4217
Ph	+61 (0)7 5579 2233
Fax	+61 (0)7 5579 2234
http://www.dataaspects.com.au/

“Your IT Partner from Every Aspect”

 

 

 

 

This email and the files attached hereto may contain confidential information which may be legally privileged.  It is solely for the use of the intended recipient.  Any disclosure, modification, copying or distribution is prohibited and may be unlawful.  If you are not the intended recipient, please inform the sender and delete it immediately.  Any views expressed in this email are those of the individual sender and may not necessarily reflect the views of Data Aspects Pty Ltd.

 

to unsubscribe to this list, please send a message back to the list with 'unsubscribe' as the subject. Powered by mailenable.com - List managed by http://www.readify.net