Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
recreate all Stored Procedures
- Thread starter akbar128
- Start date
ptheriault
IS-IT--Management
You will have to script out all the procedures and re-run the scripts? Do you use embarcadero? If so you can right click on each proc to create a script.
- Paul![[batman]](/data/assets/smilies/batman.gif "[batman] [batman]")
- If at first you don't succeed, find out if the loser gets anything.
- Paul
- If at first you don't succeed, find out if the loser gets anything.
- Thread starter
- #3
ptheriault
IS-IT--Management
akbar,
You have to create the script from your current compiled stored procedures in the database. If you have access to the database and a tool like embarcadero you can create the scripts that will re-create your procedures.
Also,
I'm just curious but why do you think you need to re-create your procedures?
- Paul
- If at first you don't succeed, find out if the loser gets anything.
You have to create the script from your current compiled stored procedures in the database. If you have access to the database and a tool like embarcadero you can create the scripts that will re-create your procedures.
Also,
I'm just curious but why do you think you need to re-create your procedures?
- Paul
- If at first you don't succeed, find out if the loser gets anything.
- Status
Similar threads
- Locked
- Question