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 |
|
benildusmuerling
Yak Posting Veteran
81 Posts |
 Posted - 2012-06-29 : 01:03:01
|
| When I hit the button, estimated execution plan button, it is returning with errors as below, I want to check the maintenance plan..Msg 208, Level 16, State 0, Line 1037Invalid object name '#temptable'. |
|
|
xhostx
Constraint Violating Yak Guru
277 Posts |
Posted - 2012-06-29 : 08:25:44
|
quote:
Originally posted by benildusmuerling
When I hit the button, estimated execution plan button, it is returning with errors as below, I want to check the maintenance plan..Msg 208, Level 16, State 0, Line 1037Invalid object name '#temptable'.
What are you running in your script?make sure FIRST whatever you are trying to execute the plan for is executable. then you can execute the plan for it.--------------------------Get rich or die trying-------------------------- |
 |
|
|
lionofdezert
Aged Yak Warrior
885 Posts |
|
|
benildusmuerling
Yak Posting Veteran
81 Posts |
Posted - 2012-07-05 : 03:50:10
|
| Dear Friend,Thanks mate understood, here what my problem in the query was, a #temp table is created using, select * into #temp..and this throws there is no object #tempit means, would always be a good practice to create the tables.Thanks,AB |
|
|
|
lionofdezert
Aged Yak Warrior
885 Posts |
Posted - 2012-07-10 : 02:38:00
|
| welcom--------------------------http://connectsql.com/ |
|
|
|
|
|
|
|
|
Estimated Execution plan