PLEASE!!!!!!!!!!!! SQL SERVER ERROR (208)

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

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 8 years ago Permalink

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

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

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

Yes but the name is correct!!

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

SQL VER 10.0.6000.29 works fine

leus's profile image leus posted 8 years ago Permalink

@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.