显示标签为“sp3”的博文。显示所有博文
显示标签为“sp3”的博文。显示所有博文

2012年3月11日星期日

BCP IN trouble

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年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]