SQL Server migration

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?

View Answer   |  Jun 27 2008   6:36 PM GMT   |  asked by SQL Server Ask the Experts
SQL Server 2000, SQL Server 2005, Migration

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

View Answer   |  Jun 24 2008   8:08 PM GMT   |  asked by SQL Server Ask the Experts
SQL Server 2005, Database, Migration

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

View Answer   |  Jun 24 2008   8:00 PM GMT   |  asked by SQL Server Ask the Experts
SQL Server 2005, SQL Server 2000, Stored procedures

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?

View Answer   |  Jun 13 2008   3:18 PM GMT   |  asked by SQL Server Ask the Experts
SQL Server 2005, .NET, SQL Server migration

Encryption Form SQL Server 2000

I want to transfer data from one database to another database both the databases are on sqlserver 2000 i want to transfer the data in encrytion form how do i do it .....Regards,Sahil

View Answer   |  May 26 2008   11:32 AM GMT   |  asked by Maruf24
Data transfer, SQL Server 2000, Encryption

Is there a query to search text of all SQL Server database objects that reference a specific table/instance?

We want to migrate to SQL Server 2005. We need to find all database objects such as Stored Procedures, Views, Triggers, User Defined Functions accessed specific tables, DTS packages that reference a specific table/instance. Is there a query that will allow me search the text of all?

View Answer   |  May 7 2008   3:49 PM GMT   |  asked by SQL Server Ask the Experts
Query, SQL Server migration, Database objects

Migrating from MS Access to SQL Server Express

I've just installed SQL Server Express and I want to create a local instance. I would like to use SQL Server to do my analysis in running queries instead of Microsoft Access. I want to import my tables from Access to SQL Server Express. How can I migrate from MS Access to SQL Server?

View Answer   |  Apr 18 2008   1:01 PM GMT   |  asked by SQL Server Ask the Experts
SQL Server migration, SQL Server Express Edition, Microsoft Access

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.

View Answer   |  Apr 14 2008   8:10 AM GMT   |  asked by Wonderer08
Data migration, Database migration, Migration

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?

View Answer   |  Apr 4 2008   1:46 PM GMT   |  asked by SQL Server Ask the Experts
SQL Server upgrades, SQL error messages, SQL Server performance

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

View Answer   |  Mar 31 2008   3:08 AM GMT   |  asked by Deal11deal1
SQL Server administration, SQL Server migration, SQL Server 2000

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

View Answer   |  Mar 27 2008   6:24 PM GMT   |  asked by GUI Girl
SQL, SQL Server 2000, SQL Server migration

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

View Answer   |  Mar 26 2008   7:43 AM GMT   |  asked by Only1rb
SQL Server migration, SQL Server errors, SQL Server 2000