×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
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
midrange.com
