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!!!!!!!!!!!! SQL SERVER ERROR (208)

marce002's profile image marce002 posted 3 years ago in General

I keep getting this error

Error de SQL (208): El nombre de objeto 'BD' no es válido.

what does it mean?

sql server 08

ansgar's profile image ansgar posted 3 years ago

I guess that means "The name of the object 'BD' is not valid" ?

marce002's profile image marce002 posted 3 years ago

I guess that means "The name of the object 'BD' is not valid" ?

Yes but the name is correct!!



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's profile image marce002 posted 3 years ago

SQL VER 10.0.6000.29 works fine

leus's profile image leus posted 3 years ago

@ansgar, I think SQL Server 2000 uses a different syntax to get object names.

DECLARE @SQL varchar(8000)
SET @SQL=''
SELECT @SQL=@SQL+'UNION
select 
'''+d.name+'.''+sh.name+''.''+o.name,c.name,c.colid
from '+d.name+'..syscolumns            c
    inner join sysobjects  o on c.id=o.id
    INNER JOIN sysusers  sh on o.uid=sh.uid
'
FROM master.dbo.sysdatabases d
SELECT @SQL=RIGHT(@SQL,LEN(@SQL)-5)+'order by 1,3'
--print @SQL
EXEC (@SQL)

See http://stackoverflow.com/questions/2729126/how-to-find-column-names-for-all-tables-in-all-databases-in-sql-server

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