The January 2006 edition of the WARDY IT SQL Server Newsletter has been e-mailed to everyone on the distribution list.
Monthly Archives: January 2006
This morning I received a call from a client who were receiving the error “Error occurred during the creation of the DTS Package”.
A database data or log file can be moved from one location to another using the following steps:
— 1) Detach the Database
EXEC sp_detach_db test
WARDY IT Solutions have just released two software utilities which we have made available for Free.
I will be running the course ‘SQL Server System Administration Essentials’ in Brisbane on Monday the 20th March 2005.
I will be attending the Adelaide SQL Server User Group on Thursday the 9th March 2006 to present on the SQL Management Object (SMO).
Below is a link to an article that I wrote which was recently published by SQL Server Central (http://www.sqlservercentral.com/) on using SED.
Effective as of December 31 2005 support for all versions of Microsoft SQL Server 7.0 transitioned from Mainstream Support to Extended Support.
The following feature comparison matrix illustrates the SQL Server 2005 features as well as the Maximum RAM and Processors by edition
Below is a link to an article that I wrote which was recently published by SQL Server Central (http://www.sqlservercentral.com/) on the the issues with dealing with NULLs