"Open Table Window" is read-only under SQL Query Analyzer

I have installed SQL Server 2000 with option "Client Tools Only"
I try to edit data using SQL Query Analyzer with Trusted Connection. I click on 'Open' of right-click on table objects. A "Open Table Window" is opened as read-only!!! "Add" and "Delete" are grey out!! I can't edit data.
I am trying to edit data using Server Explorer under Microsoft .NET with Trusted Connection. It works!!!
Help, Help!
Maybe the table does not have a Primary Key, check this first.
Dejan Sarka, SQL Server MVP
Associate Mentor
Solid Quality Learning
More than just Training
www.SolidQualityLearning.com
"Happy Programmer" <anonymous@.discussions.microsoft.com> wrote in message
news:9D59D138-BFAE-4CAB-A2C1-FF535B42F2C7@.microsoft.com...
> I have installed SQL Server 2000 with option "Client Tools Only"
> I try to edit data using SQL Query Analyzer with Trusted Connection. I
click on 'Open' of right-click on table objects. A "Open Table Window" is
opened as read-only!!! "Add" and "Delete" are grey out!! I can't edit
data.
> I am trying to edit data using Server Explorer under Microsoft .NET with
Trusted Connection. It works!!!
> Help, Help!
|||I believe that you will only be able to modify data from the Open Table
function in Query Analyzer if the table has a primary key or unique
constraint or a unique index.
Steve Kass
Drew University
Happy Programmer wrote:

>I have installed SQL Server 2000 with option "Client Tools Only"
>I try to edit data using SQL Query Analyzer with Trusted Connection. I click on 'Open' of right-click on table objects. A "Open Table Window" is opened as read-only!!! "Add" and "Delete" are grey out!! I can't edit data.
>I am trying to edit data using Server Explorer under Microsoft .NET with Trusted Connection. It works!!!
>Help, Help!
>
|||I've tried it. It is able to modify if the table has primary key or unique index.
But is able to edit data using Server Explorer under Microsoft .NET with Trusted Connection even it has not any key or index.
Anyway, thanks a lot~!

"C:\INETPUB\WWWROOT\SLEPCHA\APP_DATA\ASPNETDB.MDF" because the database is read-only.

i have created a appl and deployed it in IIS .

When i login from the login page i get a error :Server Error in '/slepcha' Application.
------------------------

Failed to update database "C:\INETPUB\WWWROOT\SLEPCHA\APP_DATA\ASPNETDB.MDF" because the database is read-only.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Failed to update database "C:\INETPUB\WWWROOT\SLEPCHA\APP_DATA\ASPNETDB.MDF" because the database is read-only.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

Have you checked to see whether that file has the ReadOnly attribute set?