Hi just discovered HeidiSQL and trying it out as an addon to MSSQL for searching data/stored procedures as M$ offering is so slow and cumbersome. I like the lightweight approach and especially the filtering of table/proc/func etc - very nice ;)
I am trying to find a stored procedur that contains a particular table acess so basically i am using Search > Find Text on Server (defaults) and it comes back with a list of stored procedures but each one has the error:
SQL ERROR (208) Invalid Object Name 'INFORMATION_SCHEMA.routines'
I expect this is because our server is case sensitive and the name of the table should be ROUTINES.
Is there any fix for this?