Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.

MSSQL case sensitive server server search error?

omegadcuk's profile image omegadcuk posted 2 months ago in General Permalink

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?

Thanks DaveC

Please login to leave a reply, or register at first.




Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.