August 25, 2009 at 1:19 pm
Hello,
We are moving our DB from SQL Server 2000 to SQL Server 2005. One issue we have is
in SQL Server 2005, all of the Stored Procedures and Triggers are encrypted.
If the DBA gives me the dbo role, I can access the procedures,triggers. But they would
not give the developers the dbo role on Production DB.
Is there a workaround available? I would appreciate your help.
Thanks
Yasir
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 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply