Browse by Tags

All Tags » SQL Tools (RSS)
08 February 2010 16:27

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. "...
Posted by sqldbatips | with no comments
Filed under: , ,
07 November 2009 17:55

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...
Posted by sqldbatips | 1 comment(s)
Filed under: , ,
21 October 2009 18:08

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...
Posted by sqldbatips | 1 comment(s)
Filed under: , ,
13 September 2009 21:20

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...
Posted by sqldbatips | 1 comment(s)
Filed under: , ,
10 August 2009 18:19

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...
Posted by sqldbatips | with no comments
Filed under:
08 August 2009 23:52

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...
Posted by sqldbatips | with no comments
Filed under:
15 May 2009 16:42

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 by sqldbatips | with no comments
Filed under: ,
06 May 2009 15:21

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...
Posted by sqldbatips | with no comments
Filed under: ,
28 April 2009 21:09

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...
Posted by sqldbatips | with no comments
Filed under: , ,
16 April 2009 19:02

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...
Posted by sqldbatips | with no comments
Filed under: , ,
07 April 2009 21:39

Updated build of ExpressMaint now available (1.8.0.0)

An updated build of the ExpressMaint utility for SQL 2005/2008 is now available. This release contains the following changes Added support for SQL Authentication Fixed an issue with databases that have not started being filtered out in Express Edition...
Posted by sqldbatips | with no comments
Filed under: , ,
07 March 2009 17:47

Updated build of ExpressMaint utility is now available (1.7.0.0)

An updated version (1.7.0.0) of the ExpressMaint utility for automating database maintenance operations for SQL 2005/2008 Express Edition is now available. This new version includes the following fix Fixed error when backing up instance with user instances...
Posted by sqldbatips | with no comments
Filed under: , ,
04 November 2008 18:17

Updated build of ExpressMaint utility is now available

An updated version (1.6.0.0) of the ExpressMaint utility for automating database maintenance operations for SQL 2005/2008 Express Edition is now available. This new version includes the following fixes Fixed error when database name contains an apostrophe...
Posted by sqldbatips | with no comments
Filed under: , ,
10 September 2008 20:43

First thing to do after installing SQL Server Management Studio 2008

One of the strangest UI design decisions in Management Studio for SQL 2008 is that by default the Start Debugging button is right next to the Execute button as shown below I myself have hit it by accident more times than I'd like to admit and I have...
Posted by sqldbatips | with no comments
Filed under: , ,
02 September 2008 14:23

Enabling My Reports feature in Reporting Services 2008

Although most of the functionality that used to be available for managing Reporting Services from Management Studio has now been removed in SQL 2008 (I assume because research showed the majority of customers use the Report Manager web interface), enabling...
Posted by sqldbatips | 1 comment(s)
Filed under: , ,
More Posts Next page »