Browse by Tags

Reporting Services Scripter - Proxy authentication required

When working in an environment that utilises a proxy server you may see the following error when trying to connect to a Report Server using Reporting Services Scripter " The request failed with HTTP Status 407. Proxy authentication required. " In order to fix this you need to create a configuration...

Posted to sqldbatips.com blog (Weblog) by sqldbatips on 02-08-2010
New version of Expressmaint now available (2.0.0.0)

A new version of the Expressmaint database maintenance utility is now available for download. This version adds the ability to specify a custom backup file name format. Please note there are specific version for SQL 2005 (2.0.0.0) and SQL 2008 (2.0.0.1) that differ only in the version of SMO they use...

Posted to sqldbatips.com blog (Weblog) by sqldbatips on 11-07-2009
Restoring an Expressmaint backup using SQL Server Management Studio Express

This post describes step by step how to restore a full database backup taken with Expressmaint (or by any other means) using SQL 2005 Management Studio Express (SSMS). The same steps apply to SQL 2008. To download this free tool for SQL Server Express Edition use the links below Download SQL 2005 Management...

Posted to sqldbatips.com blog (Weblog) by sqldbatips on 10-21-2009
New version of Expressmaint now available (1.9.0.0)

A new version of the Expressmaint database maintenance utility is now available for download. This version fixes an issue with the timeout parameter (-TO) being treated as seconds instead of minutes for the REORG task. Please note there are specific version for SQL 2005 (1.9.0.0) and SQL 2008 (1.9.0...

Posted to sqldbatips.com blog (Weblog) by sqldbatips on 09-13-2009
Running SQL 2005 Service Manager on Windows 7

If you install SQL 2005 Service Manager (Vista) on Windows 7 (the Vista version is required as it supports UAC) you will find that the system tray icon is hidden by default as part of the tidy up of the taskbar and notification/system tray area in Windows 7. You can customise the behaviour for a specific...

Posted to sqldbatips.com blog (Weblog) by sqldbatips on 08-10-2009
Expressmaint return codes

I keep meaning to document these as I get quite a few emails asking about them so here are the possible return codes from the Expressmaint utility (and no, I don't know what happened to -1!) 0 Success -2 Error initialising log file -3 Error connecting to SQL Server -4 Error enumerating list of databases...

Posted to sqldbatips.com blog (Weblog) by sqldbatips on 08-08-2009
New release of Reporting Services Scripter available (2.0.0.17)

A new release of Reporting Services Scripter is now available for download Fixes in release 2.0.0.17 Added fix for command line tool not accepting unc share paths as valid file paths for parameters

Posted to sqldbatips.com blog (Weblog) by sqldbatips on 05-15-2009
New release of Reporting Services Scripter available (2.0.0.16)

A new release of Reporting Services Scripter is now available for download Fixes in release 2.0.0.16 Added fix for fixing up shared datasource references for SQL 2008 when loading rdl files using RSScripterCmd New Functionality in release 2.0.0.16 Added new parameter to RSScripterCmd to allow shared...

Posted to sqldbatips.com blog (Weblog) by sqldbatips on 05-06-2009
Reporting Services Linked Report Generator updated for SQL 2008

A new release of Reporting Services Linked Report Generator is now available (1.0.0.8) confirming support for SQL 2008 Reporting Services. Reporting Services Linked Report Generator is a .NET Windows Forms application that enables automatic generation of linked reports to any number of Reporting Services...

Posted to sqldbatips.com blog (Weblog) by sqldbatips on 04-28-2009
New Release of Reporting Services Scripter (2.0.0.15) confirms SQL 2008 support

Judging by the increasing volume of emails I have recieved over the last few months asking about SQL 2008 support in Reporting Services Scripter there is a definate increase in the uptake of SQL Server 2008 Reporting Services and so I'm happy to say I've released a new build to confirm support...

Posted to sqldbatips.com blog (Weblog) by sqldbatips on 04-16-2009

Page 1 of 6 (51 items) 1 2 3 4 5 Next > ... Last »