can u specify the syntax for "execute as owner"?

i m having a script which contains xp_cmdshell which will execute ssis package stored on live server

but user will execute that script through SSMS by connecting thr nonsysadmin account on...

the issue is with

SQL server Service

find the attachment

hi grant find the attached file

Hi All,

plz analyse those reports and revert on this.

if anything is required from my side plz tell.

Actually wait type OLEDB is taking more time,

that is because of use of linked server,

but how to resolve this?

No, i m running the trace from my local pc.

Hi Grant ,

i m having some reportsattached here regarding this issue. that will give u the clear idea about this issue.

reply on that.

Hi Grant ,

i m having some reports regarding this issue. can i send u ?that will give u the clear idea about this issue.

kindly provide ur email id if possible.

Thanx a lot MANU!!!!