|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
|
|
#1
October 3rd, 2004, 11:29 PM
|
|||
|
|||
Rename table
 How to prevent a stored procedure or trigger from being invalidated after renaming a table.I used sp_rename but it does not alter the stored procs and triggers using the table ,is there any way to change all the dependent objects without manually generating the script and then changing it
|
|
#2
October 4th, 2004, 03:38 AM
|
|||
|
|||
|
No, you have to do it uourself.
|
|
| Viewing: Dev Shed Forums > Databases > MS SQL Development > Rename table |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
