news:1154098817.011121.73270@h48g2000cwc.googlegroups.com...
> Hi,
>
> I have SQL Server running on my local PC and that has around 40 Gig
> assigned to it. I am running a stored procedure using isql from MS-DOS
> prompt. this stored procedure inserts millions of rows into a table
> (approx 400 Million). This process may take upto 3-4 days to run. The
> stored procedure reads each record from table1 (approx 110,000 records)
> and matches with all the records of another table - table2(with approx
> 620,000 records) and inserts data into a third table based on some
> criteria. So, depending on the criteria, there may be either 600,000
> rows inserted for each row in table1 or 0 rows. The stored procedure
> displays a print statement after processing 1000 rows each from table1.
> The procedure has processed up to 90,000 rows and there's no sign of
> any progress for the last 2-3 hours.
>
> I am trying to get into SQL Analyzer and Enterprise Manager and am not
> able to get into it. It doesnt give a timeout but the hour glass keeps
> turning. Since it's a local machine and no one else has access to it, I
> am not sure whether the process has encountered an error or the inserts
> are taking way too long and there's no way for me to tell. What should
> i do?
>
> I am sorry that i am putting a very vague question here but any help
> regarding this would be greatly appreciated.
>
> KP
>