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 |
|
SqlStar
Posting Yak Master
121 Posts |
 Posted - 2003-08-04 : 10:40:13
|
| Hi,Happy Friendship day.Sometimes sql-server behave like this. When we drop and create the procedure, the plan not changing.Its executing prior version of SP. When close and reconnect, it work fine. I found this problm in sql-server last 2yrs before. But still now this problem coming, Why? how to avoid this problem in future?Thanks...":-) IT Knowledge is power :-)" |
|
|
JustinBigelow
SQL Gigolo
1157 Posts |
Posted - 2003-08-04 : 11:51:38
|
| If you just want a new plan, have you tried the "sp_recompile" stored procedure?Justin"Look at it out there orbiting like it's so cool, we will rule it with an army of replicants!" |
 |
|
|
|
|
|
Reg-SQL Server engine working