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
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, 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)
Please login to leave a reply, or register at first.