----------------------------------------------------------- New Message on cochindotnet
----------------------------------------------------------- From: jacobseb Message 1 in Discussion Hi, I suppose, many of us have renamed stored procedures, views, functions and triggers several times in the past. Sometimes renaming such objects can give you some trouble. For example, after you rename an object, sp_helptext or OBJECT_DEFINITION will still give you the object definition with the previous name. This can cause problems some times, especially if you use sp_helptext to retrieve the object definition and make modifications to the procedure/function/trigger/view body. I have posted my findings about this here: http://www.sqlserverandxml.com/2008/09/be-careful-when-renaming.html Regards Jacob Sebastian, SQL Server MVP ----------------------------------------------------------- To stop getting this e-mail, or change how often it arrives, go to your E-mail Settings. http://groups.msn.com/CochinDotNet/_emailsettings.msnw Need help? If you've forgotten your password, please go to Passport Member Services. http://groups.msn.com/_passportredir.msnw?ppmprop=help For other questions or feedback, go to our Contact Us page. http://groups.msn.com/contact If you do not want to receive future e-mail from this MSN group, or if you received this message by mistake, please click the "Remove" link below. On the pre-addressed e-mail message that opens, simply click "Send". Your e-mail address will be deleted from this group's mailing list. mailto:[EMAIL PROTECTED]
