Ads were blocked by your webbrowser.

This is not a problem, but keep in mind that developing HeidiSQL, user support and hosting takes time and money.

You may want to send a donation instead.

PLEASE WHAT A SHAME HEIDISQL COMUNITY!!! noone can help me with simple easy to fix SQL SERVER ERROR (208)

marce002 posted 3 years ago in General

Some data browse operations through me ERROR 208 with a simple SQL SERVER 2008 and Windows authentic. and TCP IP connection.

Some other tables does not give me any error... error is always the same!

"The name of the object 'xxxxxxxxxx' is not valid"

I know it should be a stupid fix, that is why I insist to ask!!!!

TTSneko posted 3 years ago
  • why did you open a new thread?
  • why are you SHOUTING?!?!
  • why this "Noone can help me" piss-pony attitude?
  • why no code snippet or further explanation?

Well now that you have shown us all that you are a little bit on the dim side, may we now please see more of the code which causes the problem ? Screenshots of the setup? For example the name itself may be correct, but the charset you use may be illegal in the used context (different UTF8 subsets between tables)? I mean, how is anybody going to know? We are not psychic half-gods or have a secret backdoor to your PC.

Of course you should use this (or your other thread) to post the additional info, no need to start a third. In fact I believe that most people will simply IGNORE you if you open yet another thread ...

marce002 posted 3 years ago

TTSneko understood you are right,,, i will provide required extra info at the office on monday, it was a fast andry post, because I though it was a common problem because it happened me on every SQL SERVER & heidi... ill be back again.. thks in advance



Ads were blocked by your webbrowser.

This is not a problem, but keep in mind that developing HeidiSQL, user support and hosting takes time and money.

You may want to send a donation instead.
marce002 posted 3 years ago
  1. SQL VeRSION is 8.00.2055
  2. Windows Authentication is used
  3. Last heidi version is used: 9.30.5086
  4. "data" is not available for any table but I can see the TREE correctly 5 I simply expected the DATA button to simply do a select top 1000 * from tablename, but it is more comlex that, that...wonder if can this be changed somehow

Error log is:

/ DBtreeFocusChanged, Node level: 3, FTreeRefreshInProgress: 0 / / SetDatabase(BD_Munic1), FDatabase: BD_Munic1 / / Ping server ... / SELECT FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_CATALOG='BD_Munic1' AND TABLE_NAME='localizacion'; / Result #1 fetched. / / Ping server ... / SELECT c.name AS "column", prop.value AS "comment" FROM sys.extended_properties AS prop INNER JOIN sys.all_objects o ON prop.major_id = o.object_id INNER JOIN sys.schemas s ON o.schema_id = s.schema_id INNER JOIN sys.columns AS c ON prop.major_id = c.object_id AND prop.minor_id = c.column_id WHERE prop.name='MS_Description' AND s.name='' AND o.name='localizacion'; / SQL Error (208): El nombre de objeto 'sys.extended_properties' no es válido El nombre de objeto 'sys.columns' no es válido. / / SQL Error (208): El nombre de objeto 'sys.extended_properties' no es válido El nombre de objeto 'sys.columns' no es válido. / / Ping server ... / / TfrmTableEditor.Init, using object "localizacion" / / Fetching list of collations ... / / Ping server ... / / Ping server ... / SELECT FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_CATALOG='BD_Munic1' AND TABLE_NAME='localizacion'; / Result #1 fetched. / / Ping server ... / SELECT c.name AS "column", prop.value AS "comment" FROM sys.extended_properties AS prop INNER JOIN sys.all_objects o ON prop.major_id = o.object_id INNER JOIN sys.schemas s ON o.schema_id = s.schema_id INNER JOIN sys.columns AS c ON prop.major_id = c.object_id AND prop.minor_id = c.column_id WHERE prop.name='MS_Description' AND s.name='' AND o.name='localizacion'; / SQL Error (208): El nombre de objeto 'sys.extended_properties' no es válido El nombre de objeto 'sys.columns' no es válido. / / SQL Error (208): El nombre de objeto 'sys.extended_properties' no es válido El nombre de objeto 'sys.columns' no es válido. / / Ping server ... / SELECT FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_CATALOG='BD_Munic1' AND TABLE_NAME='localizacion'; / Result #1 fetched. / / Ping server ... / SELECT c.name AS "column", prop.value AS "comment" FROM sys.extended_properties AS prop INNER JOIN sys.all_objects o ON prop.major_id = o.object_id INNER JOIN sys.schemas s ON o.schema_id = s.schema_id INNER JOIN sys.columns AS c ON prop.major_id = c.object_id AND prop.minor_id = c.column_id WHERE prop.name='MS_Description' AND s.name='' AND o.name='localizacion'; / SQL Error (208): El nombre de objeto 'sys.extended_properties' no es válido El nombre de objeto 'sys.columns' no es válido. / / SQL Error (208): El nombre de objeto 'sys.extended_properties' no es válido El nombre de objeto 'sys.columns' no es válido. / / Ping server ... / SELECT FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_CATALOG='BD_Munic1' AND TABLE_NAME='localizacion'; / Result #1 fetched. / / Ping server ... / SELECT c.name AS "column", prop.value AS "comment" FROM sys.extended_properties AS prop INNER JOIN sys.all_objects o ON prop.major_id = o.object_id INNER JOIN sys.schemas s ON o.schema_id = s.schema_id INNER JOIN sys.columns AS c ON prop.major_id = c.object_id AND prop.minor_id = c.column_id WHERE prop.name='MS_Description' AND s.name='' AND o.name='localizacion'; / SQL Error (208): El nombre de objeto 'sys.extended_properties' no es válido El nombre de objeto 'sys.columns' no es válido. / / SQL Error (208): El nombre de objeto 'sys.extended_properties' no es válido El nombre de objeto 'sys.columns' no es válido. / / Ping server ... / SELECT FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_CATALOG='BD_Munic1' AND TABLE_NAME='localizacion'; / Result #1 fetched. / / Ping server ... / SELECT c.name AS "column", prop.value AS "comment" FROM sys.extended_properties AS prop INNER JOIN sys.all_objects o ON prop.major_id = o.object_id INNER JOIN sys.schemas s ON o.schema_id = s.schema_id INNER JOIN sys.columns AS c ON prop.major_id = c.object_id AND prop.minor_id = c.column_id WHERE prop.name='MS_Description' AND s.name='' AND o.name='localizacion'; / SQL Error (208): El nombre de objeto 'sys.extended_properties' no es válido El nombre de objeto 'sys.columns' no es válido. / / SQL Error (208): El nombre de objeto 'sys.extended_properties' no es válido El nombre de objeto 'sys.columns' no es válido. / / Ping server ... / SELECT FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_CATALOG='BD_Munic1' AND TABLE_NAME='localizacion'; / Result #1 fetched. / / Ping server ... / SELECT c.name AS "column", prop.value AS "comment" FROM sys.extended_properties AS prop INNER JOIN sys.all_objects o ON prop.major_id = o.object_id INNER JOIN sys.schemas s ON o.schema_id = s.schema_id INNER JOIN sys.columns AS c ON prop.major_id = c.object_id AND prop.minor_id = c.column_id WHERE prop.name='MS_Description' AND s.name='' AND o.name='localizacion'; / SQL Error (208): El nombre de objeto 'sys.extended_properties' no es válido El nombre de objeto 'sys.columns' no es válido. / / SQL Error (208): El nombre de objeto 'sys.extended_properties' no es válido El nombre de objeto 'sys.columns' no es válido. / / Ping server ... / / Ping server ... /

marce002 posted 3 years ago

seems to work fine under 10.0.6000.29

leus posted 3 years ago

I don't think SQL Server 2000 is supported.

leus posted 3 years ago

By the way, is it possible to edit the title of this thread? It's childiness is unbearable.

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