Phil Parkin (4/10/2016)

---

Satiz (4/10/2016)

---

Hey guys i tried by...

Hey guys i tried by using synonym but...

Thanks, buddy ...I will try by using the synonym.

Phil Parkin (4/8/2016)

---

Satiz (4/8/2016)

---

Phil Parkin (4/8/2016)

---

Satiz (4/8/2016)

---

I will be creating it in staging and will test it if its works fine then i will copy the same procedure and recreate...

Phil Parkin (4/8/2016)

---

Satiz (4/8/2016)

---

I will be creating it in staging and will test it if its works fine then i will copy the same procedure and recreate it prod without...

Hi guys thanks for your replies.I tried to convert it dynamically but it is not working as expected can anyone please guide me .....

ALTER procedure [dbo].[load_orders] ...

This procedure will be called in SSIS package .

I will be creating it in staging and will test it if its works fine then i will copy the same procedure and recreate it prod without making any modification...

Thanks for your reply .I need to change this dynamically because database name differs in both staging and production environment so we will passing database name as a parameter...