Re: Create Job to dump SP results into a text file.
From: Baisong Wei[MSFT] (v-baiwei_at_online.microsoft.com)
Date: 03/23/04
- Next message: Puneet Mittal: "Re: Insert statement inside stored procedure failing"
- Previous message: David Portas: "Re: Duplicate keys, unique rows."
- In reply to: moondaddy: "Re: Create Job to dump SP results into a text file."
- Next in thread: moondaddy: "Re: Create Job to dump SP results into a text file."
- Reply: moondaddy: "Re: Create Job to dump SP results into a text file."
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 23 Mar 2004 12:03:06 GMT
Hi moodaddy,
As the first content you get, it is because the missing of some switches in
the OSQL utility, and the -L is an exclusive switch in osql utility, so you
get the content of 'The -L parameter can not used in combineation with
others parameters.' The second one is due to the blank between the '-' and
'b'. OSQL could not parse the parameters too. Now it is all right with the
syntax of osql but it has some more problem and seems a little complicated,
I will help you to trouble shoot this problem.
1. Could you connect the SQL Server via Query Analyzer by SQL Server
authentication using 'sa'?
2. Could you please check the TCP/IP and the Named Pipe protocol is enabled?
To enable TCP/IP server network library by the Server Network Utility,
please take the following steps.
1) Click "Start", and then click "Run".
2) In the "Run" dialog box, type "svrnetcn.exe" (without the quotation
marks) in the "Open" box, and then click OK. Note: By default, the
svrnetcn.exe is available in the following folder: <Installation
Drive>/Program Files/Microsoft SQL Server/80/Tools/BINN
3) Click "OK".
4) In the "SQL Server Network Utility" dialog box, click "General" tab.
5) Select your instance of SQL Server 2000 from the "Instance(s) on this
server" list.
6) In the "Disabled Protocols" list box, select "TCP/IP" and "Named Pipes",
and then click "Enable".
7) Restart your SQL Server Service and try again.
As for you another question to save the result into a tab limited, till
now, I could not find a good way to do it with osql. I am not sure I found
the easiest way. What I figure out is to save the result set of the stored
procedure (if the result set could be in saved in one table) and use DTS
(which could be scheduled as a job) to save it to excel file or use BCP
utility to save it as log file or other file format ( which could also be
scheduled as a job like the way we talked above with osql). If you accept
this method, we will continue to work on it.
Looking forward to your reply.
Thanks.
Best regards
Baisong Wei
Microsoft Online Support
----------------------------------------------------
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only. Thanks.
- Next message: Puneet Mittal: "Re: Insert statement inside stored procedure failing"
- Previous message: David Portas: "Re: Duplicate keys, unique rows."
- In reply to: moondaddy: "Re: Create Job to dump SP results into a text file."
- Next in thread: moondaddy: "Re: Create Job to dump SP results into a text file."
- Reply: moondaddy: "Re: Create Job to dump SP results into a text file."
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
|
