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 Februrary 2006 edition of the WARDY IT SQL Server Newsletter has been e-mailed to everyone on the distribution list.
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.
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.
In SQL Server 2000 Built-in nondeterministic functions were not allowed in the body of a user-defined functions (UDF).
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.
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