When user has restricted privileges and connect to sql server database from heidiSQL, autocomplete for table names, columns, doesn't work at all and crashes the program. It's because of restricted privileges, this command failed
EXEC sp_helptext 'dbo.DemandsFullText';EXEC sp_helptext 'dbo.DemandsIdFullText';EXEC sp_helptext 'dbo.fn_diagramobjects';EXEC sp_helptext 'dbo.sp_alterdiagram';EXEC sp_helptext 'dbo.sp_creatediagram';EXEC sp_helptext 'dbo.sp_dropdiagram';EXEC sp_helptext 'dbo.sp_helpdiagramdefinition';EXEC sp_helptext 'dbo.sp_helpdiagrams';EXEC sp_helptext 'dbo.sp_renamediagram'; / SQL Error (15197): There is no text for object 'dbo.DemandsFullText'. /
Possible solution: Object, which cannot be discovered - discovery query fails - won't be in the autocompletion and on the other places.
It's common situation, when user has some restriction only for some tables, views etc. For such users heidiSQL isn't mostly usable nowadays.