• Is there a built-in stored procedure in SQL Server 2000 that returns the sql table structure of XML format

    i have a xml file.i want to insert the contents of the xml file into a table in sql server 2005.

    Mitha10 pointsBadges:
  • Windows 2003 server hangs after reboot

    Hi All, We have a Windows 2003 server ( Model: HP Proliant DL385 ) running SQL Server 2000, in which we always experience issues. The issue is that Windows Server 2003 hangs after every reboot. Sometimes, it has also bluescreened and has created a memory dump. First time, when it bluescreened, the...

    jeevan930 pointsBadges:
  • Extracting information with a DTS package from a database in SQL Server 2000

    We currently use a DTS package to extract data from the database and export it in either an XLS file or a TXT file. We now need to be able to export it as an XML file, and SQL Server 2000 DTS functions do not appear to support this directly. How do you recommend we proceed?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Access databases

    I have a database that is in Access, Does anyone know if it is possible to query this DB using SQL server 2000..?

    Michaelrdowney10 pointsBadges:
  • What are the benefits of SQL Server 2005 over SQL Server 2000?

    If i am satisfied with SQL 2000 then why I should go for SQL 2005

    Itramkrishna5 pointsBadges:
  • Moving from single server to multiple servers

    Hi all, We have a Single Windows 2000 server (Back office edition, configured as a Primary domain controller). It has SQL server 2000 running, which serves a bespoke database application. The server is also used as a simple fileserver for documents, etc... We do not use Exchange Server. I need to...

    Michaeltwozero0 pointsBadges:
  • SQL Server 2000 Log File Size is increasing

    I have a sql server 2000 where log file is increasing very fast. My mdb file is 600 MB and Log file 6GB. How can i reduce the size of the file. Shrinking the file is not working.

    Ynaina5 pointsBadges:
  • how to Configure mail profile in MS SQL 2000 ?

    I have a requirment to recieve mail from my SQL server 2000 when ever a JOB in my SQL SERVER Agent fails ,I have my MAPI configured and SMPT too but in the SQL SERVER AGENT Properties window , the Mail profile is not enabled , how do i configure this , I want it in SQL SERVER 2000.

    SRI HARSHA10 pointsBadges:
  • Reindex DBF file from Ms-SQL 2000

    Is it possible to reindex an extenal dbf file via linked server ?

    Mic15 pointsBadges:
  • Can’t Upgrade to SQL Server 2005

    I am trying to upgrade a SQL Server 2000 SP4 standared edition running on 64bit Windows 2003 to SQL 2005. Since I am trying to upgrade, I am updating the Default instance. After selecting default instance, the wizard takes you to what components to upgrade; but the Database services is locked so it...

    Randym1,740 pointsBadges:
  • Copying a database from SQL Server 2000 to SQL Server 2005

    I am using the Copy Database Wizard to copy a database from SQL Server 2000 to SQL Server 2005. I gave it the data file path on the source server (ex. \SOURCEDBC$Program FilesMicrosoft SQL ServerMSSQLData), but it returns an error when I attempt to execute the package ("Access to the path...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Database hanged due to concurrence

    Hi to all. We have an application running under Windows 2003 Server, database SQL Server 2000, client/server, 60 users updating or consulting data. We did a concurrence test. We asked several users to search for same string at same time and the database got hanged. Will that be a configuration...

    Ome0015 pointsBadges:
  • Limitations on databases per instance in SQL Server 2000 and SQL Server 2005

    Is there any limitation on the numbers of databases per instance that can run in either SQL Server 2000 or SQL Server 2005?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Problems replicating SQL Server 2000 table

    I'm having problems replicating a table that is full text enabled using SQL Server 2000 sp4. When I start the distribution agent I get the following error: Cannot use a CONTAINS or FREETEXT predicate on table 'dbo.proposals' because it is not full-text indexed. I have run sp_fulltext_database...

    Systems Channel ATE15 pointsBadges:
  • SQL Server 2000 to SQL Server 2005 migration

    Hi, I am pretty new to the SQL Server DB. We are working on a project where in the db is migrated from SQL Server 2000 to SQL Server 2005. I was told that the migrated databases will consume more disk space on SQL Server 2005. Is that true? If so, what is the reason for that and how can we prevent...

    Vidukarth25 pointsBadges:
  • sp_OACreate is missing

    Hi I'm trying to create a stored procedure to send mail, and 1 line in my SP states: EXEC @hr = sp_OACreate 'CDONTS.NewMail', @MailID OUT But I get an error that sp_OACreate is missing. How it happened I don't know. But how do I fix the problem? Is it possible to recreate sp_OACreate manually?...

    Kowalski5 pointsBadges:
  • Implementing access from a remote site to a SQL Server 2000 database

    I have been tasked to set up access from a remote site to a SQL Server 2000 database. The user interface was programmed in .NET. This database will sit outside our firewall and will be protected by its own firewall. The application currently uses an ODBC connection to the database. Do you have any...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Increasing the performance of a slow query in SQL Server 2000

    I am using SQL Server 2000 SP4 on Windows 2003 Server, and I am having a problem with my queries. One of them was running fine a couple of weeks ago, but all of a sudden it is taking considerably longer to process than it used to. How might I resolve an issue like this from the database?

    SQL Server Ask the Experts2,585 pointsBadges:
  • i upgraded my vb6 database from sql 2000 to sql 2005 server.The same vb code is not working.What changes should i make in the code sothat it can work in sql 2005??

    i upgraded my vb6 database from sql 2000 to sql 2005 server.The same vb code is not working.What changes should i make in the code sothat it can work in sql 2005??

    Pandu5 pointsBadges:
  • Archiving databases on SQL Server 2000

    Could you help me to estimate how long it takes to archive 400 GB records from one of our test databases located on SQL Server 2000? Also, what would be the best approach?

    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