I appreciate your assistant.

I'm now got what i want.

a lot of thanx.

Lux

>>>In SQL Server 2000 you can also grant the CREATE <object> rights >>>manually. This will create the objects belonging to the user. The user will >>have complete rights over his...

It's work again.

I think what you've mentioned are right.

It's prolly rolling back.

And when It was finished I can access to database normally.

Thanks...

thanks in advance my freind.

Hope this would help me.

Cheers,

Lux

Many thanks Xavier.

Yet i stiil wonder Y I've been using this procedure for long.

Why this issue just happend?

Or Do we have another background process?

Thanks,