March 13, 2009 at 2:27 am
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
March 13, 2009 at 2:34 am
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,
March 13, 2009 at 2:39 am
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
March 13, 2009 at 5:00 am
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.
March 13, 2009 at 5:02 am
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.
March 13, 2009 at 5:57 am
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!
March 13, 2009 at 6:50 am
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
March 13, 2009 at 6:56 am
March 16, 2009 at 1:09 am
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:
March 16, 2009 at 1:13 am
Thanks Dugi thanks a lot.
:w00t: the problem is solved
March 16, 2009 at 3:18 am
March 16, 2009 at 8:05 am
Did I miss something?
How did you solve your problem?
Cheers,
March 16, 2009 at 8:51 am
I did nothing
Just ran u_table.sql 😀
March 16, 2009 at 9:35 am
Good to know! 😀
March 26, 2009 at 2:44 pm
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