osql question!

I have a question regarding SQL Server 7.0. I know I am living in primitive
age but we are looking forward to convert to 2005 soon!
My problem is kind of weird (at least to me). I have these sets of nested
stored procedures which I use to do some heavy computation on the database
server. I extract data from the SP as the result. I have made a batch job
using which I can run the stored procedures via osql utility.
My problem is that when I run the stored procedure using osql (batch file)
it takes forever to run, but when I run the same from Query Analyzer it gets
done fairly fast (15 mins approx). I am dealing with quite a bit of data
here (like 50,000 rows and 20 different tables). But, it seems like the
problem is not within my stored procedures.
Do I need to worry about anything else while running query/sp from osql as
opposed to running them from Sql Query Analyzer?
I will appreciate any response.
NibenCheck out http://support.microsoft.com/defaul...b;en-us;816834.
You might also try including SET NOCOUNT ON if you haven't already done so.
Hope this helps.
Dan Guzman
SQL Server MVP
"Niben" <Niben@.discussions.microsoft.com> wrote in message
news:E0729BBF-876B-43EE-BB60-D46729F1BD7A@.microsoft.com...
>I have a question regarding SQL Server 7.0. I know I am living in primitive
> age but we are looking forward to convert to 2005 soon!
> My problem is kind of weird (at least to me). I have these sets of nested
> stored procedures which I use to do some heavy computation on the database
> server. I extract data from the SP as the result. I have made a batch job
> using which I can run the stored procedures via osql utility.
> My problem is that when I run the stored procedure using osql (batch file)
> it takes forever to run, but when I run the same from Query Analyzer it
> gets
> done fairly fast (15 mins approx). I am dealing with quite a bit of data
> here (like 50,000 rows and 20 different tables). But, it seems like the
> problem is not within my stored procedures.
> Do I need to worry about anything else while running query/sp from osql as
> opposed to running them from Sql Query Analyzer?
> I will appreciate any response.
> Niben|||Thanks Dan!
So seems like there's no solution for sql 7.0 huh! Any patches as they have
for SQL 2000.
"Dan Guzman" wrote:

> Check out http://support.microsoft.com/defaul...b;en-us;816834.
> You might also try including SET NOCOUNT ON if you haven't already done so
.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "Niben" <Niben@.discussions.microsoft.com> wrote in message
> news:E0729BBF-876B-43EE-BB60-D46729F1BD7A@.microsoft.com...
>
>