Browse by Tags

All Tags » Management Studio (RSS)
07 June 2007 19:24

Fix for DMF scheduled policy checking in SQL Server 2008 June CTP

If you have been trying out the new Declarative Management Framework policies you may have run across an issue trying to use an Execution mode of Check on Schedule with the error " Could not load file or assembly Microsoft.SqlServer.DmfSqlClrWrapper ...
Posted by sqldbatips | with no comments
Filed under: ,
08 March 2007 07:23

SQL 2005 Performance Dashboard Custom SSMS Reports available

As I've previously blogged about, SQL 2005 SP2 allows users to write custom reports that are hosted in SSMS and are available via the Reports context menu in Object Explorer. Microsoft have now released a group of reports that can be used to troubleshoot...
Posted by sqldbatips | with no comments
Filed under: , ,
07 March 2007 15:02

Another SP2 Maintenance Plan bug - Database Integrity Checks

** Update: A hotfix is now available to address this issue here for SQL versions 3042 through 3053** ** Update: A hotfix is now available to address this issue here for SQL versions 3150 through 3158** Tony has picked up on another issue with SP2 in regard...
Posted by sqldbatips | with no comments
Filed under: , ,
24 February 2007 14:50

Maintenance Plan Changes in SQL Server 2005 SP2

** Updated please check here for details of hotfix ** Users of SQL Server 2005 maintenance plans should be aware of a change in SP2 that affects existing cleanup tasks until updated using SQL Server SP2 tools. Who is affected? You are affected if you...
Posted by sqldbatips | 3 comment(s)
Filed under: , ,
20 December 2006 17:42

SQL 2005 Service Pack 2 December CTP now available

The December CTP of SQL Server 2005 Service Pack 2 is now available for download here . You can also download the latest CTP of SQL Server 2005 Books Online (BOL) from here . One of the changes which I mentioned in an earlier post is that custom reports...
Posted by sqldbatips | with no comments
Filed under: ,
28 November 2006 23:30

Custom SSMS Reports in SP2 - Enterprise Manager Taskpad View

This is probably one of the most requested reports for Management Studio, a simple overview of the total size and used space for your database files like that available in Enterprise Manager for SQL 2000 via the Taskpad view. Whilst Management Studio...
Posted by sqldbatips | 7 comment(s)
Filed under:
23 November 2006 19:10

A word of warning about custom reports in SSMS

If you are tempted to run a custom report in SSMS that you didn't write yourself then please do open it in BIDS (just rename the .rdlc extension to .rdl for the Nov CTP to make sure you can see the queries) or your favourite XML editor first and examine...
Posted by sqldbatips | with no comments
Filed under:
22 November 2006 22:24

Remote datasources in SSMS custom reports

Currently only locally accessible data is available in custom reports hosted in SSMS (by locally I mean the instance/database you are connected to in Object Explorer). I'd really like to be able to pull in data from other sources hosted on remote servers...
Posted by sqldbatips | with no comments
Filed under:
22 November 2006 22:22

SSMS Custom Reports Backwards Compatibility (or lack thereof)

Currently with regard to custom reports in SSMS there is no support for SQL 2000 instances (or even databases on a SQL 2005 instance in compatibility mode 80). Custom reports only support SQL 2005 databases in compatibility mode 90. Something to be aware...
Posted by sqldbatips | 1 comment(s)
Filed under:
21 November 2006 18:28

Custom SSMS Reports in SP2 - Database Permissions

Once of the great new enhancements in Management Studio in SP2 is the ability for users to create their own reports. There's a nice write up with details of the builtin parameters (and some of the limitations) here . One of the views I miss most from...
Posted by sqldbatips | 9 comment(s)
Filed under: