Building Database Projects by Using SQL Server Management Studio
A database script project is an organized set of scripts,
connection information, and templates that are all associated
with a database or one part of a database. Microsoft SQL Server
provides the SQL Server Management Studio for administering and
designing SQL Server databases within the context of a script
project. SQL Server Management Studio includes designers,
editors, guides and wizards to assist users in developing,
deploying and maintaining databases. SQL Server Management
Studio is a suite of administrative tools for managing the
components belonging to SQL Server. This integrated environment
allows users to perform a variety of tasks, such as backing up
data, editing queries, and automating common functions within a
single interface. SQL Server Management Studio includes the
following tools: Code Editor is a rich script editor for writing
and editing scripts. The Code Editor replaces the Query Analyzer
included in previous releases of