February 2006 - Posts

• Using Optional Predicates in a Stored Procedure

  The following Stored Procedure example demonstrates how optional predicates can be used in one statement based upon the parameters that are passed to the Stored Procedure. The only caveat is that the columns cannot be NULLABLE as the predicate will not Read More... Posted Monday, February 27, 2006 7:18 PM by peter@wardyit.com | 0 Comments

• February 2006 SQL Server Newsletter

  The Februrary 2006 edition of the WARDY IT SQL Server Newsletter has been e-mailed to everyone on the distribution list. For those not on the distribution list you can view the newsletter using the following URL http://www.wardyit.com/newsletters/feb2006.htm Read More... Posted Sunday, February 26, 2006 10:57 AM by peter@wardyit.com | 0 Comments

• Movie of How to Use the SSIS For Each Container

  I have recently been demonstrating SQL Sever Integration Services (SSIS) to a number of people and there seems to be some confusion on how the (SSIS) For Each Container can be used to to perform an operation on a collection. Rather then trying to document Read More... Posted Monday, February 20, 2006 8:46 PM by peter@wardyit.com | 0 Comments

• Register Server in Enterprise Manager Using SQLDMO

  A question I was recently asked is how the SQLDMO object can be used to register Servers and Server Groups in SQL Server Enterprise Manager. The following VBScript snippet demonstrates adding a new Server Group and adding a Server to the newly created Read More... Posted Saturday, February 18, 2006 10:42 PM by peter@wardyit.com | 0 Comments

• GETDATE() in a UDF

  In SQL Server 2000 Built-in nondeterministic functions were not allowed in the body of a user-defined functions (UDF). If you attempted to create a UDF that used GETDATE() you received an error similar to: Server: Msg 443, Level 16, State 1, Procedure Read More... Posted Wednesday, February 15, 2006 2:50 PM by peter@wardyit.com | 0 Comments

• Replication and QUOTED_IDENTIFIER

  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. The reason is that the Stored Procedure was using Quoted Read More... Posted Monday, February 13, 2006 10:02 AM by peter@wardyit.com | 0 Comments

• Moving Objects to Another Schema

  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 in the same database the ALTER SCHEMA command can be used. For example to move the HumanResources.Department Read More... Posted Thursday, February 02, 2006 2:36 PM by peter@wardyit.com | 0 Comments