Click here to Skip to main content
15,901,122 members
Home / Discussions / Database
   

Database

 
GeneralNeed to execute a very time consuming Stored procedure on a remote machine. Pin
Rocky#15-Mar-08 1:10
Rocky#15-Mar-08 1:10 
Hi,

I need to execute a Stored proc on the online database. The problem is that there are about 0.8 million records and this will take lots of time like 6-8 hrs atleast. If I execute it by cnnecting from here it has a chance of geting cancel b4 completion. I'm using SQL 2005 Express. Is it possible to just execute the SP from here and then it carries on untill its complete. regardless of whther I'm connected or not.

Thanks in advance

Rocky

Success is a ladder which you can't climb with your hands in your pockets.

GeneralRe: Need to execute a very time consuming Stored procedure on a remote machine. Pin
Paul Conrad15-Mar-08 8:03
professionalPaul Conrad15-Mar-08 8:03 
GeneralRe: Need to execute a very time consuming Stored procedure on a remote machine. Pin
Rocky#16-Mar-08 21:28
Rocky#16-Mar-08 21:28 
GeneralRe: Need to execute a very time consuming Stored procedure on a remote machine. Pin
Krish - KP16-Mar-08 23:06
Krish - KP16-Mar-08 23:06 
GeneralRe: Need to execute a very time consuming Stored procedure on a remote machine. Pin
Rocky#17-Mar-08 0:03
Rocky#17-Mar-08 0:03 
GeneralRe: Need to execute a very time consuming Stored procedure on a remote machine. Pin
Mark J. Miller17-Mar-08 4:43
Mark J. Miller17-Mar-08 4:43 
GeneralRe: Need to execute a very time consuming Stored procedure on a remote machine. Pin
Rocky#17-Mar-08 6:03
Rocky#17-Mar-08 6:03 
GeneralRe: Need to execute a very time consuming Stored procedure on a remote machine. Pin
Mark J. Miller17-Mar-08 6:13
Mark J. Miller17-Mar-08 6:13 
GeneralRe: Need to execute a very time consuming Stored procedure on a remote machine. Pin
Rocky#17-Mar-08 6:18
Rocky#17-Mar-08 6:18 
GeneralRe: Need to execute a very time consuming Stored procedure on a remote machine. Pin
Mark J. Miller17-Mar-08 6:34
Mark J. Miller17-Mar-08 6:34 
GeneralRe: Need to execute a very time consuming Stored procedure on a remote machine. Pin
Rocky#17-Mar-08 6:46
Rocky#17-Mar-08 6:46 
GeneralRe: Need to execute a very time consuming Stored procedure on a remote machine. Pin
Mark J. Miller17-Mar-08 6:56
Mark J. Miller17-Mar-08 6:56 
GeneralRe: Need to execute a very time consuming Stored procedure on a remote machine. Pin
Rocky#17-Mar-08 7:11
Rocky#17-Mar-08 7:11 
Questionavoiding 1/1/1900 in SQL SERVER? Pin
John Sundar14-Mar-08 23:03
John Sundar14-Mar-08 23:03 
GeneralRe: avoiding 1/1/1900 in SQL SERVER? Pin
Rocky#15-Mar-08 1:06
Rocky#15-Mar-08 1:06 
GeneralRe: avoiding 1/1/1900 in SQL SERVER? Pin
Mark J. Miller17-Mar-08 4:54
Mark J. Miller17-Mar-08 4:54 
GeneralBest Practice: Connection Strings to MS-SQL datasource from web application Pin
Leo Smith14-Mar-08 9:18
Leo Smith14-Mar-08 9:18 
GeneralRe: Best Practice: Connection Strings to MS-SQL datasource from web application Pin
Mark J. Miller17-Mar-08 5:07
Mark J. Miller17-Mar-08 5:07 
GeneralStoring Compressed Image Into SQL Server Pin
abdurrahman oğuz14-Mar-08 6:30
abdurrahman oğuz14-Mar-08 6:30 
GeneralRe: Storing Compressed Image Into SQL Server Pin
Rob Philpott14-Mar-08 6:38
Rob Philpott14-Mar-08 6:38 
GeneralRe: Storing Compressed Image Into SQL Server [modified] Pin
abdurrahman oğuz14-Mar-08 22:40
abdurrahman oğuz14-Mar-08 22:40 
GeneralRe: Storing Compressed Image Into SQL Server Pin
Mark Churchill16-Mar-08 1:57
Mark Churchill16-Mar-08 1:57 
Generalinsert user checkboxlist selections in table Pin
C. L. Phillip14-Mar-08 4:26
C. L. Phillip14-Mar-08 4:26 
GeneralRe: insert user checkboxlist selections in table Pin
Mark J. Miller14-Mar-08 6:28
Mark J. Miller14-Mar-08 6:28 
GeneralRe: insert user checkboxlist selections in table Pin
C. L. Phillip14-Mar-08 9:36
C. L. Phillip14-Mar-08 9:36 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.