you can free the space where the tempdb placed.

Thanks for your response.

Yes, i accepted this. And i found the same when i sp_recompile the table which associated with the sp.

How do i force a sp to recopile without...

you can use dbcc cleantable(tablename). This will clean the table if any of text or varying field length column deleted from table.

Using string manipulation i already tried, and it works fine, my doubt is whether sql server internally has any function to find it out like set parseonly.

Yes i have bunch of queries in a table.

From that sqlquery field, i want to find out the tables involved in that query.

HI,

Thanks for your prompt response.

But schemabinding option will not work for this scenario, i think so.

Thanks for your prompt response.

Can you please give me some explanation about why this is not possible or suggest some url to make me to clear

thanks

YOu can use

Select Convert(money,'12,353.12').

This will work out