Questions tagged [sql-server-2000]
SQL Server 2000 (major build version 8.00.xxxx). Please also tag sql-server.
275 questions
0
votes
2
answers
819
views
SQL Server 2000 to 2008 security logins transfer
I'm currently upgrading SQL Server from 2000 to 2008, the database was successfully transferred, the issue remains with the security logins, I have found the stored procedures that extracts the logins ...
2
votes
1
answer
403
views
Can I restore a current mdf that is current with an ldf that is two years old?
I have SQL Server 2000 (aka version 8.0) that failed to recover a database after a power failure. The only backup I found are the current mdf file and an ldf file that is two years old.
Can I restore ...
- 21
1
vote
0
answers
142
views
Testing SQL connections with UDL file
I am testing SQL connectivity between a SQL server (windows server 2000) and client PC that has no SQL tools installed (windows 2000 SP4). The client PC runs a java application that needs to connect ...
- 75
0
votes
0
answers
75
views
SQL connections to java applications
I have an MSSQLServer2000 database that seems to have been working just fine until today. The DB connects to a java application on a remote server that passes the database data (login credentials, ...
- 75
0
votes
2
answers
44
views
Count results of table by date [closed]
I am trying to query the number of transactions that occur on a given day with the following query
select COUNT(seq_no) from "table"
where start_time >= '2020-04-01 00:00:00'
and ...
- 75
0
votes
0
answers
44
views
Changing SQL Server2000 settings after converting to VM?
We have migrated a SQL 2000 server to VM and I am wondering what changes will need to be made on the VM?
After the VM migration an SSIS package that transferred data from the 2000Server to a ...
- 75
1
vote
1
answer
1k
views
Able to connect with connection manager but SSIS package does not authenticate
I have an SSIS package that connects MSSQL2008 server to MSSQL2000 and pulls data off the 2000 server and transfers it to the 2008 server. The 2000 server was recently virtualized and since then the ...
- 75
1
vote
0
answers
425
views
Is it possible to create a Linked Server from SQL Server 2000 to SQL Server 2016?
I am trying to create a Linked Server from SQL Server 2000 to SQL Server 2016 R2. However, while creating I am getting the below error when trying to create Linked server from SQL Server 2000.
TCP ...
0
votes
1
answer
253
views
SQL Server 2000 Database Monitoring
I have never worked on SQL Server 2000 and I got a requirement to check capture the following information to one particular database.
DBName CurrentDate SPID BatchDuration ApplicationName ...
- 345
0
votes
1
answer
469
views
How to resolve MDF and LDF files remaining in use?
I am attempting to copy off approximately 220 gigs of database MDF and LDF files from a MS SQL server 2000 install in order to transfer ownership to a third party.
The error I get when I try to stop ...
- 159
0
votes
1
answer
399
views
Best way to copy MS SQL (2000) database files to an external drive
We have a system running on Windows 2003, with a MS SQL server 2000 (Standard) instance as the data source. As we have sold the product, we are in the process of moving everything to the purchasing ...
- 159
3
votes
1
answer
126
views
Unable to Restore a Database to a previous point in time from a Full Backup Set
I have a full backup set (SQL server) and I am trying to restore the Database to a previous date and time. Every time I restore it (To another database) selecting a previous date that I want from the ...
- 31
0
votes
1
answer
334
views
SQL Server 2000 Hitting 8000 Byte Limit Exporting BLOB
I'm trying to help out my security by exporting user data from a legacy access system. The back end is SQL server 2000. The data I'm particularly interested in is the user photograph, which is stored ...
- 3
0
votes
1
answer
50
views
SQL Server upgrade advisor reserved keyword warning - Can't find keyword!
I am running SQL Server 2008 Upgrade Advisor tool on a SQL Server 2000 DB, and the final report shows an error:
Database Server,"PreUpgrade",
"After upgrade, new reserved keywords cannot be used ...
- 135
1
vote
1
answer
306
views
How do you delete an aliased user
I am trying to delete an aliased user from a sql server 2000 database that was restored to sql server 2008 r2. Originally, I was attempting to convert the aliased user to a regular user, but it does ...
- 213