thanks man

its not error constranit realy.

when i run this insert throw oracle localy (not throw dblink from mssql)

its worked .

but if i disable all constaint in oracle . that mssql...

Chris Harshman (10/17/2016)

---

I think the problem may be in the way you're trying to do the UPDATE. See EXAMPLE A in:

https://msdn.microsoft.com/en-us/library/ms188427.aspx

basically the OPENQUERY should have a SELECT in it...

RESOLVED

MY DC was low function

RESOLVED -

I do this

sqlcmd -S myServer -d myDB -E -o "MyData.txt" ^

-Q "select bar from foo" ^

-W -w 999 -s","

Eirikur Eiriksson (8/22/2016)

---

Is this a one-off or do you want to do this regularly, i.e. as a scheduled job? There are quite few options, bcp, sqlcmd, SSIS etc., please let...

Eirikur Eiriksson (8/22/2016)

---

Is this a one-off or do you want to do this regularly, i.e. as a scheduled job? There are quite few options, bcp, sqlcmd, SSIS etc., please let...

i have local instance .

i want to take...

no. standalone

\i will checks now

ok. i will check now

now its online..

i do this procedure:

http://www.sql-server-performance.com/2015/recovery-sql-server-suspect-mode/2/

but how can o check the last writing on this db?

to see if the data consistent

thanks

This is the error of agent in view history's

ERROR: %1 is not a valid Win32 application.

no

i have error in SQL AGENT .

i need scripts .