SQL Server 2000

Why and how to performance tune SQL Server 2005

Why do you have to tune SQL Server 2005 for performance, how do you go about tuning it, and, for tuning purposes, which is better - SQL Server 2000 or SQL Server 2005?

How to make installer of VB.NET including SQL Server 2000?

I had done my project in vb.net with sql server 2000 but it's installer doesn't work properly as it displays the message unexcepted error while connecting to the database.I know setup and deployment in vb.net but doesn't working please help me.I am stuck in here.thanks in advance.

Scheduling a Shrink Database in SQL Server 2000

Is there a way to schedule a shrink database after the transaction log has been backed up for a database via the maintenance plan?

Migrating data from a SQL Server 2005 database to SQL Server 2000

I am looking for advice on what technology to use to migrate data from a SQL Server 2005 database to SQL Server 2000. We are currently phasing out our old help desk ticketing system in SQL Server 2005 to a new ticketing system in SQL Server 2000. The tables in the databases are not identical...

Shortening the generation time for a SQL Server 2000 report

I have 516 different functions in SQL Server 2000 that are used for different calculations. These functions will operate on more than a thousand Microsoft Excel files. Each Excel file has 960 rows, and generating the report took over four hours. Is there a way to shorten this?

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

SQL SERVER 2000, 2005 & 2008

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

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

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.

Merge two companies into one network

The company I work for has decided to merge with its Sister Company on the lower floor. While we share the same room to house our independent servers, both companies have separate physical networks. Each with their own separate File Servers & SQL servers. Allowing Company "A" employees to log...

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

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.

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?

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?

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

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

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

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

Migrating SQL Server 2005 back to SQL Server 2000

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

Multiple instances with SQL Server

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