Hi,
My first post. I am trying to design a SQL Server 2000 table directly within Visual Studio .NET 2003.
This what I did to create a connection from Sever Explorer in Visual Studio 2003:
Opened Server Explorer.
Right-clicked the Data Connections node and then selected Add Connection.
Filled in the connection information for my data source using OLE DB Provider for SQL Server.
Clicked OK to create the Data Connection named "CU2.PIT.pit_user".
My Problem:
I can see and retrive data from my Tables BUT I can not
1. Design Table when I right click on Tables
2. Can not add View when I right click on Views.
I gave user "pit_user" "create table and create view for table in SQL Server Enterprise Manager.
Thanks in advance.
SQL Server 2000 is running on Window 2003 Server
Visual Studio 2003 is running on Windows XP Pro - SP2
sw007
My first post. I am trying to design a SQL Server 2000 table directly within Visual Studio .NET 2003.
This what I did to create a connection from Sever Explorer in Visual Studio 2003:
Opened Server Explorer.
Right-clicked the Data Connections node and then selected Add Connection.
Filled in the connection information for my data source using OLE DB Provider for SQL Server.
Clicked OK to create the Data Connection named "CU2.PIT.pit_user".
My Problem:
I can see and retrive data from my Tables BUT I can not
1. Design Table when I right click on Tables
2. Can not add View when I right click on Views.
I gave user "pit_user" "create table and create view for table in SQL Server Enterprise Manager.
Thanks in advance.
SQL Server 2000 is running on Window 2003 Server
Visual Studio 2003 is running on Windows XP Pro - SP2
sw007
