• Can you replicate SQL 2003/8 to SQL 2000

    I am upgrading a server running SBS w/SQL2000. New server will be 2003 or 2008. Would like to use old server for backup off site. Can I replicate, or would I need a new 2003/2008 license to accomplish this?

    AtlantaRookie5 pointsBadges:
  • Kaplan IT Learning SelfTest software

    Hallo community, 70-448 Microsoft Certification Practice Products 70-432 70-433 have you purchesed this software ? what is your experience? I want to prepare for these exams. Thank you very much in advanced for the Answer. DeshRaja

    DeshRaja25 pointsBadges:
  • Copying view from remote to local SQL Server with SSMS

    Hi I'm currently trying to get to grips with an upgrade from sql server 2000 to 2008, forced by an upgrade at my ISP. I'm used to using Enterprise Manager to export data from my ISP to my local machine for backup, and this process copying tables as tables, views as views and so on. But using Export...

    Tsp196520 pointsBadges:
  • Error message when finding a database on SQL Server 2008

    I have installed the Small Business Edition of SQL Server 2008, and I have created a Microsoft Dynamics NAV database on this SQL Server. However, when trying to locate the server from a pc in the office, it does not find the database. The error message is: "The 192.168.0.7" server cannot be found."...

    SQL Server Ask the Experts2,585 pointsBadges:
  • SQL Server 2008 compression experiences?

    We are about to migrate a database from SS2005 32-bit to 2008 64-bit. One of the biggest drivers for this is the compression capability in SS2008. We expect to shrink our 2TB database down to about 500GB (proven in testing), and get the comparable IO performance improvements (4x faster reads - also...

    Dschwant175 pointsBadges:
  • AS/400 to SQL Server 2008

    Hi, Is there a way to pull an AS/400 File into SQL server 2008? From within SQL 2008 we do not see an ODBC connection that will work for the 400(??) I am not familiar with SQL server and we need to get some data to it. Can anyone shed some light on what I may be missing in regards to the link to...

    Rmason345 pointsBadges:
  • Transferring a database and writing a database script in SQL Server 2008

    I want to transfer a database from one server to another server using SQL Server 2008, and then I want to write a script which i can update the database daily automatically. How can these be done?

    SQL Server Ask the Experts2,585 pointsBadges:
  • 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:
  • Building reports in SQL Server 2008

    I am on SQL Server 2008, and we want the clients to be able to build their own reports whenever they want. Are there any tools out there that can do this?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Storing large data files in SQL Server

    What are the alternatives to store data more than 2 GB in SQL Server 2005 or 2008?

    SQL Server Ask the Experts2,585 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:
  • SQL Server 2008 SISS error row handling

    Struggling with SISS I have data source and data destination With some bad data, I can't figure out how to set up sending the bad row to another destination There are over 50 columns. Sorce is a tab delimited text file Desitnation is SQL Table

    Mambo5 pointsBadges:
  • SQL Server 2008

    How to format crlf inside a field text

    2601515 pointsBadges:
  • SQL Server 2005 vs SQL Server 2008

    When comparing SQL server 2005 to 2008, does 2008 hold more data, or is it just an upgrade on what you are able to do with the data?

    Ryzawack15 pointsBadges:
  • Copying databases in SQL Server 2005 and SQL Server 2008

    In SQL Server 2005 and SQL Server 2008, the CREATE DATABASE function creates a new database and copies all the tables that are present in the model database. Is there a function where I can do the same from a template database?

    SQL Server Ask the Experts2,585 pointsBadges:
  • What’s a safer upgrade, SQL Server 2005 or the new SQL Server 2008?

    Do you think that as of next January (2009), SQL Server 2008 will be too new and we should instead go with SQL Server 2005? FYI, we are not a big installation.

    SQL Server Ask the Experts2,585 pointsBadges:
  • Learning SQL 2005/2008

    I would like to start from the grounds up in learning SQL 2005 and 2008. Any recomendations? I have been working with databases for sometime now including SQL 2000, but I have not jumped to anything newer. Thanks.

    NKaram5 pointsBadges:
  • Restoring a SQL Server 2005 IBM Rational RequisitePro database from SQL Server 2008, back to SQL Server 2005

    I have installed a SQL Server 2005 IBM Rational RequisitePro DB into my local SQL Server 2008. Can I restore this database back to the SQL Server 2005 box? I know this was a problem when going from SQL Server 2005 to 2000.

    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