Hi,
This is not strictly Delphi question, but I use Delphi
ADO to access it.
I use MS SQL Server 2000 here, and have many stored
procedures and UDFs defined.
Every time I made some changed to tables (mainly add
new columns), some SP or UDF failed to get correct result, usually column
mismatch. I have to modify the SP/UDF to force it
recompile.
The problem is I have many SP/UDFs, and it's
unpractical to find every SP/UDF references the table I changed and open/change
them. I tried to run 'sp_recompile tablename', but it doesn't help
much.
So, does anyone out there know how to force SQL
Server automatically recompile all SP/UDFs when I changed the
table?
BTW, I use SQL Server Enterprise
Manager.
Thanks,
Edward
|
Title: Message