I am not using NOLOCKS.

Thanks SSCrazy, good idea. I will do that.

So that's the question. Ho wdo I do that?

I am logged into domain. So I should be part of network service*** accounts.

Is that not enough?

Sorry, i am a...

Right now, when I tried I got the following error:

sg 916, Level 14, State 1, Line 1

The server principal <user> is not able to access the database "db1_Archive" under the...

Sorry no when I changed the table name I deleted too much.

EXEC ('SELECT * INTO db1_Archive.dbo.tbl1_' + @thruPeriod +

' FROM tbl1')

I am doing USE db1 at the top. so that should not a problem.

I stopped the service. that put the DB out of recovery in a few minutes. Then I restored the DB. The restore happened successfully. Thanks much for your help. Greatly...

The database is in use.

i am hoping i can create a new db and restore into that. But this would not even let me create a new db.

I got a deadline and need to...

Thanks, but that's the problem. It does not let me take it offline, detach or drop. It is just stuck with SSMS saying <db Name>(In-Recovery).

Thanks GilaMonster, but I would rather restore from backup. I have a backup just before the disaster.

Thanks, what I want to do is for each employee and for each product i wan to find the first month where YTDRate > IntRate. If it is, update the...

Thank you so much. You are the best.

I have had these tables and asp.net code to load data, but the data until now was in 1.5 m rows at a time ot causing any problem.

So I copied...

hereit is.

create table [SalesRevenue].[dbo].tempS

( [CUSTMR_NBR] varchar(255)

,[ORCL_NBR] varchar(255)

,[CUST_NBR] varchar(255)

,[BLNG_CD] varchar(255)

...