Author: SSWUG Research

Community

Manage Data With VS 2005

(Roger Jennings) The Microsoft Developer Tools Roadmap promised that Visual Studio 2005 would “radically enhance the experience of manipulating and retrieving data” by simplifying “data source design from within the development environment” (see Additional Resources). Planned UI enhancements include

Community

Using the SMO API

(Brian Mains) With the Microsoft SQL Server 2005 product, a new set of .NET API’s are available. These API’s can be used to interface with a SQL Server (called SMO) to perform a multitude of actions. For example, the APIs can retrieve all of the databases, tables, and columns that reside on a specif