Backup/copy store procedure - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

Backup/copy store procedure

Author

Topic

alanhuro
Starting Member

34 Posts

Posted - 2008-07-18 : 08:28:54

Hello All,

I love this forum so keep coming back for more. I see a lot of people from India so greeting to India. Wonder what time it's overhere since i'm at esterm time stamp and at work

.

Yesterday I screwed up quite few store procedures but manage to restore it. To avoid the same mistake again I wonder is there anyway I can copy or backup the store procedure from one database and dump it to another? Most of store procedure are encryted.

Thanks

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-07-18 : 09:05:41

quote:
Originally posted by alanhuro

Hello All,

I love this forum so keep coming back for more. I see a lot of people from India so greeting to India. Wonder what time it's overhere since i'm at esterm time stamp and at work .

Yesterday I screwed up quite few store procedures but manage to restore it. To avoid the same mistake again I wonder is there anyway I can copy or backup the store procedure from one database and dump it to another? Most of store procedure are encryted.

Thanks

So you don't see anything about us

Script your stored procedures with generate script task or Use SSIS (transfer object task) to migrate .

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-07-19 : 13:29:38

You can't script encrypted sp.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources