Other News

Community

Generic Data Comparison

(Leo Peysakhovich) One of the problems frequently faced by the DBAs or database developers is data comparison. Specifically, data residing in separate databases. The company I am working for has 2 types of databases: Access and SQL Server. Very often I need to compare data in different tables in dif

Community

Easy Package Configuration

(Jamie Thomson) One of the age old problems in DTS is moving packages between your development, test and production environments. Typically a series of manual edits needs to be done to all the packages to make sure that all the connection objects are pointing to the correct physical servers. Thi

Community

Save Query Output in SQL Server

(Vinod Kumar) There are requirements in various forums that you would like to save the output of the query. There are a number of solutions given. In this code snippet I will give you a method to use this from a script point of view. For the given task I create a generic proc that will facilitate in