Microsoft KB Archive/233990

= PRB: Must Connect Using SA Account for VID to Have Options to Manipulate DB =

Article ID: 233990

Article Last Modified on 4/21/2001

-

APPLIES TO


 * Microsoft Visual InterDev 6.0 Standard Edition

-



This article was previously published under Q233990



SYMPTOMS
When you connect to a SQL server database with an account other than the database owner, you do not see any options in the data view to add or modify tables.



CAUSE
You have limited capabilities depending on your SQL permissions. You must be the database owner in order to create new tables or modify existing ones from the Data View within Visual InterDev.



RESOLUTION
Connect to the database using the database owner account in order to create and modify tables.



STATUS
This behavior is by design.

Keywords: kbide kbprb KB233990

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.