• 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:
  • Backing up and restoring a LIVE database in SQL Server 2000

    I am using SQL Server 2000, and I backup and restore my LIVE database to a new backup server every night. Do you have any ideas as to why my restored database runs slow when compared to the LIVE database? Do I need to rebuilding indexes? Is there any way of backing up indexes as part of the main...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Slowdown on a server running SQL Server 2000 and Windows Server 2003

    I have a server with SQL Server 2000 SP4 and Windows Server 2003 Standard Edition SP1 that runs SAP Business One. The server's specs are: ML350G5 XEON 2.0DC 4GB RAM 6 UNITS SAS 72GB C:=>Raid 1+0, D:=>DATA Files, E:LOG files, F:TempDB files Swith Hub: 3COM 2924 SFP plus 3COM 4210 Cable: CAT5E...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Allowing SQL Server 2000 Enterprise Edition to utilize free physical memory

    I have two identical SQL Server 2000 Enterprise Editions running on Windows 2003 Enterprise servers. They both have 8GB of RAM with /PAW and /3GB switches configured. The max server memory is set to 7GB on both. On one of the servers, the available physical memory under Task Manager Is always...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Code differentiating between SQL Server 2000 and SQL Server 2005

    If SQL Server 2000 and SQL Server 2005 run on the same server, how can your code differentiate which database to use? Can you give the new instance of SQL a different name?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Spawning additional stored procedures in SQL Server 2000

    Is it possible in SQL Server 2000 for a stored procedure to spawn a second stored procedure which will not interfere or slow down the processing of the original? I need the original procedure to finish and return its output variables to the calling program before the second (whose function is to...

    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:
  • Managing a sytem with both SQL Server 2000 and SQL Server 2005

    I am the systems administrator on a system that has both SQL Server 2000 and SQL Server 2005 running on it. When they are starting up, the system works fine, but when we reboot the server, the 2 SQL Servers appear to fight each other for resources and the system crashes. This does not occur every...

    SQL Server Ask the Experts2,585 pointsBadges:
  • TaskPad view in SQL Server 2005?

    Is there a way to get the TaskPad view from SQL Server 2000 for use in SQL Server 2005?

    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:
  • Copying DTS packages from SQL Server 2000 to SQL Server 2005

    I am in the process of migrating from SQL Server 2000 to SQL Server 2005. We have several hundred DTS packages. Converting to SSIS will take many months, so we are planning to run the DTS packages under 2005. Is there an easy way, or a utility, to copy the DTS packages from one server to another?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Eliminating duplicate rows in SQL Server 2000

    I have a database I recently inherited in SQL 2000 that contains some duplicate rows. How can I identify the tables that have this problem (duplicate rows meaning ones that have the same “time_stamp” value, and “time_stamp” being used as a raw identifier)?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Table size in SQL Sever 2000

    Please, I need a script to know the size of every tables in my DB. I found that my database is growing above what I expected,and I need to know the size of its tables.

    Yunior5 pointsBadges:
  • Implementing row level security in SQL 2000

    Is there a way to implement row level security in SQL Server 2000?

    SQL Server Ask the Experts2,585 pointsBadges:
  • T-SQL how to identfiy tables that have dulicate roaws

    I have a MS 2000 SQL server. How can I search the db and indentify the tables that have duplicate raws. Thanks

    Techzon1225 pointsBadges:
  • MS SQL Server installing in the Livelink

    Hi there, I want to create a new Database ( MS SQL ) in the Livelink 9.7.0 , so which version ( MS SQL Server 2000 or 2005 ) is install in the Livelink 9.7.0 . If together can installed in Livelink 9.7.0 , whichever is better ? Best Regards, Abdullah from DUC

    A9944495 pointsBadges:
  • Need to upgrade sql server

    Hi right now my database server running on sql server 2000 & my application is also running from the same server for heavy load on server i m going to seperate my database server & application server i need a help bocz my database size is all most 3 GB. also i need to upgrade my database on new...

    Ravijoshi2020 pointsBadges:
  • Restoring SQL Server 2000 database

    I want to restore a database in SQL Server 2000, using a specific name. I tried restoring it using Enterprise Manager, but kept getting the error 'You must select a backup set to restore'. Why is this and how do I resolve it?

    Gini_25 pointsBadges:
  • how to update a row in grid view in vb.net

    how to update a row in grid view in vb.net using sql server as back end

    Anupamak1515 pointsBadges:
  • Linking Microsoft CRM to MSSQL Server

    We are currently setting up a email newsletter system for one of our client and are looking at linking to and fro their CRM, for example, we need to link our newsletters (stored in MSSQL) to their list of contact emails (Stored in CRM) and write information related to the newsletter usage back to...

    Estellemorris15 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