Believe I've found the cause. View vw_ec_get1 had been renamed to vw_ec_get2010. Under the covers, when you rename a VIEW (PROCEDURE too?), the original text in syscomments is not updated
. This was verified using this query:
- Code: Select all
SELECT OBJECT_NAME(id), text, * FROM syscomments WHERE TEXT LIKE '%vw_ec_get1%'
The text for both starts
CREATE VIEW [dbo].[vw_ec_get1]
Some other magic comes into play when you use a renamed query as it still works.
It would be nice if SQL Search could be updated to accommodate this, though the built-in information_schema views don't seem to in SQL 2005.