|
Posted by SQL on 05/16/06 20:30
try changing this
select table_name from INFORMATION_SCHEMA.TABLES where table_type =
'base table' order by table_name
to this
select quotename(table_name)
from INFORMATION_SCHEMA.TABLES where table_type =
'base table' order by table_name
you probably have a table name with a space in the name
Denis the SQL Menace
http://sqlservercode.blogspot.com/
Navigation:
[Reply to this message]
|