Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

what if I'm running a SP and get disconnected from web?

Status
Not open for further replies.
karen4201

karen4201

Programmer
Mar 9, 2006
37
US
Hi,

What if I use my local query analyzer to execute a stored procedure, but then lose my connection to the network? Would the SP continue running on the server, or would the SP stop running?

Thanks
 
Sort by date Sort by votes
The sp would stop running and roll back.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)
[noevil]
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

bharons
  • Locked
  • Question
Pick up value from combobox
Replies
0
Views
607
bharons
bharons
grnzbra
  • Locked
  • Question
Create Function Within IF statement. 1
Replies
4
Views
1K
mikrom
mikrom
peac3
  • Locked
  • Question
Gaps and islands
Replies
8
Views
635
Chris Miller
Chris Miller
grnzbra
  • Locked
  • Question
Is "IF EXISTS()..." better than "IF (SELECT COUNT...) > 0"
Replies
4
Views
3K
gmmastros
gmmastros
SashaBuilder3
  • Locked
  • Question
select a single row based on conditions in multiple rows 1
Replies
3
Views
901
SashaBuilder3
SashaBuilder3

Part and Inventory Search

Sponsor

Back
Top