Planning to move data on new databse server?
Well i m working in MNC As a Network admin actually we have one server having data & application so both our application and database on same server & now we are facing some problem on it so we plan to seperate database server & application if any body has a plan or he/she know [...]

Answer Question   |  June 1, 2008  10:03 AM
Application Server, Database servers, SQL Server 2000

Encryption Form SQL Server 2000
I want to transfer data from one database to another database both the databases are on sqlserver 2000 i want to transfer the data in encrytion form how do i do it ….. Regards, Sahil

Answer Question   |  May 27, 2008  11:32 AM
Data transfer, Encryption, SQL Server 2000, SQL Server migration

How to restore a SQL Server 2000 database using a backup
Could you please educate us on how to restore a database using a backup? We have a Mambilla PR software (.NET application) and SQL Server 2000 back end. We run the backup before any major change to the database.

Answer Question   |  April 19, 2013  1:52 PM
Backup, Backup & recovery, SQL Server 2000, SQL Server backup and restore

OPEN .DTS WITH WRONG APPLICATION
JUST OPEN .DTS FILE OF THE SQL SERVER 2000 WITH NOTEPAD APPLICATION, AND THE .DTS LOGO HAS BEEN CHANGED TO NTOEPAD LOGO, IS IT POSSIBLE TO CHANGE BACK TO .DTS LOGO? THANKS.

Answer Question   |  May 20, 2008  8:37 AM
SQL Server 2000

Read Only access to a SQL Database? Best way?
We’re trying to prevent hacks on our site. We’ve been down several times and the idea came up that we could prevent the SQL Injections by making an account for just the public-facing side of the site that has Read Only set for it. This is a Microsoft SQL 2000 server BTW. Our hosting company [...]

Answer Question   |  May 18, 2008  12:12 AM
SQL injection, SQL Server 2000, SQL Server security

Replication Logreader error. SQL Server 2000
Hi I am using SQL Server 2000 replication , I have separate publisher,distributor and subscriber servers running on SANs. I get below error and synchronization gets struck, becuase log reader could not read data from the publisher db. Could you give me a quick fix for this error. ——————————–Extract of the error————————————– The specified begin [...]

Answer Question   |  September 20, 2008  2:29 PM
SQL Server 2000, SQL Server replication

Is the data in a SQL Server 2000 table still available for external applications, during editing or adding indexes via the Enterprise Manager?
Is the data in a SQL Server 2000 table still available for external applications, during editing or adding indexes via the Enterprise Manager?

Answer Question   |  May 14, 2008  3:24 AM
Data availability, Enterprise Manager, Indexes, SQL Server 2000, SQL Server Enterprise Manager

row_number in sql 2000
how to find out the row_number in sql 2000 like using row_number() function in sql 2005

Answer Question   |  March 11, 2010  10:51 PM
ROW_NUMBER, SQL Query, SQL Server 2000

How to Schedule jobs in DTS in sql server 2000
I have got 7 jobs in my sql server server agent, now i want them to run simultaniously one afer the other using DTS, is it possible,if yes how can i do it

Answer Question   |  May 7, 2008  5:14 AM
DTS, SQL Server 2000, SQL Server Agent

DB size
Hi, I am using a software which is using SQL DB. Each time there is an error (one of the tasks fails) the DB grows. I would say over 1G per day! Currently I have DBs which are 45G and I am running out of space. Anyone has any idea how to shrink the DBs [...]

Answer Question   |  May 5, 2008  3:30 PM
SQL Server 2000, SQL Server logs, SQL Server performance tuning

Suspect DB
Hi, I am using sql server 2000 and recently found 2 of the DBs are marked as Suspect and I don’t have access to them any more.Would you please help me with this? Thanks, Ellie

Answer Question   |  May 15, 2008  3:24 PM
SQL Server 2000, SQL Server security, Suspect database

Can’t Install SQL Server 2000 on Window XP SP2
I try to install SQL Server 2000 on Window XP SP2, but there is an error message mean “OS not support.”. What should I do? How can I install SQL Server 2000 on Window XP SP2? Please, give me the best and detail answer. Thanks.

Answer Question   |  May 2, 2008  4:29 AM
SQL Server 2000, SQL Server errors, Windows XP

update query fails as table gets locked by select query (sql blocking issue).
I have a perl script which updates some table records in sqlserver 2000, the flow is like below: * A select query This select query selects IDs(with other records too) * An update query This update query updates a bit column from 0 to 1 for the IDs retrieved from above select query. The problem [...]

Answer Question   |  May 2, 2008  9:32 PM
Perl, SQL Server 2000

DTS schedule package
How can I see the scheduled run time of an existing DTS package?

Answer Question   |  May 1, 2008  7:09 PM
Data Transformation Services, DTS, Schedule Performance Index (SPI), SQL Server 2000

Looking for best approach to upgrade SQL Server 2000 databases to SQL Server 2005
I will be upgrading a number of SQL Server 2000 databases to SQL Server 2005 and was wondering what database objects I have to worry about? I believe to run Data Transformation Services (DTS)in 2005, I will have to have legacy installed. Is that correct? Other than that, should there be any problems with stored [...]

Answer Question   |  May 2, 2008  5:51 PM
DTS, SQL Server 2000, SQL Server 2005, SQL Server upgrades

Mobile phone notifications
Hi How to setup mobile notifications on jobs using SQL Server 2000. Aim is when a job fails I should receive SMS notification on my mobile phone. Please show me web sites on this topic. Please help. Thanks & Regards -Rajesh.

Answer Question   |  May 2, 2008  11:37 AM
SQL Server 2000, SQL Server alerts

full-text replication SQL Server 2000
I’m having problems replicating a table that has full-text enabled using sql server 2000 sp4. When I start the distribution agent I get the following error: Cannot use a CONTAINS or FREETEXT predicate on table ‘dbo.proposals’ because it is not full-text indexed. I have run sp_fulltext_database ‘enable’ on the subscriber. What do I need to [...]

Answer Question   |  April 22, 2008  6:14 PM
Full-text databases, SQL Server 2000, SQL Server replication

How to work with Visual Basics 6.0 and SQL Server 2000
I am designing a system with Visual Basics 6.0 as the user interface and SQL Server 2000 as the backend. How can I add data to the database through Visual Basics? How about deleting data in the tables?

Answer Question   |  February 11, 2012  1:17 PM
SQL Server 2000, SQL Server integration/interoperability, VB, Visual Basic

Looking to resolve SQL Server performance problems caused by using many temporary tables
I need your advice on the SQL Server performance tuning. The Problem: We use a lot of temporary tables in our application, which is causing a lot of SQL Server performance problems. I read about the following solution on some site. “RamDisk presents a powerful solution to this problem by providing up to 63 GB [...]

Answer Question   |  April 14, 2008  2:23 AM
Disk storage, SQL Server 2000, SQL Server performance tuning

How to set up a threshold on a SQL Server 2000 Agent backup job?
I would like advice on setting up a threshold if a SQL Server 2000 Agent backup job (nightly) is running after a certain time (7 a.m. PST), I would like to cancel it.

Answer Question   |  April 4, 2008  2:03 PM
SQL Server 2000, SQL Server Agent, SQL Server backup