SQL Server 2000

Acquiring remote access for SQL Server 2000 from a private server to a public server

How do I acquire remote access for SQL Server 2000 from a private server to a public server?

Install SQL Server Client Components on Windows XP

I use my SQL Server 2000 Developer Edition disk to install client components on my Windows XP. I insert the CD into the drive. I click SQL Server 2000 Components on the first screen. I click Install Database Server on the next screen. An InstallShield icon appears for a few seconds and then...

Memory could not be written

I keep getting the following error when I try to Close/Modify the DTS package or close the SQL 2000 (by x-out) on the remote workstation which has Windows XP OS. Application popup: mmc.exe - Application Error : The instruction at "0x4173d22a" referenced memory at "0x02241e90". The memory could...

Updating the database using information_schema

I am having database a and b i want to update database a according to updations in database b .b is same as a operations are done on b database and after complition a will get updated for permanent change? how can I do this automatically by using information_schema in sql server 2000

SQL Server 2000

How do I connect my AS/400 to a SQL Server 2000

Log shipping after upgrading to SQL Server 2005

I've upgraded our warm backup to SQL Server 2005 recently, but our log shipping is down. How can SQL Server 2005 be used with SQL Server 2000 log shipping?

SQL database backup

Am having 2 databases running on SQL SERVER 2000, OS(windows server 2003), so the backup for these databases are to suppose to run on monday, wednesday and friday 12:00 and 16:30 in the afternoons.So since last week the backups have been failing to run till today, and by checking the event viewer,...

Installing SQL Server 2000 on Windows XP Pro

How do you install SQL Server 2000 on Windows XP Professional?

Securing a SQL Server 2008 database

I am on SQL Server 2000, and to secure my database, I want the user to be prompted for a user ID and password before the database is expanded. How might I do this?

ABT database backup from SQL Server 2000

hi please tell me that, if i am using vb as front end and sql server 2000 as backend then for giving the facility of implicit periodical data backup at project, how can i go......through vb coding...

Database Oracle

hi please answer the question how to create database in oracle9 and link the database in sqlserver 2000 table in oracle and table in sql

SQL problem

Hi, Iam having two sql servers 2000 and 2005 are installed on the same server. When i run any application it is directily hitting the 2005 serve but i want the application to to hit sql 2000 server only and when i want to hit it to sql 2005 it should hit it means vice vers can some one...

Linked servers from SQL 2000 to SQL EXPRESS 2005

I wanted to create a linked server on SQL SERVER 2000 to SQL EXPRESS 2005.Both servers are on the same machine .SQL SERVER 2000 using username and password while SQL EXPRESS using integrated security.Thanks in advance.Any one let me know how to create this?

Strange Stored Procedure Behavior (Dev vs Prod)

I have a stored procedure that runs on my Production database in 0.394 seconds. However, when I try to run the SP on a DEV box it takes well over 15 minutes to run *every* time. I have checked indexes and everything seems to be identical (I did a backup/restore to the Dev box in the first...

SQL Backup File

I have two computers running sql server, sqlserver01 and sqlserver01. On sqlserver01 I backup the database locally to C:\SQLBackup\backupfile.bak (db size: 150GB) then I copy and paste the *.bak file to sqlserver02 via the network. It finishes copying but when I try to restore it on sqlserver02 it...

Run scheduled job on SQL Server

we do integrate SQL SERVER woth Oracle database, and its usually work withour problems. the last two days the intgration is not working and the following error displayed in the job history. Cannot create COM Server to load and execute DTS Package. Error -2147221008 (800401F0): CoInitialize has...

Connection of VB6 with SQL Server 2000

I want to connect VB6 application with SQL SErver database such that if anything is saved in VB6 forms it will be saved in the database tables of SQL Server.

Error message on a VB.NET created program on SQL Server 2000

I have developed an order management system program for my company, and I have 20 years using it. However, on a single system, I get an error that is either ‘time out expired’ or ‘max pool size’. I used VB.NET 2005 on SQL Server 2000 to create and use this program. When I restart the...

Error message while querying a linked server SQL database

We have two remote servers, both with SQL Server 2000 databases. An ODBC data source was setup on the first server to point to the SQL Server database on the second server. Also, a linked server was setup on the first server between the SQL Server databases on both server. It was based on the...

Updating Microsoft SQL Server tables from Oracle generates error

i am not able to update table in ms sql2000 from oracle . can u sugegstyour views on this . the error i got is ORA-00904: "NAME": invalid identifier.