August 25, 2009 at 2:24 pm
If your DBA isn't giving the permissions you need to move things around, then wouldn't moving them around be the DBA's problem and not yours?
The Redneck DBA
August 26, 2009 at 1:42 pm
Not sure why the Encrypted Procs in prod on the 2005 box is an issue. Aren't the procs that you truly need to access in the 2000 box? Secondly you don't need dbo to be able to modify procs. Third, I would agree with your DBA - production is off limits. If a proc needs to be moved/promoted it should go through the proper channels. Typically to prod that should involve the DBA group and/or the server team.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 2 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply