Thanks Gail, I ran into the same issue, it helped!

completely agree, was just trying to figure, if there is a way to do it without a code change involved.

The only reason for me to elevate the user permission to...

I am logged in sql as 'dw' login.

When I execute the stored proc

EXEC br_********Data

Error:

Msg 2812, Level 16, State 62, Line 1

Could not find stored procedure 'br_********Data'.

First we tried to upgrade the package using the package upgrade wizard from SSMS, but it failed with the error messages 'Cannot locate the config file at location....'

When we opened...

Yes, All the DBs are restored every night on Test servers, I Refresh Dev Server rarely (running on VM).