There is no row at position 0.

  • Hi Experts,

    I am getting the error given below when i selected the properties of a database. I am getting the same error when i try all databases in that server.

    "There is no row at position 0. (System.Data)"

    Please help

    TIA

  • Hi there,

    Just to qualify your issue a little further, are you looking at the properties of a database by right-clicking a given DB in SQL Server Management Studio?

    Also, it may prove useful if you can provide the version details of your SQL Server.

    Cheers,

  • Ratheesh.K.Nair (3/13/2009)


    Hi Experts,

    I am getting the error given below when i selected the properties of a database. I am getting the same error when i try all databases in that server.

    "There is no row at position 0. (System.Data)"

    Please help

    TIA

    Your problem seems to be with system tables:

    One of the solutions is:

    Run u_tables.sql from your instance's install directory. e.g: C:\Program Files\Microsoft SQL Server\MSSQL$SQL2005\MSSQL.1\MSSQL\Install\u_tables.sql

    Hope it will help you!!!

    Dugi

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

  • Thanks to all for the prompt reply,

    Yes i got the error when i tried to get the database properties by right clicking on database -->properties.

    I am using SQL Server 2005 Developer Edition with no service pack installed.

    I am also getting other errors when i tried to select different properties in a scheduled task job.

  • Although a bit of a punt, I would suggest intalling the latest SQL Server 2005 Service Pack. I have had issues with the SQL Server Management Stuid (SSMS) GUI on occasion and updating to the latest SP has resolved the issue.

  • Ratheesh.K.Nair (3/13/2009)


    Thanks to all for the prompt reply,

    Yes i got the error when i tried to get the database properties by right clicking on database -->properties.

    I am using SQL Server 2005 Developer Edition with no service pack installed.

    I am also getting other errors when i tried to select different properties in a scheduled task job.

    Did you try to run u_tables.sql ...Let me know what results you have running this script!

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

  • Ran u_table.sql and go this message.

    Starting u_Tables.SQL at 13 Mar 2009 18:13:12:637

    This file creates all the 'SPT_' tables.

    drop table spt_monitor ....

    drop table spt_values ....

    Creating 'spt_monitor'.

    Creating 'spt_values'.

    create indexes on spt_values ....

    Grant Select on spt_ ....

    Insert into spt_monitor ....

    Insert into spt_values ....

    Insert spt_values.type='A ' ....

    Insert spt_values.type='B ' ....

    Insert spt_values.type='D ' ....

    Insert spt_values.type='DC ' ....

    Insert spt_values.type='E ' ....

    Insert spt_values.type='F ' ....

    Insert spt_values.type='G ' ....

    Insert spt_values.type='I ' ....

    Insert spt_values.type='J ' ....

    Insert spt_values.type='K ' ....

    Insert spt_values.type='L ' ....

    Insert spt_values.type='LR ' ....

    Insert spt_values.type='LS ' ....

    Insert spt_values.type='LO ' ....

    Insert spt_values.type='O ' ....

    Insert spt_values.type='O9T' ....

    Insert spt_values.type='P ' ....

    type='P ' ,@number_track=7

    type='P ' ,@number_track=15

    type='P ' ,@number_track=31

    type='P ' ,@number_track=63

    type='P ' ,@number_track=127

    type='P ' ,@number_track=255

    type='P ' ,@number_track=511

    type='P ' ,@number_track=1023

    Insert spt_values.type='R ' ....

    Insert spt_values.type='SFL' ....

    Insert spt_values.type='SOP' ....

    Insert spt_values.type='T ' ....

    Insert spt_values.type='V ' ....

    Insert spt_values.type='SRV' ...

    Insert spt_values.type='DBR' ...

    Finishing at 13 Mar 2009 18:13:14:230

  • And the winner is ...??? You or again DB properties !?

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

  • I ran it again and got

    Starting u_Tables.SQL at 16 Mar 2009 12:37:54:357

    This file creates all the 'SPT_' tables.

    drop table spt_monitor ....

    drop table spt_values ....

    Creating 'spt_monitor'.

    Creating 'spt_values'.

    create indexes on spt_values ....

    Grant Select on spt_ ....

    Insert into spt_monitor ....

    Insert into spt_values ....

    Insert spt_values.type='A ' ....

    Insert spt_values.type='B ' ....

    Insert spt_values.type='D ' ....

    Insert spt_values.type='DC ' ....

    Insert spt_values.type='E ' ....

    Insert spt_values.type='F ' ....

    Insert spt_values.type='G ' ....

    Insert spt_values.type='I ' ....

    Insert spt_values.type='J ' ....

    Insert spt_values.type='K ' ....

    Insert spt_values.type='L ' ....

    Insert spt_values.type='LR ' ....

    Insert spt_values.type='LS ' ....

    Insert spt_values.type='LO ' ....

    Insert spt_values.type='O ' ....

    Insert spt_values.type='O9T' ....

    Insert spt_values.type='P ' ....

    type='P ' ,@number_track=7

    type='P ' ,@number_track=15

    type='P ' ,@number_track=31

    type='P ' ,@number_track=63

    type='P ' ,@number_track=127

    type='P ' ,@number_track=255

    type='P ' ,@number_track=511

    type='P ' ,@number_track=1023

    Insert spt_values.type='R ' ....

    Insert spt_values.type='SFL' ....

    Insert spt_values.type='SOP' ....

    Insert spt_values.type='T ' ....

    Insert spt_values.type='V ' ....

    Insert spt_values.type='SRV' ...

    Insert spt_values.type='DBR' ...

    Finishing at 16 Mar 2009 12:38:00:107

    I didnt find any difference between the two results.

    The winner is still DB properties ,I am getting the same old error :crying:

  • Thanks Dugi thanks a lot.

    :w00t: the problem is solved

  • Ratheesh.K.Nair (3/16/2009)


    Thanks Dugi thanks a lot.

    :w00t: the problem is solved

    You are welcome!

    :hehe:

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

  • Did I miss something?

    How did you solve your problem?

    Cheers,

  • I did nothing

    Just ran u_table.sql 😀

  • Good to know! 😀

  • Hi Dugi!

    It seems I do not have that forder and u_tables.sql script. What I have are:

    C:\Program Files\Microsoft SQL Server\90...

    D:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL...

    :angry:

    Actualy I got the same (There is no row at position 0 (System.Data)) error,

    when tried to delete old Maintanance Plans from Managemet Studio ...

    Do you think u_tables.sql script shold help here or how can I delete those old records?

    I am running SQL 2005 SP3...

    Thanks

Viewing 15 posts - 1 through 15 (of 25 total)

You must be logged in to reply to this topic. Login to reply