467,144 Members | 1,168 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,144 developers. It's quick & easy.

Edit SQL table from Server Explorer

On VS2003/Server Explorer/Database Connections I can edit a table of a SQL
Server 2000 SP3 but, I intalled a new SQL Server 2000 SP3 on another machine
and can not edit tables. Which are the parameters I must configure on a SQL
Server to let edit tables and database diagrams from VS2003/Server Explorer?

Nov 21 '05 #1
  • viewed: 1159
Share:
2 Replies
Hi,

You need to be logged into sql server as an user that has rights to
edit a database.

Ken
---------------
"KIWI" <KI**@discussions.microsoft.com> wrote in message
news:72**********************************@microsof t.com...
On VS2003/Server Explorer/Database Connections I can edit a table of a SQL
Server 2000 SP3 but, I intalled a new SQL Server 2000 SP3 on another machine
and can not edit tables. Which are the parameters I must configure on a SQL
Server to let edit tables and database diagrams from VS2003/Server Explorer?
Nov 21 '05 #2
I'm logging as user sa (with the correct password and default permissions).
Has this user not enough permissions?

Thank you very much for your attention and quick answer.
"Ken Tucker [MVP]" wrote:
Hi,

You need to be logged into sql server as an user that has rights to
edit a database.

Ken
---------------
"KIWI" <KI**@discussions.microsoft.com> wrote in message
news:72**********************************@microsof t.com...
On VS2003/Server Explorer/Database Connections I can edit a table of a SQL
Server 2000 SP3 but, I intalled a new SQL Server 2000 SP3 on another machine
and can not edit tables. Which are the parameters I must configure on a SQL
Server to let edit tables and database diagrams from VS2003/Server Explorer?

Nov 21 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by William F. Robertson, Jr. | last post: by
5 posts views Thread by Max | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.