(Barrie Sosinsky) SPEED Ferret is one of those little find and replace tools that can help programmers by reducing the time it takes to find the properties of objects, search for strings and find and replace program code. This is a global search and replace tool that takes the place of the sequentia

The command line utility ISQL.EXE uses the currently logged in network user name for the SQL Server login name if the -U parameter is omitted or is specified without a name after the parameter instead of passing null. This may cause the error 4002, ‘Login Failed’ when connecting to SQL Server in

Three years ago, the South Carolina Department of Juvenile Justice (DJJ) made a critical decision: Faced with the limitations of its 18-year-old mainframe system hard-wired to 43 county offices, the DJJ began using SQL Server tools to develop a web-based system for tracking juvenile offenders.

(Gregory A. Larsen) In last month’s article, I discussed what and how to use a subquery in a T-SQL statement. This month I will expand on this subject by discussing correlated subqueries. I will explain what a correlated subquery is, and show a number of different examples on how to use a subquery i

In SQL Server 2000, you may notice that SQL Server 2000 stops listening for a new TCP/IP Socket connection unexpectedly after you receive error 17882 in the SQL Server 2000 error log. This behavior occurs even though the 17882 error message states “Execution continuing.” The following is the complet

(Rob Walters) This document provides an overview of new features for the SQL Server Agent job scheduling service for Microsoft SQL Server 2005 Beta 2.

(vijaya Krishna) A Stored procedure is a database object that contains one or more SQL statements. In this article you will get an idea on how to create and use stored procedures and also highlighted on how to use stored procedure.

HP has partnered with Microsoft to provide information about running Analysis Services in the 64-bit environment. For users of the online analytical processing (OLAP) and data mining component of SQL Server 2000, there are real performance advantages to be gained by using the new 64-bit release of t

If a stored procedure or view depends on a table that has been dropped, sysdepends will continue referencing the old ID of the table as a dependent, even if this ID does not exist any more. As a result, sp_depends will not show the correct object dependency.

(vivekthangaswamy) .NET is the new distributed computing platform developed by Microsoft and ASP.NET is its programming model for web development. The intent of this article is to get a good experience in developing data driven ASP.NET Web Forms applications by means of a real world application.