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
421
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
150
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
73
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
49
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
23
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
33
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
823
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
339
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
164
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 ...
- 195
0
votes
1
answer
280
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
285
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
98
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
265
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
43
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
258
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
1
vote
1
answer
472
views
Should SQL Server 2000 throw an error if update statement fails within a SP?
I'm troubleshooting an issue on SQL Server 2000 where it appears that a update statement in a stored procedure failed, and the check for @@ERROR <> 0 didn't catch it, so the transaction was ...
0
votes
3
answers
603
views
Migrating SQL Server 2000 to 2008/14 - Stored procedures compatibility?
I am planning migration from old SQL server 2000 db to 2014 (through 2008 extra step). I Wonder if stored procedures will work with no tweaks or arrangements are required
- 135
2
votes
1
answer
2k
views
How can I email query results formatted in html from MSSQL 2000 server?
The only system SP I have is master.dbo.xp_smtp_sendmail and I can't make it work (or I just don't know how). I cannot upgrade the DB at this time. I'm trying something like this:
@body_text=N'...
1
vote
0
answers
68
views
Migration to version 2016 from versions 2000, 2005, 2008, and 2012 [duplicate]
I just accepted a position that has multiple versions of SQL Server, from what I was told during my interview, it ranges from versions 2000 - 2012, the main goal is to centralized these databases to ...
- 79
0
votes
1
answer
325
views
how to get total count of partial counts
An extension to this Question here, how can I fetch the count for ALL the students who have reached their maximum allowed absents.
I tried this
SELECT COUNT(*) FROM
(
SELECT student_id,
COUNT(...
- 237
1
vote
1
answer
219
views
conversion of a non correlated sub query to a join statement
Is it possible to get rid of the sub query and convert the entire query into a JOIN query?
SELECT student_id,
COUNT(attendance)
FROM student_attendance
WHERE attendance = 'ABSENT'
GROUP BY ...
- 237
3
votes
2
answers
2k
views
I have a database backup (.bak) from SQL Server v7, how do I convert it for load into v10?
A client has given me a backup (.bak) from a SQL Server v 7 database. I am trying to load it into version 10 which is incompatible. Are there any tools that will restore or prepare an old version ...
- 133
0
votes
2
answers
637
views
how to edit and migrate DTS package on SQL server 2000
I currently have an old SQL server 2000, with some DTS packages in system database msdb, table msdbsysdtspackages.
I need to migrate those packages to sql server 2016, is there a tool I can do that?
...
- 65
1
vote
2
answers
4k
views
Problems with insert trigger and primary key
I'm dealing with a 3rd party app that I can't change or get support on. I've altered an underlying table in several ways to enhance it's functionality
1- I renamed the table PRE_CASE to PRE_TCASE
2- ...
- 1,453
0
votes
1
answer
108
views
Query Output Window not honoring fixed length
Query below has fixed length values for data set being returned in a string, now the problem is that fixed lengths are not being honored in the query results. But the output text file produced by DB ...
- 171
1
vote
1
answer
484
views
Defining multiple fields in a select string with hard set length values (SQL 2000)
Currently I have been tasked to modify a super old stored procedure that represents an email output in our SQL 2000 instance. With correcting a few syntax issues I wanted the original string format to ...
- 171
0
votes
1
answer
145
views
check for dependencies on other servers in SQL server 2000
I have an old server running SQL Server 2000.
I need to perform some maintenance on the server and one step is to check for dependencies on other servers.
The SQL Server 2000 machine has database A,...
- 65
2
votes
2
answers
117
views
Prevent T-SQL code that is not compatible to break the script
Here is an interesting challenge that I have not been able to crack... There is one nice T-SQL query that I Jonathan Kehayias created some time ago to find Implicit Conversions issues on the queries ...
- 773
1
vote
1
answer
177
views
How to retrieve subtotal for order lines (rollup does not exist in sql 2000)
Currently in a crystal report I have each order grouped together where the user is displayed the order lines in the orders group. I have made a running total field for a subtotal for all of the order ...
- 171
1
vote
1
answer
427
views
Modern SQL Profiler against SQL 2000
In my current work position I've been given a desktop with SQL2014 tools installed including SQL Profiler. For some time we are still however supporting production SQL2000 machines and when using ...
- 1,453
-1
votes
3
answers
7k
views
Return next row that meets condition
I can't find a solution to the following problem.
Assuming I have 2 tables:
Table 1:
Name | Age
Nick | 52
Adam | 52
Monica | 40
Table 2:
Name | ...
- 1
0
votes
1
answer
2k
views
Microsoft SQL Server 2008+ TIMESTAMP problem
I'm currently facing a Problem, where the SQL Server refuses my Timestamps.
I am accessing the Server via EclipseLink (Java) but this shall not be the problem, as i can test the queries on the Server ...
- 445
1
vote
1
answer
2k
views
Converting a Crystal Report Formula to a CASE expression
With attempting to convert a crystal report formula into a SQL CASE expression, I seem to be having trouble understanding the concept of "total_pallet_weight" and "order_no" utilizing the "AND" in the ...
- 171
1
vote
1
answer
5k
views
SQL - Passing a Stored Procedure Variable as a Parameter in a crystal report for end users to select
OK I know there are hundreds of posts out there that state how to pass a parameter from a stored procedure to a crystal report. But unfortunately with some research I haven't come across a specific ...
- 171
0
votes
1
answer
3k
views
Removing duplicate results via subqueries in reference to join conditions for multiple tables
With the code below I was originally attempting to not use sub queries to eliminate "duplicate data" (its technically not duplicate data since each order has several lines of data where prices and ...
- 171
2
votes
3
answers
7k
views
Combining multiple query result sets that share common columns into one specified temp table
Currently I am trying to combine three views into one stored procedure for a report. At first I started off using joins for the common data fields but found one of the tables, XFER, had data that was ...
- 171
6
votes
2
answers
3k
views
SQL Server 2000 - Stripping time from datetime column results using DATEADD and DATEDIFF is returning result with time still?
I know there are several posts about stripping the time portion from a datetime column. And everyone suggests that the DATEADD and DATEDIFF method is the best for performance and individuals should ...
- 171
1
vote
1
answer
5k
views
SQL Server 2000 Declaring DateTime Variable to retrieve results based on current date. But receiving no results based off conversion
Currently I am wanting to test my new code with declaring a variable to have a set value with regards to returning results based off the current date from the field "DateShipped". But from researching ...
- 171
0
votes
2
answers
4k
views
Update statement with "case syntax" is unable to update a specific column in temp table
With reviewing a stored procedure for a current SSRS migration. I noticed the case syntax listed below for the temp table (#tempShip) is not taking affect for the column "ord_status" in the temp table....
- 171
1
vote
2
answers
245
views
Referencing a stored procedure by a name description across all databases in a SQL Server 2000 Instance
Does anyone have a valid method in referencing system information to search for a stored procedure across all databases in a SQL Server 2000 instance? I am currently tasked with migrating crystal ...
- 171
0
votes
2
answers
90
views
Index issue on upgrade from SQL Server 2000 to 2012
About 6 months ago, we upgraded a large .NET project from SQL server 2000 to 2012. (i know it's 2 versions behind already, don't get me started!)
One of the stored procedures ran a query in the ...
- 229
2
votes
1
answer
227
views
SSRS 2016 Datasource - SQL Server 2000 database
Looking to upgrade SSRS from 2008R2 to 2016.
Can SQL Server 2000 databases be used as data source in SSRS 2016? And are there any other known issues that could come up with the migration?
2
votes
1
answer
8k
views
how to install SQL 2000 in windows server 2016 OS
how to install SQL 2000 in windows server 2016 OS, Is it possible ,please give me a solution.
- 21
1
vote
0
answers
25
views
How can I do a Reorganize Index Task on SQL Server 2000 using a script? [duplicate]
I have a Server that is running SQL Server 2000 and I need to add a Reorganize Index Task. I haven't been able to find a way to create a Maintenance Plan so I am performing maintenance tasks using ...
- 111
1
vote
1
answer
29
views
ODBC Curtime() after migration from 2000 to 2012 omits datepart
A client migrated a db from SQL Server 2000 to 2012.
Their application runs into trouble afterwards. The cause is the following function invocation:
SELECT {fn curtime() }
Which returned date + ...
- 833
2
votes
2
answers
4k
views
MS SQL Server 2000 ODBC driver for Linux
Microsoft has official ODBC drivers for MS SQL Server, for Linux. Great! Nice installation instructions for all the major distros, too.
Unfortunately, their ODBC drivers, going back to the oldest ...
- 121
2
votes
2
answers
145
views
Error while trying to export logins from SQL Server 2000 to SQL Server 2005
I'm trying to migrate logins from an instance in SQL 2000 to a destination instance in SQL 2005.
I've used revlogin before as explained here:
https://support.microsoft.com/en-us/kb/246133
(I'm ...
2
votes
0
answers
227
views
SQL Server 2008R2 Linked Server to SQL Server 2000 showing incorrect server
I have 2 servers and 4 instances
Server 1 (SQL Server 2008R2) has instance a,b,c
Server 2 (SQL Server 2000) has instance d
I created a linked server from server 1 instance c to server 2 instance d. ...
- 121
1
vote
1
answer
496
views
Display columns as one row
I've got a query running on SQL Server 2000 (and using SQL Server Management Studio 10.x)
It results in three columns with multiple rows.
What I am trying to do, and can't get my head round, is to ...
- 21
1
vote
2
answers
115
views
Breaking database replication
I am trying to break replication between two SQL 2000 databases. Can this be done while the databases are live? or do they need to be taken offline?
- 11