General information
Forum:
Microsoft SQL Server
Category:
Stored procedures, Triggers, UDFs
Hello Sim,
>>I found that all stored procedures code are stored
at syscomments ctext and text columns, but ctext is
some binary data, so how can I go about updating it ?
As Ric said, usually one would drop the old SP, then create the new SP. AFAIK, Microsoft does not publish the information you're asking.
Side note: With Sql 2005, it looks like you could create your own SP in a managed language, and even late bind to it. Cool.
Mike
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only