I try to transfert data table from one server to another one by using BCP.
The 2 servers are running SQLS2k sp3.
The outpout work fine, but the input (option: -m2 -N) in destination DB return a message:
Starting copy...
SQLState = 37000, NativeError = 156
Error = [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near the keyword 'Order'.
SQLState = 37000, NativeError = 156
Error = [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near the keyword 'Order'.
i guess that i have the keyword "order" in my .bcp file so that disturb the input command.
How can i manage this ?
PS: i tried already the -w option for out-in command
Many thanks.Can you put in your bcp statement here? -T&R, Suresh.|||here after my BCP statement:
bcp.exe "Production.dbo.[Backup_Ordersdetail]" In "C:\...\bcpfiles\Backup_Ordersdetail.bcp" -m2 -N -Sxxxxxxx -Uxx -Pxxxxxxx
2012年3月11日星期日
2012年2月9日星期四
Basic Server Roles (security) question
I want to add a consulting firm of ours to have full access to a
database on my SQL 2000 SP3 server (so DBOWNER is ok with me).
But I also need them to be able to schedule a job against that database
AND create various DB maintenance plans. I've scoured the BOL but
nothing I can find talks about this kind of granularity in security.
Is there a role that will allow this?
Many thanks.cy
Are you member of sysadmin server role as well?
"cy" <cyrus.kapadia@.us.pm.com> wrote in message
news:1105036907.387257.286720@.f14g2000cwb.googlegroups.com...
> I want to add a consulting firm of ours to have full access to a
> database on my SQL 2000 SP3 server (so DBOWNER is ok with me).
>
> But I also need them to be able to schedule a job against that database
> AND create various DB maintenance plans. I've scoured the BOL but
> nothing I can find talks about this kind of granularity in security.
> Is there a role that will allow this?
>
> Many thanks.
>|||Yes, I am top dog on the server - I have all keys to all kingdoms. But
they aren't, of course.
Cy.
Uri Dimant wrote:[vbcol=seagreen]
> cy
> Are you member of sysadmin server role as well?
>
> "cy" <cyrus.kapadia@.us.pm.com> wrote in message
> news:1105036907.387257.286720@.f14g2000cwb.googlegroups.com...
database[vbcol=seagreen]
security.[vbcol=seagreen]
database on my SQL 2000 SP3 server (so DBOWNER is ok with me).
But I also need them to be able to schedule a job against that database
AND create various DB maintenance plans. I've scoured the BOL but
nothing I can find talks about this kind of granularity in security.
Is there a role that will allow this?
Many thanks.cy
Are you member of sysadmin server role as well?
"cy" <cyrus.kapadia@.us.pm.com> wrote in message
news:1105036907.387257.286720@.f14g2000cwb.googlegroups.com...
> I want to add a consulting firm of ours to have full access to a
> database on my SQL 2000 SP3 server (so DBOWNER is ok with me).
>
> But I also need them to be able to schedule a job against that database
> AND create various DB maintenance plans. I've scoured the BOL but
> nothing I can find talks about this kind of granularity in security.
> Is there a role that will allow this?
>
> Many thanks.
>|||Yes, I am top dog on the server - I have all keys to all kingdoms. But
they aren't, of course.
Cy.
Uri Dimant wrote:[vbcol=seagreen]
> cy
> Are you member of sysadmin server role as well?
>
> "cy" <cyrus.kapadia@.us.pm.com> wrote in message
> news:1105036907.387257.286720@.f14g2000cwb.googlegroups.com...
database[vbcol=seagreen]
security.[vbcol=seagreen]
订阅:
博文 (Atom)