Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
mapidea
Posting Yak Master
124 Posts |
 Posted - 2009-11-19 : 16:48:59
|
| How to find out which stored procedure is recompiling? How to stop stored procedures from recompiling?Thanks |
|
|
mapidea
Posting Yak Master
124 Posts |
Posted - 2009-11-19 : 17:56:14
|
| It is done WITH RECOMPILE option.Thanks |
 |
|
|
Pradip
Starting Member
32 Posts |
Posted - 2009-11-20 : 00:19:14
|
| You trace using SQL Server Profile. Sai, WITH RECOMPILE you can only force SP to recompile, ie This tells SQL Server to throw away the existing query plan or do not cache the previous execution query plan and build another one.www.silicus.compradipjain |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2009-11-20 : 00:30:35
|
| http://social.msdn.microsoft.com/Forums/en/sqldatabaseengine/thread/76f185bf-af34-49f1-812f-b78531c20ca4 |
|
|
|
|
|
|
Stored Procedure Recompile