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

[expired user #9879]'s profile image [expired user #9879] posted 8 years ago in General Permalink

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's profile image TTSneko posted 8 years ago Permalink
  • 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 ...

[expired user #9879]'s profile image [expired user #9879] posted 8 years ago Permalink

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

[expired user #9879]'s profile image [expired user #9879] posted 8 years ago Permalink
  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 ... /

[expired user #9879]'s profile image [expired user #9879] posted 8 years ago Permalink

seems to work fine under 10.0.6000.29

leus's profile image leus posted 8 years ago Permalink

I don't think SQL Server 2000 is supported.

leus's profile image leus posted 8 years ago Permalink

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.