SQL Server Management Studio NEW in 2005SQL 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. |