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 |
|
under2811
Constraint Violating Yak Guru
366 Posts |
 Posted - 2006-02-15 : 10:08:39
|
| Hi Tara...I am just using your updated version of isp_DBCC_DBREINDEXDefault I created it in dbo schema. But my all tables own by ‘sco’ When I ran this particular SP I got error msg like...Could not find a table or object named 'employee.dbo.stg_EmpDetail'.Check sysobjects.Also one more thing suppose any how I manage to run this SP and got result but if any problem arises it fails with that particular problem but when I will run it second time it will show me this below error…is there any alternative to avoid this msg..Again and again???Server: Msg 2714, Level 16, State 6, Procedure isp_DBCC_DBREINDEX, Line 36There is already an object named '##Indexes' in the database.T.I.APapillon |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-02-15 : 13:03:30
|
| You just need to close your session to avoid the second error.I believe there are comments in my blog for that stored procedure that deal with the owner question. You should change your objects to dbo though.Tara Kizeraka tduggan |
 |
|
|
|
|
|
error getting in updated version of isp_DBCC_DBREI