How to restore SQL Server 2000 backup file
how to restore sql 2000 backup file

Answer Question   |  March 2, 2009  5:58 AM
SQL Server 2000, SQL Server 2000 backup, SQL Server backup

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.

Answer Question   |  April 2, 2010  7:36 PM
.NET development, Authentication, Biometric authentication, Biometrics, Fingerprint authentication, Fingerprint scanning, SQL Server 2000, VB.NET, Visual Basic .NET

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 restore through a [...]

Answer Question   |  February 27, 2009  4:34 PM
Enterprise Manager, SQL Enterprise Manager, SQL Restore, SQL Server 2000, SQL Server performance

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.

Answer Question   |  February 26, 2009  3:50 AM
SQL Server 2000, SQL Server Agent, SQL Server Agent job permissions, SQL Server user permissions, SQLAgentReaderRole

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?

Answer Question   |  February 25, 2009  8:48 PM
SQL Server 2000, SQL Server Database Shrinking, SQL Server databases, SQL Server Enterprise Manager

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?

Answer Question   |  February 25, 2009  8:46 PM
ASP, SQL Server 2000, SQL Server error messages, SQL Server errors

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

Answer Question   |  February 24, 2009  7:00 AM
Crystal Reports, Crystal Reports 10, SQL Server 2000

What are basic differences between SQL Server 2000 and 2005
What is the Basic difference between SQL 2000 and 2005, thanks

Answer Question   |  February 23, 2009  11:35 AM
SQL Server 2000, SQL Server 2000 migration, SQL Server 2005

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 [...]

Answer Question   |  February 13, 2009  7:33 PM
SQL Server 2000, SQL Server 2005, SQL Server 2008, SQL Server Agent, SQL Server Agent Jobs

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 application is a manufacturing information [...]

Answer Question   |  February 16, 2009  7:05 PM
iSCSI, perfmon, SAN, SQL Server 2000, SQL Server performance, SQL Server performance tuning

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 Management Studio my [...]

Answer Question   |  February 13, 2009  10:22 AM
SQL Server 2000, SQL Server 2000 migration, SQL Server 2005, SQL Server connectivity, VB.NET, Visual Basic, Visual Basic .NET

SQL Server security bulletin MS09-004
Has anyone dealt with issues related to this security bulletin ?

Answer Question   |  February 12, 2009  5:32 PM
SQL Server 2000, SQL Server query optimization, SQL Server security, SQL Server security bulletin MS09-004, SQL Server Security Bulletins

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?

Answer Question   |  February 12, 2009  1:40 PM
SBS, SQL Server 2000, SQL Server 2003, SQL Server 2008, SQL Server replication

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. [...]

Answer Question   |  February 10, 2009  2:52 PM
SQL Server 2000, SQL Server 2000 migration, SQL Server 2008, SQL Server 2008 administration, SQL Server Enterprise Manager, SQL Server Management Studio, SQL Server Management Studio 2008, SQL Server migration, SQL Server views, SSMS 2008

Why and how to performance tune SQL Server 2005
Why do you have to tune SQL Server 2005 for performance, how do you go about tuning it, and, for tuning purposes, which is better – SQL Server 2000 or SQL Server 2005?

Answer Question   |  February 4, 2009  6:30 PM
SQL Server 2000, SQL Server 2005, SQL Server performance tuning

How to make installer of VB.NET including SQL Server 2000?
I had done my project in vb.net with sql server 2000 but it’s installer doesn’t work properly as it displays the message unexcepted error while connecting to the database.I know setup and deployment in vb.net but doesn’t working please help me.I am stuck in here.thanks in advance.

Answer Question   |  February 10, 2009  11:32 AM
Database connectivity, Setup and deployment, SQL Server 2000, VB Setup File, VB.NET, Visual Basic, Visual Basic .NET

Scheduling a Shrink Database in SQL Server 2000
Is there a way to schedule a shrink database after the transaction log has been backed up for a database via the maintenance plan?

Answer Question   |  February 3, 2009  4:41 PM
SQL Server 2000, SQL Server backup, SQL Server Shrink Database, SQL Server transaction logs

Migrating data from a SQL Server 2005 database to SQL Server 2000
I am looking for advice on what technology to use to migrate data from a SQL Server 2005 database to SQL Server 2000. We are currently phasing out our old help desk ticketing system in SQL Server 2005 to a new ticketing system in SQL Server 2000. The tables in the databases are not identical [...]

Answer Question   |  January 27, 2009  7:52 PM
SQL Server 2000, SQL Server 2000 to SQL Server 2005 migration, SQL Server 2005, SQL Server Database Migration, SQL Server migration

Shortening the generation time for a SQL Server 2000 report
I have 516 different functions in SQL Server 2000 that are used for different calculations. These functions will operate on more than a thousand Microsoft Excel files. Each Excel file has 960 rows, and generating the report took over four hours. Is there a way to shorten this?

Answer Question   |  January 27, 2009  7:43 PM
Microsoft Excel, SQL Server 2000, SQL Server performance, SQL Server Reports

Different SQL Versions on the same server.
I was hoping someone could tell me if its ok to install SQL2008 Standard for use with company accounting and billing applications and also install SQL2008 Express for use with Sharepoint 3.0 on the same server. I could put the versions of SQL on different volumes if that helps. The load Sharepoint puts on the [...]

Answer Question   |  January 25, 2009  3:15 PM
Multiple SQL Server Installations, SQL Server 2000, SQL Server 2000 Standard Edition, SQL Server 2008