• Finding the total size of databases on SQL Server 2000 and SQL Server 2005

    Is there a quick way to find the total size of each database on SQL Server 2000 and SQL Server 2005? I have tried running “sp_spaceused”, but I do not want to run it manually for each database. Do you have any ideas?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Upgrading from SQL Server 2000 SP3 to SQL Server 2000 SP4

    We have SQL Server 2000 SP3 running on Windows 2003 Server. Every week, after running our optimization and integrity checks on Sunday, we get this error: Time out occurred while waiting for buffer latch type 2... This happens several hours into the day every Monday. Would upgrading to SQL Server...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Connectiveity JAVA to Sql server 2000

    Dear all, I have problam to connect SQL 2000 server with jdbc driver.\ i m using windows 2003 server SQL server 200000 and jbuilder. anyone have jdbc driver for the same environment thnaks

    M.Asif5 pointsBadges:
  • Error installing the client tools for SQL Server 2000 onto an XP desktop

    When attempting to install the client tools for SQL Server 2000 onto an XP desktop, I get an error stating that “A previous program installation created pending file operations on the installation machine. You must restart the computer before running setup.” Rebooting only leads to the same...

    SQL Server Ask the Experts2,585 pointsBadges:
  • full text search in sql server 2000

    can anyone tell me how I can get full text search to work in SQL Server 2000 ? Ive installed it, created a catalogue, selected a table (with a primary key) stepped through the wizard, in fact followed all instructions to the letter. When I run this query SELECT * FROM guidance WHERE CONTAINS(Title,...

    Mark...w10 pointsBadges:
  • Looking for detailed synchronization logging in SQL Server 2008

    We are in the process of performing a side-by-side upgrade from SQL Server 2000 to 2008 (Standard Edition in both versions). A merge publication is included in the upgrade, and it appears to be working fine on the new server, so there is no functional issue. However, I have grown accustomed to the...

    SBatSI415 pointsBadges:
  • Need help setting Transaction Log properties in SQL Server 2000

    I'd like some help determining what would be the best settings for my transaction log properties. When our SQL Server 2000 SP4 Database was setup it was done by developers without detailed information regarding all of the possible settings so most settings were left at their defaults. I have been...

    KansasCoder40 pointsBadges:
  • Error message when restoring a SQL Server 2000 backup to 2012

    While I was restoring a backup from SQL Server 2000 to SQL Server 2012. This is the error I'm receiving currently:Msg 3169, Level 16, State 1, Server FF101, Line 1 The database was backed up on a server running version 8.00.0760. That version is incompatible with this server, which is running...

    ITKE54,910 pointsBadges:
  • Altering a column in SQL Server 2000 (Not Null)

    I have a table in SQL Server 2000 that has several null-able integer columns. These are not working for me so I'm trying to update all nulls to 0 and then set the columns as "NOT NULL" (But the data must be preserved). Is there a specific SQL Syntax that could set the columns this way?

    ITKE54,910 pointsBadges:
  • Restore SQL Server 2000

    Our server crashed, I installed SQL 2000 on another server and would like to restore the databases from a backup copy. Please help.

    sfcharry5 pointsBadges:
  • Insert data to DB2 database using VB and SQL stored procedure

    I have spent a few days trying to find a solution using Google. Has anyone had luck with this problem? Simply put we are trying to send data from our web service to our I-Series. We need to do this via a SQL stored procedure. When we do the insert dynamically it works as long as there are no single...

    ToddN20006,360 pointsBadges:
  • Ability to spawn (or fork) a sproc in SQL Server 2000

    Is it possible in SQL Server 2000 for a sproc to call another sproc and then return it's output variables and close before (or while) the nested sproc processes? Goal is to nest a sproc that willl perform auditing on the called sproc without slowing it down waiting for the auditing.

    CO Bill120 pointsBadges:
  • How to restore Sql Server 2000 mdf and ldf data

    I have MDF and LDF files with different modified dates. How could I attach these to SQL Server 2000

    Databaseserver20 pointsBadges:
  • Accessing another database using a variable

    I have a select like this: SELECT a.part_id, a.descript, b.location from PART_MASTER a, anotherdatabase.INVENTORY b where a.part_id = b.part_id Is it possible to use a @variable to identify the other database, rather than hard coding it? (I've tried @db2.INVENTORY b) but SQL SERVER 2000 doesn't...

    CO Bill120 pointsBadges:
  • IBM Linked server will not do inserts

    I've spent close to 2 days looking for an answer and only got a headache. We have our IBM DB2 linked server defined as IBM DB2 UDB for iSeries OLE DB Provider. We can run select, update and deletes we just cannot do an insert. Here are our sample statements. SELECT * FROM OPENQUERY(OUR_DB2,'SELECT...

    ToddN20006,360 pointsBadges:
  • Database Recreate

    My SQL server 2000 Database is corrupted because of a virus infection. No tables are showing now. My database folder contains .mdf, .ldf and file (3 files) can I retrieve my tables using one of this. Any solution please? I don't have any other backups. Please get a solution.

    DatabaseRecovery35 pointsBadges:
  • Defrag SQL Database

    To my understanding, a normal defrag application will not defrag a SQL database. How would this be done, how would you defrag a SQL database? What applications could you use and/or what commands would you use? Kind Thanks.

    CyberJ0 pointsBadges:
  • unable to connect sql server 2000 on network

    We have sql server 2000 instance on a machine say "comp1".The problem is when i need to connect to it via another computer on LAN using SSMS it is unable to connect but when i connect to the "comp1" via run and give password then i am able to connect through SSMS Can someone give a solution so that...

    Psingh1630 pointsBadges:
  • Use of database backup from lower version to higher version of sqlserver

    I am using sqlserver 2000, have a database of 2GB. I want to shift at higher version 2008. What I have to do TO upload my Old version-2000 database backup  into  sqlserver 2008

    Vineet2820 pointsBadges:
  • How to work with Visual Basics 6.0 and SQL Server 2000

    I am designing a system with Visual Basics 6.0 as the user interface and SQL Server 2000 as the backend. How can I add data to the database through Visual Basics? How about deleting data in the tables?

    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