Saturday, November 05, 2005 - Posts

Error Codes in SQL 2005 BOL

My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/Error Codes in SQL 2005 BOL
The new RSS feed is here

If you've trued to find the meaning/resolution for a particular error code in BOL for SQL Server 2005 then you will be left wanting. They have been removed. Why I hear you ask, well when I asked they said it was to centralise the information to enable it to be updated more easily.

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/Error Codes in SQL 2005 BOL

Restoring Full text catalogs

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

When you restore a database with a full text catalog, if you want to specify a location for the catalog, unlike other files in a restore the catalog requires a directory. Further more it requires a directory that is not in the root of a drive i.e. d:\myFtCatalogs is not valid.

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/Restoring Full text catalogs