Brothers,

The problem is i am not able to open the table in design view on my system and other system also but i can open it on my server remotely....

I tied from different machine now, i am getting the same problem now and i got this error message also

SQL Server connection broken. Want to retry.

No active open transactions

I dont have any open transaction.

No active open transactions

I am having the sysadmin privileges, ok can be a network problem. Just now i saw my logs an i got this message

The SQL Server has been optimized for 8...

its located on the remote computer and i am accessing this using linked server

Yes ,

When i am running any query on query analyzer i am getting the same error. We have a junior in network department. I dont thing he will solve this...

Any one who can help me Please

Hi,

Thanks for your support, initially it was 4 sec i have increased it to 20 and now i have registered it successfully.

I learned one new thing today.

Thankyou.

Syed Sanaullah Khadri

Hi,

I have seen using ping, its working fine. I dont know about odbc can you tell me how to configure it.

I am able to connect it using query analyser and...

I dont know about indid=1 but

When you execute SP_HELP tablename, below you will get the index created on the table and its type and on which column it is created.

Hi,

AS the values are changing every second the in procedure we should use

WITH RECOMPILE, So wheen ever it is called it recompiles the query and get the last 50 records...

Hi Amit,

SP_HELP

In this you will get all information.

Thanks,

Syed Sanaullah Khadri

Its not locally,

My server is some where else. I have connected it by using user name and password as sysadmin(Priv).

Thanks,

I got it with ur help.