SQL Server 2000 (major build version 8.00.xxxx). Please also tag sql-server.
SQL Server 2000 codename Shiloh. Major releases:
- 8.00.194 RTM
- 8.00.384 SP1
- 8.00.532 SP2
- 8.00.760 SP3
- 8.00.2039 SP4
Questions tagged [sql-server-2000]
275 questions
30
votes
5 answers
How can I tell WHY an insert on a certain table is slow?
I know that an INSERT on a SQL table can be slow for any number of reasons:
Existence of INSERT TRIGGERs on the table
Lots of enforced constraints that have to be checked (usually foreign keys)
Page splits in the clustered index when a row is…
BradC
- 10,073
- 9
- 51
- 89
24
votes
2 answers
How do you reset the sa password?
I lost the sa password on a machine, and when I log in to the machine directly using an account in the admin group, SQL Server Management Studio will not allow me to log in using Windows authentication.
My plan was to simply log into the server,…
Daniel Williams
- 936
- 4
- 11
- 19
23
votes
1 answer
Upgrade SQL Server 2000 database to 2008 R2 and enable new features
I have recently upgraded SQL Server 2000 database to 2008 R2.
What I did was:
Shutdown SQL Server 2000 (express) service on old machine,
Move datafiles (mydatabase.mdf and mydatabase.ldf) to new machine,
Run SQL Server Management Studio…
saelic
- 345
- 1
- 3
- 9
19
votes
5 answers
Why do linked servers have a limitation of 10 branches in a CASE expression?
Why does this CASE expression:
SELECT CASE column
WHEN 'a' THEN '1'
WHEN 'b' THEN '2'
... c -> i
WHEN 'j' THEN '10'
WHEN 'k' THEN '11'
END [col]
FROM LinkedServer.database.dbo.table
Produce this…
Andrey
- 293
- 1
- 2
- 8
18
votes
3 answers
Should I migrate data using detach/copy/attach or through backup-restore-replay?
I am about to embark on migrating database files to a new SAN (from an old SAN) abd I have a couple of options to implement this. (1) It was suggested that I look into the level of effort of restoring a full backup to a new database on the server.…
swasheck
- 10,755
- 5
- 48
- 89
16
votes
6 answers
Suddenly Slow Execution Plan for Stored Proc
I'm trying to understand an issue we're having with SQL Server 2000. We are a moderately transactional website and we have a stored proc called sp_GetCurrentTransactions which accepts a customerID, and two dates.
Now depending on the dates, and the…
Ciaran Archer
- 395
- 2
- 3
- 10
16
votes
1 answer
How can I design a query to pause / sleep / wait for a specified amount of time?
I am testing a monitoring application against a SQL Server 2000 instance. How can I write a T-SQL query that takes an amount of time that I specify? For example, most scripting languages have something like the SLEEP command which allows you to…
Jinxter
- 163
- 1
- 4
15
votes
3 answers
Can I connect to a SQL Server 2000 instance from SQL Server Management Studio 2012?
I would like to update my development machine to SQL Server 2012 but I still manage some (very old) SQL Server 2000 machines. Wil my 2012 SSMS be able to connect to those SQL Server 2000 machines?
SQL Server 2008 R2 works fine (what I have now).
Michael Haren
- 335
- 2
- 3
- 9
15
votes
1 answer
Are there reasons why I should not set my db owner to [sa]?
Yesterday I asked this question regarding changing the dbo of multiple databases that I have. The change makes sense, but I want to be clear.
Is there any, good reason or circumstance why I should not set the dbo of a database to [sa]?
RLH
- 937
- 1
- 8
- 16
13
votes
5 answers
Query without having to specify table's schema
I imported a bunch of tables from SQL Server 2000 to my 2008 database. All the imported tables are prefixed with my username eg: erpadmin.tablename.
In the table properties it lists 'erpadmin' as the db schema. When I write a query I now have to…
Ramdas Bhosale
- 231
- 1
- 2
- 4
12
votes
6 answers
Migrate from SQL Server 2000 to 2012 without a 2005 or 2008 instance
I have come across three old databases sitting on SQL Server 2000 which I need to move to 2012. I believe the standard approach is to restore into a 2005 or 2008 instance, update, re-export and finally restore into 2012.
Fine, except we have no 2005…
Lunatik
- 231
- 1
- 2
- 8
12
votes
3 answers
How to delay SQL Server startup
When we boot SQL Server, SAN drives might not be availiable yet. Is there a way to delay SQL Server start by 1 minute? Right now we have to restart SQL Server after we boot the server.
ob213
- 654
- 1
- 9
- 19
10
votes
2 answers
Could not continue scan with NOLOCK due to data movement
We run SQL Server 2000 and we get a few of these errors every night.
Could not continue scan with NOLOCK due to data movement
The query that throws this error is a large complex query that joins over a dozen tables. Our underlying data can be…
Ciaran Archer
- 395
- 2
- 3
- 10
10
votes
2 answers
SQL Server 2000 on Windows 10
I need to install SQL Server MSDE 2000 SP4 on Windows 10.
I have other machines that run Windows 7 and 8.1 and SQL Server MSDE 2000 works fine (with merge replication configured too).
Now I testing the same scenario with Windows 10, but setup is…
KronosInfo
- 113
- 1
- 1
- 4
10
votes
4 answers
SQL performance issues with remote query across linked server
This sproc
create proc dbo.Get_Accounts as
begin
declare @current_date datetime
set @current_date = dbo.fn_currdate()
select [fields]
into dbo.current_accounts
from linkedserver.database.dbo.accounts
where date =…
Bob Probst
- 267
- 1
- 2
- 7