How can I manage MSSQL database via Visual Web Designer 2005?
Top : General Technical Support : Microsoft SQL Server
| Article ID: |
 |
000068 |
| Rating: |
|
5.0 / 5.0 (4 votes)
|
| Views: |
|
4015 |
|
|
How can I manage MSSQL database via Visual Web Designer 2005 Express Edition?
|
1. Open Visual Web Designer 2005 and click Tools > Connect to database ... menu item
2. Put MSSQL database server IP and port # (xx.xx.xx.xx,####) in the "Server Name" box. Select "Use SQL Server Authentication" and put MSSQL database username and password in the box. Enter the database name as well. You can click "Test Connection" button to test it out. Click "OK" button if the test is successful.
3. You can create or delete table, view, stored procedure and function in the "Database Explorer" window.
|
