Bugs (RSS)

Full text thesaurus files bug in documentation

My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/Full text thesaurus files bug in documentation
The new RSS feed is here

I don't normally blog about documentation errors generally because they're often not that major however this one is fundamental what is being explained.

This is the page online http://msdn2.microsoft.com/en-us/library/7f5424a4-a72c-44dc-b455-786a12767c99.aspx It talks about creating new thesaurus files. Unfortunately the XML example is wrong. When I looked at it intially I was suprised because the diacritics element wasn't valid XML. Well looking at the examples in the <SQL install folder>/FTData/ts????.xml you can see that the example in the documentation is wrong.

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/Full text thesaurus files bug in documentation

SQL 2005 install hangs on "Setting File Security"

My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/SQL 2005 install hangs on "Setting File Security"
The new RSS feed is here

When doing an install of SQL 2005 you may encounter the install hanging on the "setting file security" stage.

This is due to th install trying to do some security resolution with domain controllers.

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/SQL 2005 install hangs on "Setting File Security"

Maintenance plan warning for SP2

My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/Maintenance plan warning for SP2
The new RSS feed is here

Due to a regression bug introduced in SP2 some of the maintenance plan tasks that can operate on multiple databases may not perform as expected.

If a maintenance plan component uses TSQL of this nature

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/Maintenance plan warning for SP2

SSMS Custom reports - Drill through reports

My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/SSMS Custom reports - Drill through reports
The new RSS feed is here

If you intend using the new custom reports feature of Management Studio and develop a set of reports that you can navigate between then be aware of a  feature where by if you refresh a drill through report the some of the parameters are not maintained.

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/SSMS Custom reports - Drill through reports

SQL Server sucks - Stop complaining and do something about it

My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/SQL Server sucks - Stop complaining and do something about it
The new RSS feed is here

Further to my last post about the BULK UPDATE suggestion I have made, if you have any suggestions or bugs of your own then please put them into connect.

Please also support the bugs and suggestions that others have raised. The list of non-closed bugs and suggestions can be found here.

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/SQL Server sucks - Stop complaining and do something about it