• Insert and update DB2 from SQL Server 2000 using OLEDB

    I am using AS/400 and SQL Server 2000 and trying to insert and update from SQL Server. When I run a DTS from SQL Server 2000, SQL Server 2000 is able to read the table from AS/400 but when I run a DTS from SQL Server 2000 to insert or update a table on AS/400, it does not do anything. No error, but...

    Sandy555 pointsBadges:
  • How can we use SQL 2000 or latest with Visual FoxPro

    Hello Friends I want use SQL in visual foxprox. how can do it. I ready many website, but all answer not fully cleared. Please send me Solutions. My Computer (SQL Server 2005 and Coputer Name) name is SEMSVR. Waiting your reply.

    Abhiindia15 pointsBadges:
  • Virtualizing SQL

    Is it possible to run SQL Server 2000 on a VM on a workstation? If so, anything special to consider?

    greg08115 pointsBadges:
  • What is the process to upgrade a database from SQL Server 2000 to SQL Server 2008 R2?

    What is the process to upgrade a database from 2000 to 2008?

    ITKE342,935 pointsBadges:
  • Data type : GMToffset in SQL Server 2000

    how this data type GMToffset will work.?? can you please help me in that where the offset is a feild in the table & GMToffset is its data type exist in sql server 2000 or it is derived ?? why we use GMT instead of local time?? Is this data type x

    NSH5 pointsBadges:
  • SQL Server user name issue

    We have a server in which Windows 2003 is installed and we have created users in the domain (e.g. - aaa). The server is installed with SQL Server 2000 and data is stored in the database. The user name for the server is “administrator.” When we login from the user computer with the same name and...

    SQL Server Ask the Experts2,585 pointsBadges:
  • View a concise list of all Job Schedules SQL Server 2000

    I have an Optimisation job on my SQL platform (2000), which continually fails. I suspect the cause in that this job overlaps another, but without going through each job and checking the schedules I can't be sure. The number jobs I have makes this an onerous task. Is there a way to query the...

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

    Dlfshweta5 pointsBadges:
  • attach a new mdf and ldf files in sql server 2005 enterprise

    i have a new mdf and ldf file created in sql server 2000.how could i attach these to sql server 2005 enterprise edition?i tried it by right click the database and select attach.but it shows an error when click the add button in database dialogue box.

    Itdonsavi30 pointsBadges:
  • How do i recover the DB from suspect mode in sqlserver 2000?

    I have a database that went to suspect mode in sqlserver 2000.How do i recover the DB from suspect without restore the DB? 

    Sqkservrdb20005 pointsBadges:
  • Encrypting passwords on SQL server 2000

    I m using SQL server 2000 and I want to use a password field for Employee Master. My question is how to encrypt this password field in my insert query. I have heard about the “EncryptByPassPhrase” function and symmetric key, but it is provided from SQL Server 2005. I have tried using pwdencrypt...

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

    In my office we work on SQL Server 2000, and we have software in .NET Question 1: Sometimes the message display reads “You cannot access because of user limit". What does this mean? Question 2: Some of my computers work slow in SQL for an hour or two at a time. What can I do to fix this?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Running SQL Server 2000 and 2005 simultaneously

    When simultaneously running SQL Server 2000 and 2005, what performance effects can I expect this having on the box? Should the memory be increased? And what can I do now to fine-tune it before the install of 2005?

    SQL Server Ask the Experts2,585 pointsBadges:
  • row_number in sql 2000

    how to find out the row_number in sql 2000 like using row_number() function in sql 2005

    Rl10 pointsBadges:
  • Switching from Bulk-Logged to Simple Recovery Model on SQL Server 2000

    Hello, I've got a SQL Server 2000 SP4 database that I am considering switching from Bulk-Logged to Simple recovery model. The reason is, there are no transaction log backups happening so the log is just growing to an unmanageable size (40+ GB). I also want to minimize/shrink the log file. What is...

    John09905 pointsBadges:
  • Storing encrypted files on an SQL Server 2000

    We are doing our final year project as a secured electronic voting system. To finish this project, we are in need of storing our votes in an encrypted form to provide security and, to do so, we are using back-end as SQL Server 2000. Is this possible or must we change our back-end?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Monitoring log files in a SQL Server 2000 database

    I have an intermittent problem with a SQL Server 2000 database. The job, to truncate the log files, doesn't start on time, and the transaction fills up preventing users from logging in. I would like to monitor the log such that I can send an alert when the log reaches e.g. 80% full.

    SQL Server Ask the Experts2,585 pointsBadges:
  • Using SQL and Postgre on the same machine

    We have a requirement in which we need to have our Microsoft SQL Server, as a database of tomcat servers, and our Postgre SQL, as database of jboss servers, on same machine. Are there any known conflicts or issues we should be aware of?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Adding and removing disk space for SQL2000

    The scenario:SQL_SVR_A (2000)has x amount 'too much' SAN disk space that they want to reclaim/use to allocate to SQL_SVR_B (2000)- which doesn't have enough space. What is the best method to 1)remove the disk space and keep all db's in-tact (backup/recovery?, or another way??) and 2)how to add the...

    Jclarcher15 pointsBadges:
  • sql server 2000 in server

    Hi, We have a server in which windows 2003 is installed and we have created users in the domain (eg - aaa). The server is installed with sql server 2000 and data is stored in the database. The user name for the server is administrator. The problem is when we login from the user computer as the same...

    Radhaisgoodenough5 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