NTVDM encountered a hard error installing SQL 2000 onto Windows Server 2003
Trying to install SQL server 2000 on windows 2003 Server SP2 I got ntvdm encountered a hard error. Please help

Answer Question   |  October 14, 2010  2:07 PM
NTVDM, NTVDM HARD ERROR, ntvdm.exe error, SQL, SQL Server 2000, WEBPASS, Windows Server 2003 SP2

Upgrading from SQL Server 2000 to SQL Server 2005
We want to upgrade our SQL Server 2000 to SQL 2005. What should we watch out for and what is the actual procedure for the upgrade? Will it require another server or can the upgrade be done in place?

Answer Question   |  October 4, 2010  2:29 PM
SQL, SQL Server, SQL Server 2000, SQL Server 2005, SQL Server 2005 upgrade, SQL Upgrades

How to update one table field with the help of more than one table in SQL Server 2000
How to Update one table field with the help of more than one table

Answer Question   |  October 4, 2010  10:25 AM
SQL Server 2000, SQL Server tables, SQL Server Updates, SQL tables

Infinite recursion in SQL Server 2000
consider a recursive query in SQL.How to handle infinite recursion to make the query evaluation optimized?

Answer Question   |  October 2, 2010  6:52 AM
Query optimization, Recursion, SQL Query, SQL query optimization, SQL Server 2000

Translate Ruby Script to SQL Query?
I need help translating a ruby script to SQL query. I’m a SQL noob. Help please. [em]here is the script.[/em] require “rubygems” require “ruport” SQL = <<-EOS SELECT     tv.ApptDate, tv.PatName, tv.PatFirst, tv.PatLast, tv.Phone, tv.ApptTime, tv.Provlast, tv.ProvFirst, tv.ProvTitle, tv.Clinic, tv.Age, tv.Notes FROM (  /* SECOND LEVEL, this brings out cliniccode from the main query so we [...]

Answer Question   |  September 22, 2010  2:19 PM
Ruby, SQL Query, SQL Query Parse Data, Sql Script, SQL Server 2000

How to implement crosstab query in Access?
How to implement crosstab query

Answer Question   |  September 23, 2010  4:24 AM
Access, CrossTab Query, SQL Server, SQL Server 2000

Trouble installing SQL Server 2005
I have installed SQL2005 as default instance on a server that already has 2000 as the default. how can I remove sql2005 safely and reinstall 2005 as a named server.

Answer Question   |  September 9, 2010  8:06 PM
SQL 2000, SQL 2000 to 2005 Migration, SQL 2005, SQL Installation, SQL Server, SQL Server 2000, SQL Server 2005, SQL Server 2005 administration

Can I restore a SQL 2000 backup to a new SQL Server 2005?
Can I restore a SQL 2000 backup to my new SQL Server 2005? Will I have to perform any other steps or can I do a simple backup and restore? Windows 2008 Server.

Answer Question   |  September 8, 2010  8:32 PM
SQL 2000, SQL migration, SQL Server, SQL Server 2000, SQL Server 2005, SQL Server backup, SQL Server migration, Windows Server 2008

SQL Insert Error Against Runtime Control Error in FLP
am trying to insert into sql-2000 database my code is: StringBuilder sb=null; sb=new StringBuilders; sb.Append("Insert into dummy(name,amount) values"); foreach(Control ctl in this.FlowLayoutPanel1.Controls) { if( ctls.Name.Contains("tb") && ctl is TextBox) { sb.Append(ctl.Text); } } foreach(Control bbl in this.FlowLayoutPanel1.Controls) { if (bbl.Name.Contians("bb") && bb is TextBoxe) { sb.Append(bbl.Text); } } SqlCommand cmd=new SqlCommand(sb.ToString(),con); cmd.CommandType=CommandType.Text; cmd.ExecuteNoneQuery(); I don’t [...]

Answer Question   |  September 3, 2010  6:55 AM
C#, SQL 2000, SQL error messages, SQL Server, SQL Server 2000

Upgrading SQL Server 2000/2005 to 2008 with VMWare and EMC SANs
Has anyone ever seen a White Paper on the best way to utilize features of both VMWare and EMC Symmetrix based SANs in a real-time or rapid batch based upgrade from SQL Server 2000/2005 to SQL Server 2008 with minimal downtime for application availability?

Answer Question   |  August 27, 2010  4:47 PM
EMC SAN, EMC Symmetrix, EMC Symmetrix DMX-4, SAN, SQL Server 2000, SQL Server 2000 to SQL Server 2005 upgrade, SQL Server 2005, SQL Server 2005 upgrade, SQL Server 2008, SQL Server Upgrade, Symmetrix, VMware, Windows Server 2008

What is a linear recursive query in SQL?
What is a linear recursive query in SQL?give me an example.Is there any nonlinear recursive query??

Answer Question   |  August 24, 2010  5:28 PM
SQL Query, SQL Server 2000, SQL Server 2000 queries, SQL Server Query

What are the query optimization techniques used in SQL 2000?
What are the query optimization techniques used in SQL?

Answer Question   |  August 28, 2010  5:22 PM
SQL Server 2000, SQL Server 2000 queries, SQL Server Query, SQL Server query optimization

Creating Alert/Email when Automatic Failover Occurs In Sql-Server 2005 and 2000
HI]] I want to send email alert when aotomatic failover occurs in in Sql-Server 2005/2000.  Specs: Active/Active  NO DR solutions

Answer Question   |  August 3, 2010  8:07 PM
Automatic failover, SQL Server, SQL Server 2000, SQL Server 2005

SQL Recovery from MDF and LDF – Missing Data
Where to start … On 6/2 we lost a major system that we found relies on a database that hasn’t been backed up since 5/7. We lost 3 of 4 HDD in a RAID5 array. We sent the drives to a recovery firm and they have recovered all of the data. However, the timestamp on [...]

Answer Question   |  October 5, 2011  2:10 PM
LDF, MDF, SQL 2000, SQL Server 2000, SQL Server backup, SQL Server backup and restore

Virtualizing SQL
Is it possible to run SQL Server 2000 on a VM on a workstation? If so, anything special to consider?

Answer Question   |  May 29, 2010  2:05 AM
SQL Server 2000, Virtualization, Virtualization in 2010, VM Workstation

What is the process to upgrade a database from SQL Server 2000 to SQL Server 2008 R2?
What is the process to upgrade a database from 2000 to 2008?

Answer Question   |  May 7, 2010  8:15 PM
SQL Server 2000, SQL Server 2000 to SQL Server 2008 R2, SQL Server 2008 R2, SQL Server Upgrade

Data type : GMToffset in SQL Server 2000
how this data type GMToffset will work.?? can you please help me in that where the offset is a feild in the table & GMToffset is its data type exist in sql server 2000 or it is derived ?? why we use GMT instead of local time?? Is this data type x

Answer Question   |  April 28, 2010  12:41 PM
SQL Server 2000, SQL Server 2000 administration, sql server 2000 datetime data type

SQL Server user name issue
We have a server in which Windows 2003 is installed and we have created users in the domain (e.g. – aaa). The server is installed with SQL Server 2000 and data is stored in the database. The user name for the server is “administrator.” When we login from the user computer with the same name [...]

Answer Question   |  April 9, 2010  3:38 PM
SQL Server 2000, SQL Server database, SQL Server User Accounts

View a concise list of all Job Schedules SQL Server 2000
I have an Optimisation job on my SQL platform (2000), which continually fails. I suspect the cause in that this job overlaps another, but without going through each job and checking the schedules I can’t be sure. The number jobs I have makes this an onerous task. Is there a way to query the database [...]

Answer Question   |  April 8, 2010  11:35 AM
SQL job scheduler, SQL Server 2000

attach a new mdf and ldf files in sql server 2005 enterprise
i have a new mdf and ldf file created in sql server 2000.how could i attach these to sql server 2005 enterprise edition?i tried it by right click the database and select attach.but it shows an error when click the add button in database dialogue box.

Answer Question   |  March 26, 2010  6:45 PM
LDF, MDF, SQL Server 2000, SQL Server 2005, SQL Server 2005 Enterprise Edition