For e.g.

Use DBName

go

EXEC sp_changedbowner 'sa'

Gila, Will it work if I do...

Nope.. It was connected as guest user 🙂 .

Thanks all.....Once one of our weekly index rebuild which normaly takes 7 hours was not compeleted till Monday morning. However when I cancelled the job it took hardly an hour...

Gile,

Suppose an index rebuild job...

I dont think instances matters...

Gail already suggested... 🙂

Did you check it from network point of view ?. I think the server had gone out of network, may be.

I dont think deadlock will be the cause. Rights for that user have been revoked by any chance ?

Yes it's online and the login is able to use the database too...

..had checked that as well.. No it doesn't have sysadmin.

It has only Public.

Otherwise that error shudn't have appeard too rite ?

Thanks for the quick response.

... ++ how long it take normaly ?, check from the histoy.

What actualy the job is doing ? how much % is completed is available in sys.dm_exec_request ?

..As already specified...

I do not want to use sp_msforechdb because its a long script.

Also it may be necessary to execute that in a few speceific databaseas in future.

I tried using cursor by...

.. How it works when taken to offline and then online again, any idea ?

Edit --- Posted for wrong question..

..It's ideal. But it's definitely depended on what other applications you have in the box as well...