wat do u think which query will give better performance.

does it mean that we can not schedule a stored procedure that needs parameters ?

If the answer is yes, then i think we can use a temp table with columns...

Some one can please help me, its very urgent.

Actually there are different Procedures with different number and type of parameters with different execution intervals.

For example consider following procedure.......I want to execute this procedure after every hour.

CREATE

Sorry, I havent use Service Broker before....can u plz explain abt the process

Yah i also thought that it will be depending on type of function....but i could not find how exactly it differentiates....coz more or less all the functions were same.

Yes i do get the error e.g

Suppose in the EM GUI, UDF 'MyFunction' has ONLY SELECT Option available for Grant

and if i try to execute  "GRANT EXECUTE ON MyFunction TO MYUser"

it...

Actually the problem is....when i go to properties of the users of my DB.....there is a tab of Permissions....that shows all the objects of the DB with the rights (SELECT,INSERT,UPDATE,DELETE,EXECUTE,DRI)...

Thanks all.....specially alzdba.....

one more thing i want to know is......

In my DBs Different USER DEFINED FUNCTIONS have different privileges....i.e

Some have SELECT

Some have EXECUTE

Some have SELECT, INSERT, UPDATE, DELETE

Some have...

Thanks all.....specially alzdba.....

one more thing i want to know is......

In my DBs Different USER DEFINED FUNCTIONS have different privileges....i.e

Some have SELECT

Some have EXECUTE

Some have SELECT, INSERT, UPDATE, DELETE

Some have...

This is for KH

exec master..xp_execresultset N'select ''GRANT ALL ON '' + name + '' TO test'' from sysobjects where type in (''U'', ''V'')', 'ADL'

HERE 'ADL' is my DB Name and...

Suppose my DB name is MYDB.....

Can u plz explain the FROM and WHERE clauses......i.e

from  [INFORMATION_SCHEMA].[TABLES]

 where [TABLE_SCHEMA] = 'xxx'

AND

from  [INFORMATION_SCHEMA].[ROUTINES]

 where [SPECIFIC_SCHEMA] = 'xxx'

KH i am getting the following error when i execute the above statement...isnt it strange

Incorrect syntax near 'Stored'

Thanks for replying.....but sorry to tell u that i knew this script....wat i want to know is .....is there any single command that can grant ALL to all the tables...

thanks every one who replied.....

My solution works fine after the change suggested by Kenneth. i.e EXEC('Kill ' + @spid)

Now about the system spids.....they will not be returned by the cursor...coz...