HI All

thanks for clearing the doubt.

Gail

The DBA said Vendor of the application will now deal vid tis.

Thanks really for ur cooperation and help.

Hi All

Tis is the result:

"sp_dbcmptlevel 'myDBName'

go

select @@version"

The current compatibility level is 80.

...

Hi Gail

for my DBA every thg is working fine

he is the sysadmin

but the issue is ven a person who is not in sysadmin role is not able to execute the...

Hi Steve

Like in a batch file(suppose test.bat) v define variables as %1,%2 etc and v pass values to them at command line like:

c:>test 'a' 'b'

So is there no way v...

Gail

Dba created a test user and ten gave it the following permissions:

With execute as 'sa'

Grant impersonate on user::'test' on 'sa'

Even this thg also didnt work out as he said.

N ...

And 1 more thg:

Create proc A

with execute as 'dbo' or

with execute as owner ,wht shd be used instead of this dbo and owner?

Thanks

Hi

This is wht i m got:

Msg 229, Level 14, State 5, Procedure xp_cmdshell, Line 1

The EXECUTE permission was denied on the object 'xp_cmdshell', database 'mssqlsystemresource', schema 'sys'.

Hi Gail

he did the following:

Create procedure Test

with execute as 'dbo'

Then also it is not working.

one thg is not clear:

i am logging in sql 2005 management studio.

ten connecting to the db...

Hi Gail

i asked my dba 2 create a sp with same information as the one which i m tryin 2 run.

So he created it by including the execute as clause.

But...

Hi Gail

i tried executing the procedure by using the execute as clause.

its still not working.

Create procedure Test

with execute as owner

Can u help me out vid tis?

Thanks in advance.

Hi Gail

i had a chat vid my DBA so ven he gave me admin rights as he said then i was able to execute it.

But as he cant gives priveleged...

Hi Gail/Atif

I have added the service id under which the sql services are running in SQL server 2005 development server to the server A.

still no result.

Hi Gail..

What exactly u mean by rights??

on Server A im havin local admin access.

Can u plz illustrate on this Rights thing.

Thanks