• Disk Partitioning w/SQL Server 2000/2005/2008

    I recently read some information regarding aligning the Disk for use with SQL Server from Mr. Denny. My understanding is, SQL Server handles data in chunks of 64KB, so the disk drive SQL Server writes to containing data and log files should be configured to work in 64KB chunks. The articles I am...

    JohnMCouch5 pointsBadges:
  • Evicted Last Server from 2003 Cluster – Databases won’t start

    **First submit blanked out all the original content** Sorry Environment - Windows Server 2003 SP1, SQL Server 2000 .exe version 2000.080.0760.00 I am helping to remove the clustering and migrate all databases on the cluster to a single machine in the cluster. I was able to evict Server 1 from the...

    MaxxOC5 pointsBadges:
  • Source code for multiuser programming in VB 6 with SQL Server 2000

    hi to all, I'm developing a security software in Vb 6.0 with Sql Server 2000 as back end wherein 10 users will be there. I'm a newbie in multiuser programming. The question before me is that how to proceed further. My stand alone code is almost ready 50%. I'm using Ado for establishing connection...

    Isha5 pointsBadges:
  • SQL 2000 & Outlook 2000

    We have a couple of SQL 2K Servers which have a mailbox associated with them, have always used Outlook 2000 because anything newer does not work and today it has gone wrong!!! We are now getting a "Cannot open the mailbox, information store not available" we cannot get the server to work with email...

    Paulbeynon60 pointsBadges:
  • SQL Server 2000 Database Table Limit?

    Is there a limit to how many tables a single database can hold in SQL 2000?

    Xarly25 pointsBadges:
  • 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.

    Rebi97745 pointsBadges:
  • Export XML from SQL Server 2000

    We currently use a DTS package to extract data from the db and export it in an XLS file, or in some cases a TXT file. We now need to be able to export as an XML file. Since SQL Server 2000 DTS functions do not appear to support this directly, can anyone give us guidance on how to proceed?

    JHM5 pointsBadges:
  • store image to sql server

    would you please give me a code to store and retrieve an image in SQL Server 2000, using Visual Basic 6.0 on the front end

    Azad10 pointsBadges:
  • Problem inserting data using OPENROWSET in SQL Server 2000

    When I insert data into a table using OPENROWSET in SQL Server 2000, the data in the table comes up as “2.00804e+007” and “6.02303e+007”. Why might this be?

    SQL Server Ask the Experts2,585 pointsBadges:
  • 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...

    SteveInfoTool5 pointsBadges:
  • Backing up a SQL Server 2000 database through VB.NET 2005

    How might I backup a SQL Server 2000 database through VB.NET 2005?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Union operator in SQL server 2000

    How to give where condition to the result of the query using Union operator?

    Jyoti198645 pointsBadges:
  • SQL Server 2000 backup failed

    can not backup a 2000 db, dbcc checkdb ok. see following: Errorlog: 2008-01-08 09:54:40.69 spid62 Starting up database 'CP2005'. 2008-01-08 09:54:41.00 backup BACKUP failed to complete the command BACKUP DATABASE [education] TO DISK = N'C:\fjs1\education_db_200801080954.BAK' WITH INIT , NOUNLOAD ,...

    Fjsittler5 pointsBadges:
  • Installing SQL Server 2000 on Microsoft Windows XP

    I am attempting to install SQL Server 2000 on Microsoft Windows XP, but I keep receiving this error message: “Microsoft SQL Server 2000 Enterprise Edition server component is not supported on this operating system." What steps can I take to get rid of this message?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Advantages of SQL Server 2005 over SQL Server 2000

    What are the benefits of upgrading to SQL Server 2005 from SQL Server 2000?

    SQL Server Ask the Experts2,585 pointsBadges:
  • 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?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Calling a stored procedure in a SELECT list on SQL Server 2000

    I am using SQL Server 2000, and my question is: is there any way to call a stored procedure in a SELECT list?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Creating a user in SQL Server 2000

    How do I create a user in SQL Server 2000?

    SQL Server Ask the Experts2,585 pointsBadges:
  • How to restore a SQL Server 2000 database using a backup

    Could you please educate us on how to restore a database using a backup? We have a Mambilla PR software (.NET application) and SQL Server 2000 back end. We run the backup before any major change to the database.

    SQL Server Ask the Experts2,585 pointsBadges:
  • Setting up database mirroring for disaster recovery in SQL Server

    I am a SQL Server DBA and in the process of upgrading our SQL Server 2000 to SQL Server 2005. I’ll be using database mirroring for the disaster recovery in SQL Server. One question I have is once I failover to the mirror server and use it as a principal for a couple of days, how do I make sure...

    SQL Server Ask the Experts2,585 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following