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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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. 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
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
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