RE: CPYF in SQL Server

[Adam West <adamster@xxxxxxxxx>]

this is the error:
(122226 row(s) affected)
Msg 156, Level 15, State 1, Line 1
Incorrect syntax near the keyword 'where'.
Processed 30744 pages for database 'Tempbackupsop10200', file 'TempBackupsop10200' on file 1.
Processed 1 pages for database 'Tempbackupsop10200', file 'TempBackupsop10200_log' on file 1.
BACKUP DATABASE successfully processed 30745 pages in 126.657 seconds (1.988 MB/sec).
and this is the statement
 
CREATE DATABASE TempBackupsop10200
go
SELECT * INTO TempBackupsop10200.dbo.sop10200 FROM pbs.dbo.sop10200
go
where sopnumbe = '42759'
go
Backup Database [Tempbackupsop10200] To Disk = 'C:\MyBackupsop10200.bak'
go
Drop Database Tempbackupsop10200
 
 
-- On Tue, 7/7/09, Walden H. Leverich <WaldenL@xxxxxxxxxxxxxxx> wrote:


From: Walden H. Leverich <WaldenL@xxxxxxxxxxxxxxx>
Subject: RE: CPYF in SQL Server
To: "Midrange Systems Technical Discussion" <midrange-l@xxxxxxxxxxxx>
Date: Tuesday, July 7, 2009, 6:33 PM


> although it bombs at the end on that statement but it does the copy
non the less.

Things don't go boom for no good reason in SQLServer. What's the error
message?

-Walden