You can try on this command again and again:

Maybe this is due to SQL injection that's why the command displayed as to my previous post.

Please see attachment. w00t:

You can try on this command again:

INSERT INTO ',1)')

You can try on this command:

INSERT INTO ',1)')

I've already sorted this out by the following operations:

1.) Download SP4 for SQL 2000.

2.) Install the SP4.

3.) Attached all the DBs needed for our applications.

Thanks anyway. 😀

I think that's not fair to give that kind of reply...I need the whole records from the table...so why will I set the rowcount = 5000.

That's it.

Thanks a lot.

I already update statistics and then Select count(*) FROM mytable. Then the result is still the same 11,386. But when I get the whole 11,386 records by using select * from...

Ok. Fine. But to make it detailed: It will display all the data and under the display area you will find the total number of records I think when the...

When I go to the Enterprise Manager and right click the table and select "open". It will display the total number of records in the table.

Thanks.

Hello,

Anyway, I already did it. Actually my problem was...

Hello Mohammed,

Can you give me the link to PSS?

Thanks a lot!

But I did not used any query "FOR XML". It seems that there is something wrong with SQL 2005. It sucks me a lot, because when I restore a db...

When I execute the dbcc checkdb command in sql query this is the result:

DBCC results for 'OSM_Etech_13_1'.

Service Broker Msg 9675, State 1: Message Types analyzed: 14.

Service Broker Msg 9676,...

Thanks, it works.

how about .net coding? I think this would be possible and since we are using the RSA Keon Web Passport. My problem is how will I code it in .net.

It's very helpful and meaningful.