SQL Server 2000

SQL 2000 Upgrade

I am upgrading four sql servers 2000 to 2005. If i do an inplace upgrade to the default instance would i need to change any passwords for linked servers, services or sql accounts?

Deadlocks and Conflicting resources

I have a program that loops through a temp table, and for each row looks up a value in another table, and depending on the result returned inserts a record into one of two tables. Some days this takes 10 minutes to run and others it takes 2 hours to run. There are no other processes running...

SQL Server 2000 Database Table Limit?

Is there a limit to how many tables a single database can hold in SQL 2000?

How do you create stored procedures in SQL Server 2000?

How do you create stored procedures in SQL Server 2000?

Execute a view/query is slower in SQL Server 2005 than 2000

Hi, I have migrated a database from 2000 to 2005, updated the statistic and rebuild the index. When I run the following query "select top 500 * from myview order by name", it is extremely slower in 2005 than 2000. The myview simply does an inner join with 2 table. The name is varchar(50)....

SQL Server Table and View Index

Hi, I was wondering if migrating a database from SQLServer 2000 to 2005 using restore or detach/attach also copies the table and view index. Thanks.

Link microsoft SQL server to Active Directory

I am getting an error while running a qurey for excuting against OLE DB provide'ADSDSOobject' Please advice Thanks Rajaa

Looking for a query tool for SQL Server 2000 and SQL Server 2005

Many of our developers would like to have a client utility like Query Browser or Query Analyzer installed on their machine, so that they can personally query our SQL Server 2000 and 2005 servers and view the results from their workstations. I am unable to find the appropriate way to install...

Attaching a SQL Server 2005 database to SQL Server 2000?

Is it possible to attach a database that was created in SQL Server 2005 to SQL Server 2000?

Conversion of SQL Server 2000 to iSeries DB2 V6R1

Hi there. We are converting SQL Server 2000 to DB2 on iSeries V6R1. We’re ok with the JDE tables and views, but are having difficulty with the non-JDE tables, views, and stored procedures. Is there a tool or something that could help us? Thank you.

Adding SQL perfrmon counters

Recently a site administrator installed a SQL2000 server on Windows 2003. For some reason the perfmon counters for SQL do not show up when trying to check performance. How should these counters be added and/or activated post-installation? In the IT trenches? So am I - read my IT-Trenches blog

Simple SQL server question?

I want to do something that WAS easy in my former world (a dBase environment) but I can't figure out how to do it in MS Access/SQL Server 2000. I would GREATLY appreciate anyone's help. This is what I want to do, in order: 1) Select the top # records of a table, "#" is a field in another table....

Application not responding in Windows XP Professional

How do I determine what is causing a "Not Responding" status in Windows Task Manager when running my application? It changes back and forth from "Running" to "Not Responding". It is very slow but eventually finishes. Using Windows XP Professional and SQL Server 2000.

How to migrate a database from SQL Server 2000 to SQL Server 2005

Can someone explain in detail how to migrate a database from SQL Server 2000 to SQL Server 2005, including which components need to be migrated?

SQL Storage Server

I am uploading in an SQL Server with a maximum of 1250 check images per batch with a minimum of 45KB file size (back and front) with indexes using a thrid party application. The images are temporary stored on a directory watch (7 folders) before running the import application. There are instances...

CRViewer Logon Failed error within Visual Basic 6

I developed and tested a VB6 program that runs CR Viewer accessing with RDC Crystal Reports 11 reports from a folder on a remote server and uses data and queries from SQL2000 on the same server. All operating systems use MS XP. My problem is that the program works on my desktop and a few others,...

Monitor SQL Server 2000 Analysis Services Cubes

I am working in a BI role and have some ancient AS2000 cubes that are used across the organisation. Only trouble is no-one is exactly sure who uses them daily. How can i monitor which cubes are being accessed by whom? Doesnt seem that profiler picks up AS transactions so im kinda stuck how to do...

Deleting in a complicated data structure on SQL Server 2000

I have a complicated data structure on SQL Server 2000 which, at times can go four levels deep. It is all designed using foreign keys, as expected. I am having difficulty getting deletion to work from the top level, which is an orders table. Some child tables have cascade deletes on, and some are...

Looking for detailed synchronization logging in SQL Server 2008

We are in the process of performing a side-by-side upgrade from SQL Server 2000 to 2008 (Standard Edition in both versions). A merge publication is included in the upgrade, and it appears to be working fine on the new server, so there is no functional issue. However, I have grown accustomed to the...

Large DB, low capacity line, resync log-shipping options.

Hello, We've a large SQL2000 DB which is 335GBs in size and a majority of tables are geographically replicated to a subscriber using transactional replication across a 10Mbit line. We're going through the process of converting the DBs' environment to SQL 2005. Unforetunately I think this means...