SQL Server 2000

Attaching a SQL Server 2005 database to SQL Server 2000

How can i attach a database created in SQL Server 2005 to SQL Server 2000?

Storing and retrieving an image in SQL Server 2000

How do I store and retrieve an image in SQL Server 2000, using Visual Basic 6.0 on the front end?

Possible to deploy 2005 report to sql 2000 RS?

I've never needed to do this before, but I need to know if I can deploy a report built with VS 2005 to a SQL 2000 Reporting Services box. I don't have an environment at the moment to test it on. Does anyone know if this is possible? Thank you in advance, tley

SQL 2000 db transactions/sec

What number of SQL 2000 database transactions/sec would be of concern on a system? Windows Server 2003, 4GB RAM, 2CPU (dual core). Thanks for the guidance.

Linked server problems

I have 2 servers Server 1 has sql 2000 (SP2) Server 2 has SQl 2000 + SQL 2005 (sp2) Im trying to create a linked server on Server 1 to Server 2 SQL 2005 I can get SQL 2005 linked into SQL 2000 on server 2 itself but when i got to Server 1 and try to create alinked server to SQl 2005 i get...

What are basic differences between SQL Server 2000 and 2005?

What are basic differences between SQL Server 2000 and 2005?

How to restore SQL Server 2000 backup file

how to restore sql 2000 backup file

How to compare fingerprint images in VB.NET

i am working on FINGERPRINT RECOGNITION SYSTEM, i am using vb.net as front end and sql server 2000 as back end, i had saved fingerprint images in sql server using image datatype, now i need suggestion how to compare fingerprint images.

Slowdown in SQL Restore on SQL Server 2000

We are running SQL Server 2000 on Windows 2000 Server SP4, and our SQL Restore takes at least 10 minutes to launch in Enterprise Manager. We had to roll back after an upgrade, and we find that when selecting "Restore Database", Enterprise Manager runs remarkably slow. I'm sure we could run the...

Job permissions in SQL Server Agent

Hi, I'm using SQL Server Agent which is running on SQL Server 2000. My question is, is there a way to give permissions to users to simply view the jobs and not change/execute them? I've read that this is possible in SQL 2005 with SQLAgentReaderRole, but what about 2000? Thanks in advance.

Shrinking a SQL Server database

My problem is regarding SQL Server 2000. Whenever I try to access SQL Server Enterprise Manager, I am told that the disk is full, along with the tempdb log. I tried to shrink the database, but for some reason I am not able to do so. Can you help me?

SQL Server 2000 error message involving ASP

We are getting a scripting engine exception on the ASP page, but it is actually updating the data to SQL Server 2000. Could the error be due to a SQL Server connection problem?

Crystal Reports 10

How To get first record means last entry record of a from crystal report 10

What are basic differences between SQL Server 2000 and 2005

What is the Basic difference between SQL 2000 and 2005, thanks

SQL Server Agent job Failures

I would like to know if there is any way to get Agent jobs such as backups, Update Stats jobs to write to the error log on failure. I have written a monitoring program that looks in the errorlog and alerts on pertinent errors. I would like to be able to use this solution for agent job failures...

SQL Server 2000 performance issues

Running SQL Server 2000, SP4 on Windows Server 2003 R2. 4GB RAM; 3GHz dual-processor, dual-core. The databases and logs are on an ISCSI SAN. This is the original implementation design. Since the beginning the users have said the system does not perform as well as they would like. The database...

VB.NET app cannot login to SQL Server 2005 after upgrade from SQL Server 2000

I have a VB.Net application which connects to an SQL2000 database and I recently upgraded to SQL2005 and after the upgrade my app does not want to connect to SQL2005 using the same password I used to connect to SQL2000. if I change the login password to all uppercase characters in SQL2005...

SQL Server security bulletin MS09-004

Has anyone dealt with issues related to this security bulletin ?

Can you replicate SQL 2003/8 to SQL 2000

I am upgrading a server running SBS w/SQL2000. New server will be 2003 or 2008. Would like to use old server for backup off site. Can I replicate, or would I need a new 2003/2008 license to accomplish this?

Copying view from remote to local SQL Server with SSMS

Hi I'm currently trying to get to grips with an upgrade from sql server 2000 to 2008, forced by an upgrade at my ISP. I'm used to using Enterprise Manager to export data from my ISP to my local machine for backup, and this process copying tables as tables, views as views and so on. But using...