• 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...

    Arans5 pointsBadges:
  • SQL SERVER 2000, 2005 & 2008

    Can Sql Server 2000/2005/2008 exist on the same machine

    Sdonthi5 pointsBadges:
  • Cannot Regster remote Sql Server 2000

    i can access remote server by remote desktop and i can ping server also, but fail to register remote sql server,Please Help

    Master197015 pointsBadges:
  • Server Performance online replication

    I have DB of 60 GB on SQL 2000 running on A/P Cluster. I want to do online replication. What would be the impact over Live server performance. Kindly Suggest.

    Natish10 pointsBadges:
  • Import SQL Server 2000 DTS package to new box

    Hi, I am building the new SQL 2000 SP3 server on Windows 2003 R2, in my old box there were alot of DTS package which is I need to import, my question is what account should I import it as to avoid the security right? in my old box I have 3 admin account only one own the DB whoever, DTS package were...

    Bjet55 pointsBadges:
  • How to check the existence of a Column in SQL Server 2000?

    - using SQL Server 2000 , Would like to know how to check any specific column exist in a database. Any method to search through the list of tables in a database. Thanks.

    Hunkgym5 pointsBadges:
  • Upgrading to SQL Server 2005

    I have a question regarding SQL Server upgrades. We have two active/passive clusters on which SQL Server 2000 resides. I want to install SQL Server 2005. How would I go about doing this?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Changing Compatability Level from 65 to 80

    SQL 2000 (sp4) instance with databases at compatibility level of 65 and 80. Is changing the compatibility level from 65 to 80 actually upgrading the database to 80? What should be done before and after changing the Compatibility level?

    Rah15 pointsBadges:
  • Can we migrate already encrypted data from SQL Server 2000 to MS SQL Server 2008

    I have encrypted data in MS SQL Server 2000. I want to migrate in MS SQL Server 2008. I have migrated successfully through the attach/dettach process but when I am trying to decrypt the data. is it giving different result or value. is the right process to migrate the encrypted data? Please suggest...

    Amit1may5 pointsBadges:
  • Is there a query to retrieve datatypes from SQL stored procedures?

    I have used the following simple query to retrieve datatypes from SQL Server 2000 tables: select TABLE_NAME, COLUMN_NAME, DATA_TYPE, CHARACTER_MAXIMUM_LENGTH from <tablename>.information_schema.columns where table_name = '<tablename>' and column_name = '<columnname>' Along these...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Database connectivity using ActiveX control

    Provide a sample code to how by using VB 6.0 connectivity can be done by ActiveX(ADO) Control tool with the database SQL Server 2000

    Reena10 pointsBadges:
  • Database connectivity using Data Control

    Provide a sample code to how by using VB 6.0 connectivity can be done by Daat Control tool with the database SQL Server 2000

    Reena10 pointsBadges:
  • Migrating SQL Server 2005 back to SQL Server 2000

    How would I go about migrating SQL Server 2005 back to SQL Server 2000?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Multiple instances with SQL Server

    Is it adviceable to put SQL 2000 and 2005 in one single CLuster by putting them in different instances?

    IMR5 pointsBadges:
  • Executing DTSX from VB.NET 2003

    We converted form SqlServer 2000 to 2005. We had dts packages which were used to import Excel data into the database. We re-created new dtsx packages to replace the old dts packages where they sit on a local drive. Our VB.NET 2003 application used to be able to run the old dts packages but we...

    BClawson10 pointsBadges:
  • Linked servers from SQL 2000 to SQL EXPRESS 2005

    I wanted to create a linked server on SQL SERVER 2000 to SQL EXPRESS 2005.Both servers are on the same machine .SQL SERVER 2000 using username and password while SQL EXPRESS using integrated security.Thanks in advance.Any one let me know how to create this?

    Pdeevi5 pointsBadges:
  • Error when updating SQL Server 2000 from SQL Server 2005

    Hi, I am using sqlServer 2005 and sqlServer 2000. When i update on sqlServer2000 from sqlServer2005 then following error was occured. Msg 682, Level 22, State 148, Line 1 Internal error. Buffer provided to read column value is too small. Run DBCC CHECKDB to check for any corruption.

    Nileshpatkar825 pointsBadges:
  • SQL Server 2000 script

    Hi , How can we use SQL 2000 script to call 2nd maximum date? case : Item A has few price with different effective_date, Ihow can i call an item's price with second max(effective_date). Thanks in advance.

    Beginer200825 pointsBadges:
  • Error message from SQL Server 2000 Agent after antivirus installation

    SQL Server 2000 Agent would not start after the installation of the antivirus software Sophos and a reboot. I found the messaging service was shut off, so I started it, rebooted and the agent came up running. I then tried to start a backup job, but I received “error 14258,” which stated that it...

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

    How I can consolidate seven SQL Server 2000 and SQL Server 2005 databases to only SQL Server 2005 databases? Both servers are HP and Dell servers.

    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