September 5, 2008 01:02am pdt

1. chapmandew 2,069,190
2. angelIII 1,412,062
3. aneeshatti... 513,981
4. mark_wills 473,116
5. ee_rlee 313,995
6. brejk 226,005
7. dtodd 209,505
8. momi_sa... 183,929
9. acperkins 179,413
10. rickchild 170,740
11. ptjcb 160,219
12. BrandonG... 158,970
13. Thomasian 155,142
14. EugeneZ 148,550
15. sbagireddi 138,982
16. dportas 128,215
17. ScottPletc... 123,915
18. jgv 117,421
19. appari 114,604
20. PFrog 113,160
21. chrismc 112,389
22. PedroCGD 111,320
23. bashka_... 109,600
24. DanielWilson 108,774
25. tedbilly 107,990

1. angelIII 2,692,253
2. chapmandew 2,069,190
3. aneeshatti... 1,079,086
4. ptjcb 525,611
5. Yveau 517,373
6. mark_wills 473,116
7. dtodd 420,510
8. PFrog 383,188
9. dqmq 374,674
10. appari 350,751
11. imitchie 333,350
12. ee_rlee 313,995
13. acperkins 274,752
14. ScottPletc... 227,582
15. brejk 226,005
16. Lowfatsp... 223,289
17. matthews... 203,352
18. rboyd56 196,590
19. SQL_SE... 190,215
20. momi_sa... 185,629
21. EugeneZ 185,259
22. gbshahaq 177,810
23. tedbilly 176,329
24. DanielWilson 174,564
25. dportas 172,180

10.17.2007 at 10:53AM PDT, ID: 22899750

	[x] Attachment Details

Differences when using osql vs sqlcmd

Asked by jpelldev in SQL Server 2005

Tags: vs

I am running a stored procedure which produces a report via a batch process. In the past I have used the osql command. After implementing SQL Server 2005, I was asked to use sqlcmd instead.

OLD Statement
osql -E -S EMISTEST -d DCRVW000 -Q usp_act_MEM_Load_Balances_custval -o \\AVST404\EMIS_Batch\Finance\Actuals_CustVal\Act_Mem_Val\X18Y_FBP_Act_Mem_Val_10172007_132822_Report_1.txt

NEW Statement
sqlcmd -E -S EMISTEST -d DCRVW000 -Q usp_act_MEM_Load_Balances_custval -o \\AVST404\EMIS_Batch\Finance\Actuals_CustVal\Act_Mem_Val\X18Y_FBP_Act_Mem_Val_10172007_132822_Report_1.txt

The old method creates a report text file correctly but the new method does not. Also, the batch processing just seems to stop. It does not process any routines that are called after the statement to process the stored procedure.

I know that I can just use the old method for now but I am being asked to explain why the new method does not work and I cannot determine the reason.Start Free Trial

Keywords: Differences when using osql vs sqlcmd

	Title
1	How do I get OSQL to run properly usi…
2	Can I pump osql results into excel?
3	sqlcmd -L and osql -L do not return i…
4	TSQL and sqlcmd problem
5	How to run scripts with SQLCMD?
6	SQLCMD/T-SQL backup command is…

Loading Advertisement...

20080716-EE-VQP-32 / EE_QW_2_20070628

Differences when using osql vs sqlcmd

Asked by jpelldev in SQL Server 2005

Tags: vs

About this solution