SQL Server 2000

Error when updating SQL Server 2000 from SQL Server 2005

Hi, I am using sqlServer 2005 and sqlServer 2000. When i update on sqlServer2000 from sqlServer2005 then following error was occured. Msg 682, Level 22, State 148, Line 1 Internal error. Buffer provided to read column value is too small. Run DBCC CHECKDB to check for any corruption.

Error message from SQL Server 2000 Agent after antivirus installation

SQL Server 2000 Agent would not start after the installation of the antivirus software Sophos and a reboot. I found the messaging service was shut off, so I started it, rebooted and the agent came up running. I then tried to start a backup job, but I received “error 14258,” which stated that...

Consolidating SQL Server databases

How I can consolidate seven SQL Server 2000 and SQL Server 2005 databases to only SQL Server 2005 databases? Both servers are HP and Dell servers.

SQL Server 2000 script

Hi , How can we use SQL 2000 script to call 2nd maximum date? case : Item A has few price with different effective_date, Ihow can i call an item's price with second max(effective_date). Thanks in advance.

Migrating data from Microsoft Access to SQL Server 2000

I want to transfer data from access to sql table and vice versa through windows service. so, plz help me.

EMC Network Backup Client/Agent backup for SQL 2000/2005 databases on Polyserve Matrix

Hi, I am new with running SQL 2000/2005 instances on Polyserve Matrix servers. We use EMC Network as a corporate backup strategy. Can someone tell me will there be any problems using this backup tool for SQL instances on the Polyserve Matrix?

Transform Data task properties not opening.

In my analysis manager, data transformation packages, i open a package and try to open the properties of Transform Data task. Whenever i am trying to open the properties the analysis managergot hungs.l The properties not opening. I am using MS SQL server 2000.

Trouble with SQL Server 2005 Upgrade Advisor when trying to detect an instance

I installed the SQL Server 2005 Upgrade Advisor so I can analyze our SQL Server 2000 instance and DTS packages. Even though SQL Server 2000 is up and running, it does not recognize our instance when going to the pull-down menu, nor does it recognize it when I key in the instance name. We are...

Best encryption method for SQL Server 2000

What is a good encryption method to use in SQL Server 2000 if your database is accessed by two different languages, PHP and ASP?

SQL Server 2005 Upgrade Advisor in a cluster/SAN environment

I installed the SQL Server 2005 Upgrade Advisor so I can analyze our SQL Server 2000 instance and DTS packages. Even though SQL Server 2000 is up and running, it does not recognize our instance when I go to the pull-down, nor does it recognize it when I key in the instance name. We are running on...

Password Policy for SQL Server 2000

Is there any way to set Password expiration Policies on SQL Standard Users in SQL 2000?

SQL Server 2000 Drive selection

I have a software package (Pinnacle Studio 10) that installed a SQL Server 2000 database. When I first loaded the SQL software on the C drive it created a database on the D drive. I now need to create a database (or move the database) to a new H drive. How can I do this? Can I change the swap...

Need help...My Sql server 2000 has error

My Sql server 2000 has error when created a new database or create a new table in my database. There is the error : "[Microsoft SQL-DMO(ADBC SQLState : 42000)] - Cannot use empty object or column names. Use a single space if necessary" I think my SQL server 2000 was created a no name database, but...

Moving a database from SQL Server 2000 to SQL Server 2005 and back again

I moved my database from SQL Server 2000 to SQL Server 2005, but now, if possible, I'd like to move it back. When I open SQL Server Management Studio 2005 and check my database's properties, its compatibility is "SQL Server 2000(8.0)". Can I move my database back to SQL Server 2000, and if so, how?

Backing up and upgrading a SQL Server 2000 database

We have a database of around 3GB on SQL Server 2000 Standard Edition. What is the quickest way to backup the database at minimal cost, and how much time would it take to upgrade this database to SQL Server 2005?

SQL Server 2000 DTS Designer components are required to edit DTS packages Error even after installing sqlserver2005_dts.msi

Hi, I am new to Database Technology and was asked to upgrade from MS SQL Server 2000 to 2005. I followed the procedure regarding the upgration found in one of the posts.THe Upgrade advisor says "SQL Server 2000 DTS Designer components are required to edit DTS packages" and In how to resolve this...

Executing DTSX from VB.NET 2003

We converted form SqlServer 2000 to 2005. We had dts packages which were used to import Excel data into the database. We re-created new dtsx packages to replace the old dts packages where they sit on a local drive. Our VB.NET 2003 application used to be able to run the old dts packages but we...

Configuring a password message prompt on SQL Server 2000

On SQL Server 2000, how can I make it so that the server will prompt me for a password when I am click on my database through Enterprise Manager?

Installing SQL Server 2000 Enterprise Edition on Windows XP

When I try to install SQL Server 2000 Enterprise Edition on Windows XP Professional Edition, it is giving me an error message that says my operating system is not supported. How can I install SQL Server 2000 Enterprise Edition on Windows XP Professional Edition?

Email notifications in SQL Server 2000 Enterprise Edition

In regards to email notifications in SQL Server 2000 Enterprise Edition, what level of authority does the SQL Server Agent account need in order to email me that a critical job has died?