SQL Server Performance Forum – Threads Archive
Yukon Error: support objects
Hi,<br /><br />I am getting this error when I right click on any table to see its properties or to modify schema of this table.<br /><br />"This Database doesn’t have one or more of the support objects required to use database programming. Do you wish to create them?"<br /><br />I am afraid that sth went wrong.<br />Y’day I just imported a lot of data in this DB and I went to sleep. This time this is just not responding and taking a hell lot of time even for the query below:<br /><br />Q) select top 1* from deed with (nolock)<br />Time: 24 sec[<img src=’/community/emoticons/emotion-6.gif’ alt=’
‘ />]<br /><br />Regards,<br />Ashish<br /><br />Ashish Johri
I don’t think data load can cause any issues like this.
Try using query window and use sp_help tablename…. Run the update stats… MohammedU.
Moderator
SQL-Server-Performance.com
You say Yukon error, are you using Beta or CTP version of SQL 2005?
What is the service pack level on SQL Server. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.
]]>