Blogs about: Sql Server 2000
Featured Blog
Deleting duplicate rows when there is no primary key
set nocount on create table #tbFruit (Fruit varchar(20)) insert into #tbFruit (Fruit) values (’apple’) insert into #tbFruit (Fruit) values (’apple’) insert into #tbFruit (Fruit… more →
Welcome........
Automatic Script Generation for SQL Server Objects
chonglongchoo wrote 2 days ago: To produce scripts for every object and configuration in a SQL Server. DOWNLOAD … more →
Document SQL Server Configurations and Objects
chonglongchoo wrote 2 days ago: To document configurations and objects in Microsost SQL Server 97 and 2000. DOWNLOAD … more →
Generating Random Passwords in SQL Server
dacosta9 wrote 4 days ago: From time to time I generate the password for new database users, here is the code I use. This works … more →
SQL Server Dictionary Search
dacosta9 wrote 4 days ago: Sometimes I am thrown into a situation where I need to find a column of parameter in tables, stored … more →
Exception handling in Sql server 2000
kcherupa wrote 2 weeks ago: When I was working on a project, I had written a sproc which runs in sql server 2005. I had used Try … more →
SQL Server 2000: Error 14274: Cannot delete a job that originated from an MSX server
Brandon Ryan wrote 3 months ago: I don’t work much with older versions of SQL server, but I came across the following error tod … more →
Move SQL Server 2000 database to 2005
— 8 comments
twinklekumar wrote 3 months ago: Introduction This discussion details how to move a MS SQL 2000 database to SQL 2005 database using b … more →
How do I use GETDATE() within a User-Defined Function (UDF)?
— 1 comment
Bauyrzhan wrote 4 months ago: SQL Server 2000 added the support for user-defined functions, but there are a few limitations which … more →
SharePoint 2003/MOSS 2007: Take back up of content database in SQL Server 2000 and SQL Server 2005
MF wrote 4 months ago: The content database of SharePoint Portal Server 2003 ends with 1_SITE like Abc1_SITE and for MOS … more →
xp_Sendmail
imcrunchy wrote 5 months ago: This is the first post in this blog. My intent is to write technical articles focusing on the things … more →
Paging in SQL Server 2005
jwalin wrote 5 months ago: With Microsoft SQL Server 2005, paging on the database side is simple. There is a built-in ROW_NU … more →
Tips: Deleting a Lot of Rows from a Database
Pie wrote 6 months ago: Recently, I had to remove a large number of rows, almost 10 million, from a very active database tab … more →
SQL SCRIPT GENERATOR
geneticvital wrote 6 months ago: If you want to create Database Scripts, Object Scripts or insert statements of SQL server databa … more →
SQL Server Table Partitioning without Enterprise Edition
Coolcoder wrote 6 months ago: I am going to show a way to have table partitioning in SQL Server databases without the need for the … more →
Contoh cepat akses data SQL Server 2000 menggunakan VB.Net 2003
— 2 comments
anangbakti wrote 7 months ago: Salah satu kawan saya minta tolong untuk dibuatkan contoh sederhana manipulasi data SQL Server mengg … more →
DotNetNuke 4.08.01 Installation Tips
dcsaha wrote 7 months ago: I was having trouble installing DotNetNuke (DNN) on SQL server 2000. It was giving me the error mess … more →
SQL Server 2000: DTS Error; Bulk Copy Execution Failed
— 1 comment
pscyclone wrote 7 months ago: This will be a short post today, mainly to help me remember what this error is about and hopefully … more →
SQL Server 200: Setting Up Merge Replication
— 1 comment
Philippe Almog wrote 8 months ago: One of the best guide on Merge Replication (SQL Server 2000) Source: Alexander Chigrik September 200 … more →
Error Code 5173 in SQL Server
victorlaoh wrote 10 months ago: If you want to attach a MDF without LDF you can follow the steps below It is tested and working fine … more →
Have your say. Start a blog.
See our free features →
An 
Opus
