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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-01-09 : 10:08:32
|
| Manish writes "My Question is I have written a stored procedure in Sql Server which takes around 16 min to get completed.My question is if i call a stored procedure from VB6 and after completion of the procedure I am disconnecting from the database.As soon as it encounter the database close method it gets hangs.Can you help me in this respect.ThanksWith Regards,Manish" |
|
|
Nazim
A custom title
1408 Posts |
Posted - 2002-01-09 : 10:14:37
|
| You need to check your Code , Create suitable indexes on your table's which should speed up the stored procedure execution.Use sql profiler and have a look where exactly the problem is coming.Post your code here. some valuable suggestions will pour in.----------------------------Anything that Doesn't Kills you Makes you Stronger |
 |
|
|
|
|
|
Stored Procedure