Click here to Skip to main content
15,918,193 members
Everything / Database Development / SQL Server / SQL Server 2000

SQL Server 2000

SQL-server-2000

Great Reads

by Wonde Tadesse
This tip/trick helps to set a default value for blob data type such as Image, VarBinary.
by aleksisa
Build a process to import Leads records from Excel into MS CRM via email.
by Md. Marufuzzaman
How easy to read a file without using of the seven extended stored procedures.
by Sven Cipido
How to add a "select all" option to your parameter lists in SQL Reporting.

Latest Articles

by Shivprasad koirala
6 steps to enable transactions in WCF
by Ebenezar John Paul
An Ideal Code Review Checklist that applies for most programming languages
by BharatRamV
Finds the Best Table for a given set of columns
by Mark W Solomon
In this article, I developed a way to determine all the SQL Servers in our environment at will and filter this information into Microsoft's Sunset report for Microsoft SQL Server and present all this information in an SSRS report.

All Articles

Sort by Score

SQL Server 2000 

6 Sep 2007 by aleksisa
Build a process to import Leads records from Excel into MS CRM via email.
9 Mar 2005 by Sven Cipido
How to add a "select all" option to your parameter lists in SQL Reporting.
4 May 2004 by Daniel Aioanei, Adi Malinaru, Andrei Postolache
An article on how to persist permutations of items in relational databases.
19 Dec 2007 by Bryan Sachdeva
This article describes how to create a wrapper class for the native Phone API, and then uses it to retrieve and store the call history.
16 Oct 2007 by Adam Page
Setting up an SMS gateway to conduct an SMS survey and storing the survey results in an MS Access database, from which you can generate/print out reports.
28 Aug 2012 by akhil khare
Find multiple strings (delimenated by space) in all selected columns.
1 May 2012 by Jean-Francois Lanouette
This is an alternative for "Simple & Advanced Pivots with C# and ASP.NET"
7 Aug 2012 by ManojKumar19
This tip demonstrates how table data can be shared in two stored procedures.
24 Jun 2009 by Kuldip Rindani
Monitoring group of Linked SQL Servers from a SQL Server
24 Jun 2004 by Redgate Software
A simple solution to scripting when sysdepends are damaged
2 May 2006 by Petr Palas
This article compares various approaches to storing, editing, and displaying structured content on the web. It shows the advantages and disadvantages of using XML and relational SQL databases.
30 Jun 2006 by Redgate Software
SQL Dependency Tracker allows you to graphically visualize database object dependencies. This means that users can track down potential "collateral damage" before pushing database changes through. With this ingeniously simple to use tool, you can also document database dependencies.
1 Nov 2006 by Redgate Software
This article describes how you can use SQL Refactor to sharpen up your T-SQL.
7 Nov 2006 by Daniel Wood
Learn how changing the way you write queries can make them run faster. This article will describe the automated approach to optimizing SQL. DBA's have been doing it for years, now it's available for developers.
21 Dec 2006 by Redgate Software
Database professionals have a special role in their workplace because they bear responsibility for customer database integrity. This article argues that the 'online' or 'lock ladder' database development model, which uses live instances is the only way to ensure true database integrity.
15 Oct 2007 by Tijoy Tom
17 Dec 2007 by mfmaneef
Explains how to send bulk records to a database using OPENXML.
29 Apr 2009 by Raspberry Man
How to make custom datasource for CrystalReports engine using push model and .NET
12 Jan 2014 by Christian Graus
In this third installment, we look at how Common Table Expressions can simplify your SQL and help you perform complex tasks
16 Jan 2014 by Christian Graus
Discussion on pivot and other ways to turn columns of data in to rows in SQL Server
28 Apr 2005 by emadns
How to start a connection using ATL OLE DB consumer classes and how to obtain a session so that you can use it to query or edit the database.
11 Jul 2005 by Chester Ragel
A tool which can be used to do common tasks which Microsoft Content Management Server API provides.
22 Aug 2009 by Md. Marufuzzaman
This article will give you an idea about how to integrate an OLE Object that is a COM+ API with SQL Server and write a message into a Windows event log.
16 Aug 2005 by Omar Al Zabir
Comprehensive guide to development of .NET 2.0 Smart Clients working with existing Service Oriented Architecture based XML web services, fully utilizing the Enterprise Library
21 Jan 2014 by Christian Graus
A description of the best way to create tally tables, and how to use them
11 Jun 2008 by Billy McCafferty
This article describes best practices for leveraging the benefits of NHibernate 1.2, ASP.NET, generics and unit testing together.
3 Feb 2009 by C.L. Moffatt
This article describes SQL Joins in a visual manner, and also the most efficient way to write the visualized Joins.
25 Jul 2009 by Md. Marufuzzaman
This article will demonstrate the procedure to shrink the database transaction log.
18 Oct 2013 by Brian C Hart
To save you from hunting through the docs and locating downloads, we gather both databases here and walk you through installing them using SQL Server Management Studio Express -- updated for SQL Server 2008 Express Edition!
3 Oct 2016 by Mark W Solomon
In this article, I developed a way to determine all the SQL Servers in our environment at will and filter this information into Microsoft's Sunset report for Microsoft SQL Server and present all this information in an SSRS report.
30 Nov 2006 by siva pinnaka
This article explains how to migrate data between different SQL Server environments.
19 Aug 2009 by Md. Marufuzzaman
A list of Global variables in SQL Server and their uses in Transact-SQL
26 Jun 2008 by johnnycantcode
Create and manage your mobile database using SQL Management Studio and export them to SQL Compact Edition databases
28 Apr 2005 by Thomas Kurek
Unsatisfied with the accuracy of code online that assumes the Earth is a sphere, I have implemented the oblate spheroid model used in GPS.
13 Jan 2013 by liron.levi
A C# utility to automatically do conversion from a SQL Server DB to a SQLite DB
7 Aug 2006 by craigd
Save your database diagrams *outside* the database in a Transact-SQL text file, for backup and/or source-control.
22 Aug 2004 by Shams Mukhtar
This article will enhance your vision on the usage of Robustness Analysis in conjunction with Model View Controller, using UML with application in ASP.NET. This article is a sequel to my articles on Architecture and Design with ASP.NET.
13 Jul 2010 by Md. Marufuzzaman
15 Jun 2009 by Md. Marufuzzaman
This article will demonstrate how we can integrate T-SQL with an external application.
4 Jan 2005 by DGoins
This article explains a brief introduction to SOA and a Subscriber-Publisher model, along with how to implement one using WSE SOAP Receiver and WSE SOAP Sender classes inside a Windows .NET application.
5 Aug 2004 by Jasmin Muharemovic
An article about optimization and performance testing of MS SQL Server 2000 stored procedures used for paging of large resultsets in ASP.NET
8 Sep 2010 by Shivprasad koirala
.NET 4.0 MEF FAQ (Socket, Plug and extension)
9 Dec 2010 by AnupKumarYadav
Can be used in Multilevel Marketing with binary tree (can be modified accordingly to be used for n Tree)
7 Jun 2011 by Shivprasad koirala
SQL Query Optimization FAQ Part 1 (With video explanation)
23 Sep 2015 by Alberto Venditti
Using a .NET Windows service as an engine for specialized custom plug-ins execution
24 Feb 2017 by Ebenezar John Paul
An Ideal Code Review Checklist that applies for most programming languages
6 Apr 2005 by Stefan Prodan
Deploy MS SQL Server databases using System.Configuration.Install and a VS.NET Setup Project.
26 Jan 2010 by BackyardHackMechanic
Describes how to get more control over the XML output when using the FOR XML AUTO statement. For instance, when adding XML tags.
16 Jan 2005 by Sumit Amar .
Stored procedure to generate INSERT..VALUES statements in SQL Server.
15 Apr 2006 by Raj Lal
A dynamic web application needs an admin section for CRUD actions on the records/tables in the database. Wouldn't it be nice to have a database admin, which can be plugged to any web application? Just give your SQL connection string and it dynamically manages all table operations in just five pages.
7 Sep 2009 by Muhammad Akhtar Shiekh
An artcile on End to End solution to optimized paging and sorting in ASP.NET GridView using Object Data Source.
5 Jun 2005 by smiling4ever
To make a dictionary that will work with Google Suggest like Dictionary.
23 Jan 2005 by Colin Angus Mackay
Discusses various aspects of SQL Injection attacks, what to look for in your code, and how to secure it against SQL Injection attacks.
13 Sep 2009 by Md. Marufuzzaman
A simple example of SQL server admin tools.
18 Apr 2005 by earmitage
An article on enumerating SQL Server instances in C# using ODBC thus removing any dependancy on SQLDMO. Based on the C++ article by Santosh Rao.
9 Aug 2009 by Md. Marufuzzaman
This article will demonstrate how to split a string using Transact-SQL.
29 Apr 2009 by Kamran Hazari
How to create Linked servers in a minute in an easy way
28 Mar 2013 by Khorshed Alam, Dhaka
How to execute multiple long running SQL Statement Asynchronously in smaller chunks
27 Sep 2005 by Mikael Håkansson
QueryCommander SQL editor with IntelliSense, wrapped in a Visual Studio type of environment. QueryCommander supports: Microsoft SQL Server 6.5-2005, MySQL 4.*-5.1, and Oracle 9i.
29 Jan 2009 by Nitesh Maharaj
How to create simple and advanced pivot tables in C# and ASP.NET
10 Sep 2004 by mysorian
A step-by-step approach to creating a report from scratch using the SQl Server 2000 Reporting Services.
3 Jun 2006 by User 992674
Restore/backup selected objects in SQL Server.
4 Sep 2013 by Mubin M. Shaikh
This article shows how to create and populate date dimension for data warehouse.
11 Jan 2008 by Rafik Robeal
Build occasionally connected applications using Microsoft Synchronization Services for ADO.NET
8 Jul 2004 by Simon Steed (SimonAntony)
This article explains how using caching within your Windows Forms application can speed up data access for frequently used data and avoid performance bottlenecks over the network.
3 Mar 2008 by Alex Baker
Change collation order for all text columns in a database
4 Jun 2010 by Syeda Anila Nusrat
Create a Business Logic Layer, Data Access Layer classes, and Stored Procedure scripts from a database table.
3 Sep 2008 by pinaldave
SQL SERVER - 2008 - Configure Database Mail - Send Email From SQL Database
16 Mar 2005 by Dan Farino
An Extended Stored Procedure to use regular expressions in T-SQL.
2 Nov 2015 by icemanind
14 Nov 2004 by Lars-Inge Tønnessen
An article on how to setup and configure the MSFT MSDE 2000.
26 Dec 2004 by Gavi Narra
An implementation of Google suggest using remote scripting.
14 Aug 2012 by Duong Ba Hong Minh
A good way to setup and install a multi-tree level structure by using a MS SQL Server database.
5 Jul 2009 by Shivprasad koirala
Optimizing LINQ Queries using DataLoadOptions
24 Oct 2006 by Jürgen Bäurle
This article describes how to create Data Access Layer Components (DALC) using ASP.NET build providers and a self-defined description language in C#, including an easy scanner, parser, and CodeDOM generator.
29 Jul 2009 by Md. Marufuzzaman
This article will demonstrate the best practice to protect SQL server code object.
9 May 2007 by Peter Weissbrod
This is the second part in a two-piece article focused on optimizing the efficiency of your NHibernate ORM layer.
7 Mar 2008 by Alexander Kojevnikov
sqlTunes is a small tool that exports iTunes library information to the SQL server.
20 Apr 2008 by gan.gary
An article on a SQL IDE for different type of RDBMS databases
22 Dec 2009 by Suresh Suthar
How to execute DTS packages through VB.NET and use global variables.
6 Jan 2014 by Christian Graus
Just a quick explanation of why it's not always a good idea to use DISTINCT
29 Jun 2011 by michael.neubrander
Multi account synchronizer for GMail, AD, and SQL Server.
4 Nov 2006 by Uwe Keim
An application to manage support request with tickets and events
5 Apr 2016 by SQLMonger
SQL Function to parse a delimited string and return it as a table. Handles multi-character delimiters and returns the results as a table.
11 Jan 2012 by Venkat Chaitanya Kanumukula
T-SQL Code for Converting Stored Procedure results to Tables Dynamically
7 Sep 2006 by Shahed.Khan
This paper demonstrates an extensible mass emailing framework (Smart Mass Email SME). The demo implementation uses cutting edge .NET technologies available today such as C#, .NET 2.0, Microsoft® SQL Server 2005 Service Broker, MS Provider Pattern, Enterprise Library January 2006 etc.
31 Jul 2005 by _Asif_
Article that helps writing SQL in XML to provide better support
26 Apr 2008 by Sudipta Chaudhari
This article gives a brief introduction about Triggers in SQL Server 2000/2005.
12 Jan 2007 by Mark J. Miller
Defining (rather loosely) ad hoc queries as SQL commands built as strings by an SQL client application and submitted to SQL Server.
22 Sep 2009 by Abhijit Jana
Basic overview of temporary Tables in SQL Server 2005
4 Apr 2006 by Salvatore Vetro
The art of swap from a database to another changing a flag
9 Jan 2005 by Kim Sheffield
The RDL Project is an open source (GPL) implementation of the RDL for the .NET environment created by fyiReporting Software. RDL is an XML based language created by Microsoft with the goal of promoting interoperability of reporting products. Project RDL is a compact implementation of RDL.
12 Mar 2014 by Christian Graus
The second in my series digs in to some of the different things you can do within a select statement.
1 Jun 2009 by Dwayne Macadangdang
An article on creating a Hybrid Smart Client for Twitter using the Windows Presentation Foundation and the TwitterLib class library
15 Aug 2004 by Elvin Cheng
Solve the ViewState problems using the industry well-known pattern - Provider Model design pattern.
17 Oct 2009 by Nitinpatel
T-SQL script to generate the document of SQL 2000/2005 database
10 Oct 2005 by Michael.Piccolo
How to add DataGrid columns dynamically with ITemplate, XML and templated controls.
17 Aug 2009 by P. Ganesh Kumar
Helps in assigning row numbers in the returned result of an SQL query
17 Apr 2005 by Gael Fraiteur
If you want to tune your SQL statements, you need to understand how the server executes them. The article explains this.