SQL Server Performance Forum – Threads Archive
Yukon Error: support objectsHi,<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.
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
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.