There is no row at position 0.

Question

There is no row at position 0.

Viewing 11 posts - 16 through 25 (of 25 total)

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

Dugi SSCoach Points: 17998 More actions · Answer 1

cutedeveloper (3/26/2009)
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

Ok, I attache the U_tables.sql script and try to run it!

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

BLADE-1043594 SSCrazy Points: 2576 More actions · Answer 2

what man!!!!!!!! njn paranju tannatokke nee marannu poyo

[font="Comic Sans MS"]+++BLADE+++[/font]:cool:

maechismo_8514 SSCoach Points: 17510 More actions · Answer 3

J.K (3/27/2009)
njn paranju tannatokke nee marannu poyo

Oops not a good forum etiquette:-D. only English please 🙂

Dugi SSCoach Points: 17998 More actions · Answer 4

J.K (3/27/2009)
what man!!!!!!!! njn paranju tannatokke nee marannu poyo

Yea, plz translate it ...!!!!:w00t:

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

cutedeveloper Valued Member Points: 71 More actions · Answer 5

I run your "u_tables" script, it finished successfully...but I still getting the same error when I trying to delete old maintenance Plans...

Eugene

See-Quel SSC Veteran Points: 286 More actions · Answer 6

I had the same problem and was solved by executing the u_tables.sql

I think I accidently ran the delete/truncate script (using cursor) on the master DB and the problem started 😀

Thanks a lot Dugi. 🙂

Dugi SSCoach Points: 17998 More actions · Answer 7

vishalsheth9 (7/7/2009)
I had the same problem and was solved by executing the u_tables.sql
I think I accidently ran the delete/truncate script (using cursor) on the master DB and the problem started 😀
Thanks a lot Dugi. 🙂

You are welcome!

😉

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

bart.de.groof Valued Member Points: 55 More actions · Answer 8

Hello all,

I'm having the same issue on an SQL 2005 server (32bit) of one of our customers.

I would like to run this script, but I'm hesitating for the following reasons:

-This server contains valueable 'live' data (don't they all :-)) Do I need to detach the running databases before running the script ?

-Is there a risk of data corruption in the attached databases ?

-The server has replication enabled (=publication server). Will the script cause any disconnections with the subscribing servers ?

Can anyone help me out with these questions ?

Thanks in advance,

Bart

John.Sansom SSCertifiable Points: 7335 More actions · Answer 9

May I suggest testing any code that you find on the internet on a test server first.

John Sansom (@sqlBrit) | www.johnsansom.com

othni.morales Valued Member Points: 67 More actions · Answer 10

othni.morales

Valued Member

Points: 67

August 13, 2010 at 12:43 pm

#1206869

Thank you!

I had the same problem and this worked!!

abhi.guru SSC Enthusiast Points: 150 More actions · Answer 11

Thank you very much.

I had the same problem and this worked!!