(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

(Muthusamy Anantha Kumar) Latency in a replication environment is the time it takes for a transaction to be transmitted from a publisher to the distributor and from the distributor to a subscriber. In this article, I am going to discuss how to find and monitor the latency frequency in a transact

(Andy Warren) What’s the easiest way to return a delimited list? Maybe you want to return a list of email addresses, comma delimited so you can just send out. Or you want to use an output parameter for the return values instead of a resultset (not always a good idea). Think on that for a minute. You

(Wei-Meng Lee) Microsoft has finally added reporting capabilities to its flagship database server, SQL Server 2000. Originally designed for its next release of SQL Server, SQL Server 2005 (codenamed Yukon), SQL Server 2000 Reporting Services was recently announced as an add-on to SQL Server 2000 due

(Gregory A. Larsen) Have you ever needed to write some code that would process through all the tables in a database? What about running some code against each database on a SQL Server instance? If so, did you know there are a couple of different ways to accomplish this? Either you can create a curso

(Michelle A. Poolet) You’ve been using keywords to help you locate data since you were a kid. Maybe you used a card catalogue the first time you went to your local library, or maybe the nuances of online search engines taught the youthful you about keywords. However you learned about them, you proba

(Scott) In SQL Server a view represents a virtual table. Just like a real table, a view consists of rows with columns, and you can retrieve data from a view (sometimes even update data in a view). The fields in the view’s virtual table are the fields of one or more real tables in the database. You c

(Hubli Sunil) This article explains about how to use ESCAPE keyword with LIKE to filter the data in a SQL query.

(Marcin Policht) In the first article of this series, we presented a high-level overview of SQL Server 2005 functionality, based on its most recent Beta 2 implementation. Our goal, going forward, will be to discuss each of new or improved features in more details, focusing on engineering and adminis

(Brian Knight) Renaming a server can be a mystery in SQL Server. The symtoms that SQL Server displays after you rename a server makes it look like you made a bad mistake. There are registry entries and system table records littered throughout your system that reflect the server’s name. In this b