Thats a very good article Dinesh.

Keep it up

by the way

Hmm... but does that clear the on-disk compiled versions of the stored procedures as well?

Thank you very much Jonathan

Hi Jonathan

It does not work with views,does it?

Thank u very much Jonathan.

Thats what i am looking for

Thanks for that Osoba

actually i am looking for a common way to recompile all objects at once.

Hi Steve

The article is very useful.but it said

-----

As always, before you try any of this backup your database and never experiment on a production server. This example in the future...

Thanks Thomas for ur detailed explanation.

i'll be using this for our internal purpose only.

thats should be cool

Thats cool Thomas

Thanks

Thomas u r wonderful.

Thats exactly what i am after.

cheers

rajani

Thanks for the posts cmore

i got it 🙂

Thank you very much Dinesh.

I am wondering is it posible without first creating the temp table first and insert data.

like select * into #temp

thanks

rajani

Thanks for the reply Andy

i could not find auto refresh option.

Hi friend

i just found out whats happening here.

in the sql server agent properties window there is an option

(in connection tab)

sysadmin loginid entered as rk

thats why those connection using user account...

i have 4 jobs running.but all of them are owned by

user sa .there is no single job by user rk