June 5, 2006 at 1:44 am
I have a specific need to update SYSCOMMENTS >> cText column. Basically my stored procedures and views are having some object owner prefix which I want to replace with other owner id.
I have changed the owner id already, but the T-SQL code needs to be fixed in all the SP's, functions and views for which I thought updating SYSCOMMENTS table would be a fastest way.
June 5, 2006 at 11:20 am
For the TSQL code you will have to PARSE the code. For such action you will be probably better of doing a find and replace from your Source Repository and then try recreating the objects.
Parsing is not one of the finest abilities of SQL server. Oh and make sure you parse the entire text because on any place that you could have made reference to an object with the wrong owner qualifying the changed object and that, has to be fixed
* Noel
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply