Restore table from tape

I have a static table that I restored from tape to a new db name on same ser
ver as production db. I'm trying to restore one table that was accidently de
leted from production db. However, when I run a "select 'tablename' into 'pr
oduction db' from'backed up
db' in Query Analyzer I get invalid object name. I also cannot browse (all r
ows) this table in Enterprise Manager but I CAN return all rows when I do a
'select * from 'tablemname' in query analyzer.
I'm stumped. Can someone help? I stopped and re-stared SQL Server with no su
ccess after I restored with no success.
Can anyone help?Nathank,
You pseudo-code syntax is incorrect. It should be "select 'column list' into
'production db..tablename' from'backed up db..tablename'. If this is not th
e issue, please supply the actual query being used.
Norman|||If the object name has spaces ,etc in it you must use sqaure braces ie
select * into [funny table] from otherdb.dbo.[funny table]
Regarding seeing the rows in SEM, if there are a LOT of rows, sometimes SEM
has a problem showing them (especially if memory is low)
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Nathank" <anonymous@.discussions.microsoft.com> wrote in message
news:E7BCB601-AABD-47D0-9FF2-C4F520A80278@.microsoft.com...
> I have a static table that I restored from tape to a new db name on same
server as production db. I'm trying to restore one table that was accidently
deleted from production db. However, when I run a "select 'tablename' into
'production db' from'backed up db' in Query Analyzer I get invalid object
name. I also cannot browse (all rows) this table in Enterprise Manager but I
CAN return all rows when I do a 'select * from 'tablemname' in query
analyzer.
> I'm stumped. Can someone help? I stopped and re-stared SQL Server with no
success after I restored with no success.
> Can anyone help?sql