Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Does slow computer affects running SP
Message
From
07/01/2003 08:36:01
 
 
General information
Forum:
Microsoft SQL Server
Category:
Stored procedures, Triggers, UDFs
Miscellaneous
Thread ID:
00738626
Message ID:
00738724
Views:
19
> Does a busy network, or Very busy SQL server or slow computer affect the running of stored procedures on the server?

I would expect those items to affect the performance but not the result.

-Mike

>I have written a Foxpro program that calls stored procedures in SQL SERVER. There are tens of stored procedures in the SQL server. I send data from foxpro tables to sql server and then run the procedures on the data in sql server by using command.execute. The data is stored in SQL server. The problem is when I run the program from some other computer, once in a while it does wrong processing of data. Like today it processed the data wrongly from another computer which is a slow computer(433MHZ and 56 MB RAM). When I ran the same program from my computr and with same data it ran fine. It runs fine from Slow computer also but once a while it processes wrong.
>
> Does a busy network, or Very busy SQL server or slow computer affect the running of stored procedures on the server?
>
>Any views
>Thanks
>Bharat
Michael Levy
MCSD, MCDBA
ma_levy@hotmail.com
Previous
Reply
Map
View

Click here to load this message in the networking platform