SQL Server Performance

Yukon Error: support objects

Discussion in 'SQL Server 2005 General Developer Questions' started by ashish.johri2007, Mar 2, 2007.

  1. ashish.johri2007 New Member

    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
  2. MohammedU New Member

    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...

  3. satya Moderator

    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.

Share This Page