How to modify remote database using Server Explorer

[Rob]

Hi,
In the server explorer in Visual Studio.Net I'm able to design tables, create stored procedures, etc for the SQL 2000 database running locally on my computer. If I add a connection to a remove server on the network, I'm not able to do the above. Is there something that must be set in order to allow this.

Thanks

[Jayson]

make sure you check the permissions on the remote server for your account...but yes, this functionality is there

jayson

[Mike Droney [MSFT]]

Hi

What version of Visual Studio .Net are you using? There are some
limitations connecting to remote databases in Server Explorer based on what
version of Visual Studio .Net you are using. This document details these:

http://msdn.microsoft.com/library/de...us/vdbt7/html/
dvconvisualdatabasetoolseditions.asp?frame=true

Hope this helps

Mike

--

VSData Team
Please post to our newsgroup: microsoft.public.dotnet.datatools
This posting is provided "AS IS" with no warranties, and confers no rights.
--------------------

Thread-Topic: How to modify remote database using Server Explorer
thread-index: AcPmeiFFRGcrDKZdSAeHV1muF27fTw==
X-Tomcat-NG: microsoft.public.dotnet.general
From: =?Utf-8?B?Um9i?= <an*******@discussions.microsoft.com>
Subject: How to modify remote database using Server Explorer
Date: Thu, 29 Jan 2004 07:11:11 -0800
Lines: 4
Message-ID: <11**********************************@microsoft.co m>
MIME-Version: 1.0
Content-Type: text/plain;
charset="Utf-8"
Content-Transfer-Encoding: 7bit
X-Newsreader: Microsoft CDO for Windows 2000
Content-Class: urn:content-classes:message
Importance: normal
Priority: normal
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
Newsgroups: microsoft.public.dotnet.general
Path: cpmsftngxa07.phx.gbl
Xref: cpmsftngxa07.phx.gbl microsoft.public.dotnet.general:123029
NNTP-Posting-Host: tk2msftcmty1.phx.gbl 10.40.1.180
X-Tomcat-NG: microsoft.public.dotnet.general

Hi, In the server explorer in Visual Studio.Net I'm able to design tables,
create stored procedures, etc for the SQL 2000 database running locally on
my computer. If I add a connection to a remove server on the network, I'm
not able to do the above. Is there something that must be set in order to
allow this.

Thanks