<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
SQL Server 2005
»
Administering
»
There is no row at position 0.
26 posts, Page 1 of 3
1
2
3
»
»»
There is no row at position 0.
Rate Topic
Display Mode
Topic Options
Author
Message
Ratheesh.K.Nair
Ratheesh.K.Nair
Posted Friday, March 13, 2009 2:27 AM
SSCrazy
Group: General Forum Members
Last Login: 2 days ago @ 6:42 AM
Points: 2,415,
Visits: 3,379
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
Post #674967
John.Sansom
John.Sansom
Posted Friday, March 13, 2009 2:34 AM
Old Hand
Group: General Forum Members
Last Login: 2 days ago @ 5:16 AM
Points: 343,
Visits: 1,457
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,
John Sansom (
@sqlBrit
) |
www.sqlbrit.com
The SQLBrit Community Forum
- "There's so more to being a Data Professional than just technology."
Post #674972
Dugi
Dugi
Posted Friday, March 13, 2009 2:39 AM
Ten Centuries
Group: General Forum Members
Last Login: Tuesday, April 02, 2013 1:48 AM
Points: 1,252,
Visits: 3,367
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/
Post #674973
Ratheesh.K.Nair
Ratheesh.K.Nair
Posted Friday, March 13, 2009 5:00 AM
SSCrazy
Group: General Forum Members
Last Login: 2 days ago @ 6:42 AM
Points: 2,415,
Visits: 3,379
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.
Post #675039
John.Sansom
John.Sansom
Posted Friday, March 13, 2009 5:02 AM
Old Hand
Group: General Forum Members
Last Login: 2 days ago @ 5:16 AM
Points: 343,
Visits: 1,457
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.
John Sansom (
@sqlBrit
) |
www.sqlbrit.com
The SQLBrit Community Forum
- "There's so more to being a Data Professional than just technology."
Post #675041
Dugi
Dugi
Posted Friday, March 13, 2009 5:57 AM
Ten Centuries
Group: General Forum Members
Last Login: Tuesday, April 02, 2013 1:48 AM
Points: 1,252,
Visits: 3,367
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/
Post #675071
Ratheesh.K.Nair
Ratheesh.K.Nair
Posted Friday, March 13, 2009 6:50 AM
SSCrazy
Group: General Forum Members
Last Login: 2 days ago @ 6:42 AM
Points: 2,415,
Visits: 3,379
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
Post #675107
Dugi
Dugi
Posted Friday, March 13, 2009 6:56 AM
Ten Centuries
Group: General Forum Members
Last Login: Tuesday, April 02, 2013 1:48 AM
Points: 1,252,
Visits: 3,367
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/
Post #675114
Ratheesh.K.Nair
Ratheesh.K.Nair
Posted Monday, March 16, 2009 1:09 AM
SSCrazy
Group: General Forum Members
Last Login: 2 days ago @ 6:42 AM
Points: 2,415,
Visits: 3,379
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
Post #676290
Ratheesh.K.Nair
Ratheesh.K.Nair
Posted Monday, March 16, 2009 1:13 AM
SSCrazy
Group: General Forum Members
Last Login: 2 days ago @ 6:42 AM
Points: 2,415,
Visits: 3,379
Thanks Dugi thanks a lot.
the problem is solved
Post #676293
« Prev Topic
|
Next Topic »
26 posts, Page 1 of 3
1
2
3
»
»»
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
