HI Thanx for the reply..I still have one doubt..

when I execute this query how it will populate the data. will it consider all the existing queries on the server or...

Yes, I am..

However, the gray area here is not what to implement (we already know that) and even not that how to implement (even that is known) but what can...

Seems like forum jumped into an occasion...:hehe:

actually we are planning for few applications which will be sharing one ( or 2) dbs.

this db will being used approx 10mlns of users....

Heheh..No its not an enterview question.. 🙂

DB size is 50GB.

frequently running queries INSERT/DELETE?UPDATE/SELECT

We have a direct from "Data Operations"

DBA (DB-developer) are with application and administration are on DO side.

user 'test' already has exeute rights on xp_cmdshell.

amazing thing is that, under same rights if i reset the credentials through query working but not through Enterprise manager.

?!?

Hi, I have discovered a very strange problem in MS SQL Server 2005. When we reset the credentials of

"##xp_cmdshell_proxy_account##" through the command

EXEC sp_xp_cmdshell_proxy_account 'SHIPPING\KobeR','sdfh%dkc93vcMt0' it works always but...