Click here to Skip to main content
15,867,704 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 Title

SQL Server 2000 

8 Sep 2010 by Shivprasad koirala
.NET 4.0 MEF FAQ (Socket, Plug and extension)
26 Jul 2008 by John Kenedy S.Kom
This project enables developers to create a setup package that automatically installs MSDE and attaches database
4 May 2009 by Shivprasad koirala
4 steps to create free SSL certificate for development
24 Mar 2009 by Shivprasad koirala
4 steps to use readymade DAL component (Data application blocks)
11 Jan 2006 by Petr Palas
Did you know there’s an easier way how to create dynamic web sites? Learn how Kentico CMS for ASP.NET will increase your productivity and help you win more clients.
23 Jun 2021 by Shivprasad koirala
6 steps to enable transactions in WCF
20 May 2005 by zhengdong jin
It's very easy to use and the most conventient DataGrid pager control.
23 Sep 2015 by Alberto Venditti
Using a .NET Windows service as an engine for specialized custom plug-ins execution
14 Apr 2005 by poodull76
Create T-SQL command text to update a table with OpenXML quickly and with minimal effort.
6 Apr 2005 by santosh poojari
This article shows you how to make use of DataAccessLayer and caching.
10 Sep 2004 by Mark Brandon
A helper object library to automate migration of SQL RS items from development to production servers.
28 Jun 2008 by Simon Gulliver
A lighweight approach to creating AJAX.NET-enabled grids, with advanced functionality built in.
25 Nov 2005 by TofuBug24
Shows a solution for creating a Master-Detail relation using textboxes.
19 Sep 2009 by Paul Rony
A Programmer's Guide to Starting a Software Company and Building an Enterprise Application
18 Apr 2005 by Uri Lavi
A simple database viewer to manipulate SQL Server data types (in particular: image, binary, varbinary and text).
13 Sep 2009 by Md. Marufuzzaman
A simple example of SQL server admin tools.
28 Apr 2005 by Stephan Pilz
A tool to generate/manage news and provide news via RSS.
19 Aug 2009 by Md. Marufuzzaman
This article will give you an idea about how to use CASE expression in T-SQL or as a formula of a particular column.
20 Oct 2005 by codeajay
A simplified SQL-CSV import/export functionality.
20 Apr 2008 by gan.gary
An article on a SQL IDE for different type of RDBMS databases
26 Feb 2009 by Lindsey Lewis
An article about a tool for comparing SQL database schema versions
18 May 2008 by defwebserver
A wizard that allows you to FTP an application to a remote server and then launch the configuration wizard from the web browser to update the database connection.
3 Jul 2007 by Steve Abraham
This article is an introduction to the SQL Server Virtual Device Interface and how to access it via any .NET language
29 Jun 2011 by michael.neubrander
Multi account synchronizer for GMail, AD, and SQL Server.
9 Mar 2005 by Sven Cipido
How to add a "select all" option to your parameter lists in SQL Reporting.
31 Jan 2006 by arunpv
Add/drop Linked Servers using SQL Server 2005 SMO
18 Feb 2005 by rasheed1979
This article demonstrates administrating SQL Server 2000 from Pocket PC on the fly.
31 Aug 2004 by mysorian
A tutorial on connecting to SQL 2000 Server.
17 Dec 2007 by mfmaneef
Explains how to send bulk records to a database using OPENXML.
19 Nov 2004 by Alexander German
With agStoredProc, you can generate a C# class out of all the stored procedures in a MS-SQL database. No Microsoft ApplicationBlocks needed.
15 Oct 2007 by Thanh Huu Nguyen (Tony)
Look up a huge list of stock symbols from MS SQL database
16 Feb 2005 by Jay Kulaindevelu
To change the row colors in reports.
14 Sep 2006 by salysle
This article describes an easy approach to examining all of the tables, views, and columns in a database.
9 Aug 2009 by Md. Marufuzzaman
This article will demonstrate how to split a string using Transact-SQL.
9 Aug 2009 by Md. Marufuzzaman
This article will demonstrate how to get a file name or a file extension as well using Transact-SQL.
30 Nov 2006 by siva pinnaka
This article explains how to migrate data between different SQL Server environments.
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.
18 Jul 2007 by Anton Pious Alfred
Most systems that use Stored Procedures make use of SQL parameters to send and receive information from the database. The code to create these SQL parameters and then populating them is repeated throughout the system. This article describes how to automate this code.
28 Nov 2005 by Pedro J. Molina
This article provides a way for automatically testing SQL embedded in your Data Access Layer (DAL) before publishing a new release of your application.
11 Jun 2008 by Srinath Gopinath
How to handle an array parameter in a Stored Procedure [SQL Server].
22 May 2006 by Jeff Modzel
How to create your own ASP.NET 2.0 custom resource provider to replace resource files (resx) with SQL Server.
9 Aug 2004 by mysorian
Walkthrough of generating a report from a SQL 2000 Server using the Reporting Services.
4 Mar 2014 by Shivprasad koirala
14 Feb 2005 by Alberto Venditti
An alternative and flexible way to manage config settings for multiple web applications.
18 Oct 2008 by Shivprasad koirala
Asp.Net Interview Question Part 3
27 Aug 2008 by Shivprasad koirala
ASP.NET interview questions: Part 1.
2 Oct 2005 by osohare
Porting and deploying the report starter kit to Linux (RH7.3/Tomcat5.0.28/Grasshoper1.61)
30 Sep 2005 by Abi Bellamkonda
ASP.NET Reports Starter Kit Porting from Windows to Linux using Mainsoft's Grasshopper
25 Apr 2007 by Mark Cafazzo
Race To Linux - How to port a Visual Studio .NET web application to the J2EE Framework on Linux
5 Oct 2005 by Abi Bellamkonda
ASP.NET TimeTracker Starter Kits Porting from Windows to Linux using Mainsoft's Grasshopper
24 Mar 2008 by jangtimjang
Do you want to know what your DB programmers are doing?
27 Sep 2009 by acarpio1975
Given date ranged data, adjust existing ranges on entry of a new ranged data.
8 Aug 2005 by Sangra
ASQLDataGrid is a useful component when working with RDBMS applications. It is capable of automatically constructing and executing SQL statements based on its properties.
8 Aug 2005 by Sangra
ASQLDataGrid is a useful component when working with RDBMS applications. It is capable to automatically construct and execute SQL statements based on its properties.
26 Jun 2006 by ashishinfra
The generalized class has static functions that return dataset and datareader objects , It accepts string(name of xml tag that stores the query) and value to be supplied in case query accepts parameters
27 May 2016 by icemanind
How to automatically create data access layers and business layers from a Microsoft Access or a SQL Server database
3 Oct 2008 by funklet
Make backups of SQL databases and upload them to FTP server
13 Dec 2004 by Boo!
This article is to help you create context sensitive connexion string: choosen dynamically, depending on which server the application is running.
17 Jun 2004 by SquaredRomi
A trigger is a database object that is bound to a table. In many aspects, it is similar to a stored procedure. As a matter of fact, triggers are often referred to as a "special kind of stored procedure".
16 Mar 2009 by junnark
In Part 1, we built a simple web chat using Silverlight 2. We are going to add functionalities so that users are able to choose from multiple chat rooms as well as chat privately with other users.
5 Apr 2006 by Dwight Johnson
Save hours of time by creating stored procedures and code from database metadata.
8 Jun 2009 by noahhath
Building a hybrid Active Directory and SQL table DataSource view.
30 Mar 2005 by paul heap
A plug-in for VS.NET that stores code snippets in a database. From the plug-in you can add code, search the database for code snippets. Also includes examples on how to integrate with the IDE as a plug-in.
24 May 2012 by Vimalsoft(Pty) Ltd
This article will show you how to build an N-Tier application in VB.NET.
30 Jan 2006 by Agha.net
This is a series of articles providing Building Blocks for any ASP.NET application.
9 Oct 2007 by John-ph
This article explains about building and executing a Dynamic SQL in a stored procedure.
6 Oct 2004 by rafael_p
One of the many solutions to build a quick and robust middle tier.
18 May 2007 by derekliang
This article is going to be served as an introduction to Expert C# 2005 Business Object by RockFord Lhotka which was written for business application developer.
23 Nov 2004 by JR Hull
Save time when developing large applications, by using code generation for your business objects.
20 Feb 2006 by PaulMcKenzie
This stored procedure will generate all the C# code for calling any Stored Procedure
5 Dec 2004 by T Manjaly
Anybody can write code! With a few months of programming experience, you can write "working applications." Making it work is easy, but doing it the most efficient way requires more work than just making it work!
29 Aug 2006 by sandeep@s
An introduction to executing SQL Server stored procedures and how to retrieve the return parameters
26 Oct 2000 by John Bevilaqua
SQL DDLs for creating table structures and inserting the data for a set of tables suitable for producing pick lists for validation of the Month Names, Month Numbers, Days in each Month and Years in the 20th Century
22 Jun 2009 by Kuldip Rindani
This script calculates size of every user database with summary
13 Feb 2006 by IPC2000
A handy command line tool that checks whether stored procedures, views and functions in a database compile
19 Sep 2008 by Emil Lerch
Command line tool to check validity of objects in SQL Server databases
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.
24 Feb 2017 by Ebenezar John Paul
An Ideal Code Review Checklist that applies for most programming languages
7 Apr 2005 by RichardRoe
CodeSmith template for creating Audit Log Triggers on SQL tables.
5 Jan 2013 by Vimalsoft(Pty) Ltd
Coding an N-Tier application in C# without using Wizards.
17 Nov 2006 by MarkWei
To dynamically generate a Google Map with combined data sources from an external web service or API and from an internal MS SQL database, using AJAX and the ASP.NET environment.
16 Jan 2008 by Paritor
Application to show differences between two SQL Server databases.
3 Feb 2004 by Chaudhary
SQL Server manager for remote monitering and managing.
22 May 2006 by vikas vohra
This article shows the implementation of Composite Server Control to provide Login features
18 Jul 2007 by Padoor Shiras
Computed Column Specification for populating nth column
26 Jan 2009 by Gil Shabat
Real-world Use Case: a flexible approach to present dynamic content with SQL Server, ASP.NET, and XSLT.
16 May 2013 by Peter Hancock
Using NAnt and CruiseControl.NET to continuously integrate database changes
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.
28 Dec 2003 by Eron Wright
Convert a datetime value to .NET-compatible Ticks using a T-SQL User-Defined Function. Useful for interoperation between .NET and unmanaged environments such as ASP and VB6
11 Jul 2008 by Wiltek Ghozali
This utility is used for convert query result into *.CSV, *.TXT, *.XLS or Fill Into Crystal Report, supported SQL Server and ODBC connection.
13 Jan 2013 by liron.levi
A C# utility to automatically do conversion from a SQL Server DB to a SQLite DB
23 Oct 2004 by ritzcoder
This article shows you how to take a date string and use it in a parameterized sql server query
4 Jun 2010 by Syeda Anila Nusrat
Create a Business Logic Layer, Data Access Layer classes, and Stored Procedure scripts from a database table.
2 Sep 2005 by Mukund Pujari
This application can be used to create databases, tables, stored procedures during the installation of .NET applications.
23 Dec 2007 by james.wren
How to add a modified on column in SQL Server using triggers.