SQL Server Management Studio NEW in 2005

SQL Server Management Studio ^{NEW in 2005}

SQL Server Management Studio provides a Windows form-based, integrated environment that can manage various SQL Server components . From the SSRS perspective, the Management Studio has similar functionality to Report Manager when used to manage a single instance of SSRS.

The advantages of using the SQL Server Management Studio include consolidated content view for SSRS web farm (scale-out) deployment, slightly better performance, an ability to script and replay administrative tasks , and a finer granularity for role-based security settings.

Tip

Use the SQL Server Management Studio for a consolidated view of a SSRS web farm.