General information
Forum:
Microsoft SQL Server
Category:
Stored procedures, Triggers, UDFs
Title:
Recompile SP with changed dependent table or view
Environment versions
SQL Server:
SQL Server 2005
Hello all,
Let's say I have multiple stored procedures that have the following statement:
SELECT * FROM vAview WHERE ...
The statement is to return all columns in the view listed.
Now, today I change the view definition to have more columns. Since I have multiple stored procedures, do I need to manually script each of these and alter the stored procedure by executing these individually or can I do some kind of global recompile? Or is either one of these not necessary?
TIA
Bob
Next
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