Activity overview
Latest activity by blueneutron
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:
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. / comments
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 w...
False positives and other incorrect results
I'm seemingly getting false positives and other incorrect results when using SQL Search SQL Search 1.0.0.321. I'm using it with SSMS 10.0.2531.0 to search a SQL Server 2005 database. OS is Windows ...