Database Recreate
My SQL server 2000 Database is corrupted because of a virus infection. No tables are showing now. My database folder contains .mdf, .ldf and file (3 files) can I retrieve my tables using one of this. Any solution please? I don’t have any other backups. Please get a solution.

Answer Question   |  July 12, 2012  11:42 AM
SQL Server 2000, SQL Server database

unable to connect sql server 2000 on network
We have sql server 2000 instance on a machine say “comp1″.The problem is when i need to connect to it via another computer on LAN using SSMS it is unable to connect but when i connect to the “comp1″ via run and give password then i am able to connect through SSMS Can someone give [...]

Answer Question   |  April 11, 2012  1:19 PM
SQL Server 2000, SSMS

Use of database backup from lower version to higher version of sqlserver
I am using sqlserver 2000, have a database of 2GB. I want to shift at higher version 2008. What I have to do TO upload my Old version-2000 database backup  into  sqlserver 2008

Answer Question   |  March 31, 2012  6:18 AM
SQL Server 2000, SQL Server 2008, SQL Server database

View in SQL 2000
How to create view with parameter? Thanks and regards.

Answer Question   |  June 22, 2011  9:12 AM
SQL 2000, SQL Parameters, SQL Server, SQL Server 2000, SQL View

Building new SQL server
had a sql server (2000 I think) built on enterprise 2003 die. Got new hardware and am beginning the guessing game. any good reference articles, step by step of how to build new and restore backups from external hd. Old server won’t even boot.

Answer Question   |  June 15, 2011  12:56 PM
Backup, SQL Server, SQL Server 2000, SQL Server 2000 SP4, SQL Server backup and restore

SQL Server Logins
Hi Currently using SQL server 2000 Is there a way of making SQL server logins use case sensitive passwords. for example    user = SA password = PassWord123 as it stands “SA” can login with password = password123 how can can i change it so the user cannot login with different case password. I have read about [...]

Answer Question   |  January 15, 2012  10:09 AM
SQL 2000, SQL Logins, SQL Server 2000, SQL Server Password Management, SQL Server Passwords

Create linked server from sql 2000 to sql 2005
Does anyone knows how to create a linked server in Sql 2000 regarding a database to Sql 2005. All I want to do is a selection from a table in sql 2005 and insert into a table in Sql 2000   Thanks in Advance

Answer Question   |  March 27, 2011  7:41 AM
SQL Server 2000, SQL Server 2000 migration, SQL Server 2005, SQL Server migration

SQL Server 2005 database conversion
HI, we plan to migrate SQL server 2005 from SQL server 2000. we have database with average size of 12GB. can any one please let me know how to convert our database from SQL2000 to SQL2005.Thanks in advance.

Answer Question   |  March 2, 2011  11:34 AM
SQL database conversion, SQL Server 2000, SQL Server 2005, SQL Server 2005 migration, SQL Server migration

SQL 2000 database recovery
Hi, weve had an issue with a raid array meaning our sql 2000 cluster wont start. Weve recovered data to another server using backups, however were missing that days data as the backups hadnt started for that day and we have no tran log backups between those times. I have the original mdf and ldf [...]

Answer Question   |  September 29, 2011  1:48 PM
SQL 2000, SQL 2000 recovery, SQL Database, SQL Server 2000, SQL Server 2000 Database

Search: Error with SQL : Login failed for ‘SA’.
I’m using a softawre written in VB(.net). It runs normal on XP and 2003 server. it supports both Access and SQL 2000 and 2005. but I recently upgraded my OS to Win7+SQL 2008, and I’ve been having the following error anytime a call for a screen in the software”Search: Error with SQL : Login failed [...]

Answer Question   |  June 28, 2011  11:53 PM
SQL Server 2000, SQL Server 2005, VB.NET, Visual Basic, Windows Server 2003

Resolving all losing conflicts-Merge Replication in SQL Server 2005 and 2000
The application I support uses SQL Server 2005 as the publisher and SQL Server 2000 at the subscriber. One of our clients went nuts trying to prune his database and deleted a year and a half of sales data. Unfortunately I did not have a backup, but I did have an old copy of the [...]

Answer Question   |  February 2, 2011  5:34 PM
SQL Server 2000, SQL Server 2005, Windows Server 2003 R2, Windows XP

SQL 2000 view debug help
I have the following (admittedly convoluted) view that I cannot get right for some reason that I cannot see. Consider the following: SELECT     s.s_SAMPLEID AS LimsSampleId, s.U_CLIENT_SAM_NO AS ADASampleId, MAX(s.SAMPLEDESC) AS SampleDescription,                       MAX(CASE d.paramlistid WHEN i.paramid THEN d.paramlistid WHEN ’1.Purity I’ THEN pm.paramdesc WHEN ’2.Purity Analysis’ THEN ‘Purity Analysis’ WHEN                        ’5.Germination’ THEN pm.paramdesc [...]

Answer Question   |  February 1, 2011  6:23 PM
SQL 2000, SQL Server 2000, SQL Server 2000 administration, SQL Server 2000 queries

SQL Server 2000 Log Shipping
Hi I have an issue with my logship server (SQL 2000). I logship every 10 mins from production to backup server, all has been working fine, until today when a network issue caused a logfile which i use to restore was corrupted. I need to make the Logship DB Live to retrieve some data I run  “RESTORE [...]

Answer Question   |  January 19, 2011  10:41 AM
Log Shipping, Log Shipping failure, SQL 2000, SQL Server 2000, SQL Server 2000 Log Shipping

Best tool for SQL Server 2000 – like golden is for oracle
what db tools are there to query ms sqlserver 2000 database? i’m used to using benthic’s golden for oracle databases – and would like a similar tool to use with sqlserver databases.

Answer Question   |  January 10, 2011  10:08 PM
SQL 2000, SQL Database, SQL Server 2000, SQL Server database

Migrating stored procedures from SQL Server 2000 to 2005
after migrating store procedures from 2000 to 2005 sql server, how we can check the store procedures are migrated correctly without executing them?

Answer Question   |  January 3, 2011  4:06 PM
SQL Server 2000, SQL Server 2000 migration, SQL Server 2005, SQL Server migration, SQL Server stored procedures

How can I use SQL codes in delphy7?
I am going to use the sql code below in a query in delphy7 SELECT     left(edit1.text, 5)+’0 ‘ FROM        edit.text2

Answer Question   |  December 13, 2010  10:26 AM
SQL 2000, SQL Server 2000, SQL Server 2000 administration, SQL Server administration

Union operator in SQL server 2000
How to give where condition to the result of the query using Union operator?

Answer Question   |  November 23, 2010  7:27 AM
SQL Query, SQL Server, SQL Server 2000, SQL Server Query

How to write text into word doc using SQL 2000 query analyzer
how to write text into word doc using sql 2000 query analyzer. Thanks in advance.

Answer Question   |  November 19, 2010  7:02 AM
SQL 2000, SQL Query, SQL Query Analyzer, SQL Server 2000, SQL Server 2000 queries

How to write text into textfile using SQL 2000
can I use exec sp_OAMethod ‘c:osqloutput.txt’, ‘WriteLine’, Null, ‘hello’ to write something on file using sql2000

Answer Question   |  November 16, 2010  11:54 AM
SQL, SQL 2000, SQL Server 2000, textfile

Migrating SQL Server 2000 to SQL Server 2005
How can we migrate our sql server 2000 to sql server 2005 on another box? We have about 36 databases and it is around 65 terabytes of data on an external array. The array will be connected to the new server.

Answer Question   |  January 6, 2011  3:21 PM
Array, SQL Server 2000, SQL Server 2000 migration, SQL Server 2005, SQL Server migration, SQL Server Upgrade