use Alter database command

set the mode to offline.

if app still pointing there ask the app team to stop application.

i heard something about 2011 beta coming up.

8:1:9022334

db id. index(clustered/nonclustered).objectid

TRY this and it will give you object name

select OBJECT_NAME(9022334 ) from sys.objects

try these 2 system tables also

sys.indexes ---- sys.index_columns

check sp_lock. it will tell u db id.object id and page that is locked.

compilation should not cause this. blocking mostly happens beacuse on cannot get resouce cpu...

If economy bad then a Cabbie in NYC. I luv it. If not then hummm diffcult.... Professor in college

Book Online. they have all details of it stepby step. try through that. if you get error while setting it up then post error here.

Check in Book Online

how big is the database. make sure you have enough disk space for it. almost need double the size of index sapce. also check in active proecesses if reindex is...

make sure you have proxy account to run this job. if not then the account under which agent is running should have admin access on sql. ssis are seperate services...

hussain.

Use BOL thats the best book that comes free with sql engine

yes you can . but you have to have IIS installed on that machine

samiam914 i am just kidding . i dont have money for lobbyist. hahahahha but you know it really hurts me when i see a very technical person loses his/her...

I never got good technical support. if it has to come back and we have to fix it here again then why not build it here initially. its lobbyist trust...

One of the biggest reason for US economic crisis is outsourcing. contract signed by clinton when he was visiting india alot are now showing results. I would like to see...