Recently I was contacted by a client who migrated a new Stored Procedure to production and wondered why replication all of a sudden ‘broke’ when the new Stored Procedure was added to the publication.
Category Archives: SQL Server
In SQL Server 2005 all objects in a database are now located in schemas and are not owned by individual users. In order to move an object from one schema to another
The January 2006 edition of the WARDY IT SQL Server Newsletter has been e-mailed to everyone on the distribution list.
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.