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.
| Author |
Topic |
|
toididau
Starting Member
3 Posts |
 Posted - 2008-02-29 : 10:11:16
|
| Good morning,I'm very new to SQL Server 2000(Oracle is all I've been doing) and need your expertise.I'm in the process of deploying user-defined functions, which currently reside on the test server, into production environment.What are the basic steps I should do? I can maneuver around but they're very messy.Thanks for all your help.Regrads,Jay |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-02-29 : 11:22:00
|
| You can Script the user defined Function and apply to production Server But you need to make sure Database exists on Prod server. |
 |
|
|
toididau
Starting Member
3 Posts |
Posted - 2008-02-29 : 12:31:07
|
| Hi sodeep,Thanks for your quick reply. I ran the Generate Script and produced a SQL Script file.Now I'll take this file to the production server and apply it. How do I do this?Database is ready.Thanks again.Jay |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-02-29 : 12:37:08
|
| Generate Script only for UDF. and apply in Prod server using Query analyzer. |
|
|
|
toididau
Starting Member
3 Posts |
Posted - 2008-02-29 : 13:07:54
|
| Thanks again sodeep. It worked perfectly.Regards,Jay |
|
|
|
|
|
|
User-defined functions