Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
kgundava
Yak Posting Veteran
66 Posts |
 Posted - 2011-07-24 : 00:53:48
|
| I am running a set of queries(huge one's) against a oracle linked and for some reason i am getting the oracle connection lost error.This happens only when i try to execute the query from the sqlcmd or OSQL and not from regular sql.In order to avoid this error is there any other way to write to a file i.e. from the data management studio itself????As per a suggestion i would look into the BCP too.... but any other suggestion's would definitely help me...Does linked server any time out setting from osql or sqlcmd..?Thanks.... |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
|
|
|
LINKED SERVER and QUery output