• Migrate FROM SQL2005 Ent. TO SQL2005 Standard

    We recently installed and have been running SQL 2005 Ent. because that is what we planned to use. During the 180 day window our needs have changed and we purchased Standard edition rather than Enterprise. Now we need to migrate from Enterprise to Standard. My question is what is the best way to do...

    Jtncat5 pointsBadges:
  • Migrating SQL Server replication from one server to another

    We are migrating our SQL Server from one server to another; is there a way that replication can also be moved from source to destination?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Is it possible to copy system DBs to another server?

    Hi, I am at total lost at trying to copy system db(master, model, distribution, etc) from a 2005 server on one machine to another 2005 server on a different machine, so all the logins, job, etc are also copied to the new server. I have tried to google this problem and am at a lost to how to do...

    Db23290 pointsBadges:
  • MIgration to 64-bit Sql Server

    What issues do I face with database file compatibility if I migrate from 32-bit SQL Server 2000 to 64-bit SQL Server 2005?

    Tomfitzrugger5 pointsBadges:
  • Manually migrating databases from SQL Server 2000 to SQL Server 2005

    I am manually migrating a large number of databases from SQL Server 2000 to SQL Server 2005. What kind of issues should I expect, and do you have any readily available solutions?

    SQL Server Ask the Experts2,585 pointsBadges:
  • How to move a DTS from sql 7 to a server running sql 2005?

    I have several dts packages that are running on a sql 7 server, I need to move them to a server running sql 2005. Any suggestions on how to do this? Thanks

    Bubbanm90 pointsBadges:
  • SQL Database Migration Process

    Hello, I would please like to know if someone could help me out with a database migration issue.I have a server and i need to migrate all of my data on my current database to a new database.It seems that the new database might be a little different in structure and the tables generally so i would...

    Absorbed5 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:
  • problem with sys.endpoints

    Hi, I have ms sql database created in 7.0; I had shift all the data files to a different server where ms sql 2005 is installed. I was able to start sql server from the 7.0 database by specifying the startup parameters. But when I try to connect thru sql mgmt. studio I am getting the "object not...

    Vsskmk5 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:
  • Database migration from SQL Server 2000 to SQL Server 2005

    I am attempting to migrate a database from SQL Server 2000 to SQL Server 2005; the size of the database is almost in terabytes. During migration, I would like to interact with the database on the SQL 2000 server. Is it possible to achieve migration without detaching the database from SQL 2000? If...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Migrating from SQL Server 2000 to SQL Server 2005 on a failover cluster environment

    I am planning to migrate my SQL Server 2000 databases to SQL Server 2005 on a failover cluster environment. What is the simplest strategy you could recommend to fulfill this goal?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Migrating stored procedures from SQL Server 2000 compatibility mode to a SQL Server 2005 database

    I recently migrated some reports and stored procedures from a SQL Server 2005 database server in SQL Server 2000 compatibility mode to a SQL Server 2005 database. Afterwards, we have not been able to get the stored procedures to run to completion. We have found two issues: one is collation between...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Storing attachments in tables on SQL Server 2005

    I am new on .NET and plan to migrate some applications to this new environment. I have a simple question – on SQL 2005, can you store attachments inside of tables?

    SQL Server Ask the Experts2,585 pointsBadges:
  • jobs runing on the server

    hi every 1, i am having a real tough time to figure this one out . i need to find out what jobs are schedule in the server that sends data out to ever . we are doing the migration from 2000 to 2005 and need to know which jobs send data to the another server . i looked at the sysjobs_view , it tells...

    deal11deal110 pointsBadges:
  • Data Migration Betrieve Tables to MS SQL Server 2005

    Hi! could somebody help us advice on what to do and what to prepare if we are going to migration our current database Betrieve tables to MS SQL Server 2005? Thanks. Note: We are currently accessing the Betrieve tables thru PervasiveSQL v8 engine.

    Wonderer0820 pointsBadges:
  • Upgrade to SQL Server 2005 resulted in 100% CPU utilization and application timeout error

    My server is DL580 running on Intel Xeon Dual core Dual CPU. I have recently migrated from SQL Server 2000 to SQL Server 2005. The server is dying and showing 100% CPU utilization and applications are getting Server Timeout expired error. What can I do?

    SQL Server Ask the Experts2,585 pointsBadges:
  • unable to modify field in SQL Server 2005

    I have a database that was working perfectly on SQL 2000. We moved the data to SQL 2005. Now when our program accessing the SQL 2005 Server we get "Field 'optional' cannot modify." The Field optional is a bit field. The program is able to modify other tables in the database. It just won't modify...

    only1rb15 pointsBadges:
  • Converting from 2000 to 2005

    I was given an existing application/database with stored procedures to work on. The existing database is in 2000 however the manager would like it converted to 2005 (she thought it already was a 2005 database). My system is only configured for 2005 so my analysis tools are not working on the...

    GUI Girl5 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