visual studio .net ide: hi All,

Could anyone confirm that I only need Visual Studio .Net Professional and
*NOT* Enterprise Architect to allow me to edit/create Stored Procedures on a
SQL Server 2000 database?

Cheers!
Kyle

http://msdn.microsoft.com/vstudio/howtobuy/choosing.aspx

"Visual Database Tools
Design stored procedures, indexes, tables, triggers, user-defined functions,
and other database elements visually. In Visual Studio .NET Professional,
these design capabilities are limited to the SQL Server Desktop Engine."

If you don't want to get Enterprise Architect, you might consider Microsoft
SQL Server Web Data Administrator (Free). It can be found at:
http://snipurl.com/4w25

Snipped:
------------------------------
The SQL Server Web Data Administrator enables you to easily manage your SQL
Server data, wherever you are. Using its built-in features, you can do the
following from Microsoft Internet Explorer or your favorite Web browser:

-Create and edit databases in SQL Server 2000 or Microsoft SQL Server 2000
Desktop Engine (MSDE 2000)
-Perform ad-hoc queries against databases and save them to your file system
-Export and import database schema and data
-Manage users and roles
-View, create and edit stored procedures

Whether you are doing Microsoft Windows or Web development, or just need
remote access to data for yourself or your clients, the Web Data
Administrator is the perfect complement to your toolbox.
------------------------------

Cheers,
Sam

[quoted text, click to view]