Problem about install SQL2000 over Win2003Ser SP2

Hi, I am the newbie about SQL server. I am facing a problem about install SQL2000 standard server over Windows2003 SP2 standard server. While I clicked the setup.exe, it prompted me the following message: SQL Server 2000 SP2 and below is not ...

Message posted on the March 16th, 2010 - 1:27 AM ET

Hi, I am the newbie about SQL server. I am facing a problem about install SQL2000 standard server over Windows2003 SP2 standard server. While I clicked the setup.exe, it prompted me the following message: SQL Server 2000 SP2 and below is not ...

Message posted on the March 16th, 2010 - 1:27 AM ET

Problem with MS DTC on SQL2008 win server 2k8 with linked server from sql2000 wi

Hi, We have migrated our db from sql2000 win server 2k to sql2008 win server 2k8. We have linked server from sql2000 win server 2k. By our opinion the problem is with DTC and we have made a lot of setting that we found as solution for our problem, ...

Message posted on the January 13th, 2010 - 4:37 PM ET

SQL2000 & SQL2005 on same machine

I have an instance of SQL2005 (named ROYAL-FIN-SVR1) running on Windows Server 2003. I recently installed an instance of SQL2000 (named ROYAL-FIN-SVR1MLSQ2000) on the same server. I am having a problem registering the SQL2000 on a client on another ...

Message posted on the June 13th, 2009 - 11:51 AM ET

Trace problems in sql2000

I have user application written in microsoft access - which is used only as user interface. All data are stored in SQL2000. Application is connected to sql2000 server through ODBC (SQL server driver) and executes stored procedures or some individual ...

Message posted on the February 26th, 2009 - 3:08 AM ET

SQL2008 > SQL2000

Hi Folks, Appologies if this is in the wrong group but I am at a client site and need to create a database which will be used on SQL2000, only problem is that they have lost the disk for the developer version of enterprise manager and as yet I ...

Message posted on the March 30th, 2010 - 5:02 AM ET

Logshipping from SQL2000

Hello, I have ServerA which is SQL2000 Enterprise Edition(latest sp) and ServerB which is SQL2008 Developer edition(latest sp). Can I set up Log Shipping from ServerA to ServerB? tia, AbbA

Message posted on the March 1st, 2010 - 1:31 AM ET

Migration SQL2000-2005 Performanceleak

Hi All, when migrating from SQL2000 to SQL2005 we have a massive performanceleak with a view used to fill a cube. The View needs nearly 1 hour in SQL2000 and (unchanged) in SQL2005: 4-1/2 hours ! We try to optimize the view searching for ...

Message posted on the August 5th, 2009 - 4:50 AM ET

Upgrading from SQL2000

Hello, I am assigned with a project to strategically study and make recommendations to upgarde our major PROD database from SQL2000 EE. Iam told that the requirement is to upgrade the db from SQL2000 but I need to study the ROI, do presentations ...

Message posted on the March 19th, 2009 - 5:12 AM ET

SQL2000 on Win2008

Hello, Can SQL2000 be installed on Win2008? I checked the official documentation and it is not supported. So my question is not whether it is 'supported' but if it can be 'installed'? Thanks in adv!, AbbA

Message posted on the November 2nd, 2009 - 5:18 AM ET

Is it possible to protect SQL2000 db so that the admin does not access

Is it possible to protect SQL2000 db so that only single user id can access and not even ADMin is able to access with trusted connections true.

Message posted on the October 2nd, 2009 - 12:54 AM ET

SQL2000 & SQL2008

Hello, Any issues in having a SQL2000 default instance and a SQL2008 Named Instance? Anything to watch out for? TIA, AbbA

Message posted on the June 23rd, 2009 - 12:17 AM ET

defrag the disk on sql2000 server

Hi, I found one sql2000 server disk need to do defragment. Would this process will bring the database down? I think I need to do this while sql server is down. Thanks Sarah

Message posted on the May 27th, 2009 - 11:23 PM ET

from sql2000 to sql2008

hi all i have a code to compare the password for the users its Works fine in sql2000 but when i try in sql2008 dos not Works any help pls select * from master.dbo.sysxlogins where srvid IS NULL and name = '"+rTRIM(lUserName)+"' and ( ( ...

Message posted on the March 10th, 2009 - 5:39 AM ET