Questions tagged [sql-server-2000]

SQL Server 2000 (major build version 8.00.xxxx). Please also tag sql-server.

Filter by
Sorted by
Tagged with
1
vote
0answers
23 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 ...
0
votes
0answers
34 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, ...
0
votes
2answers
21 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 ...
0
votes
0answers
26 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 ...
1
vote
1answer
36 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 ...
1
vote
0answers
73 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
0answers
9 views

Oracle DBLINK to SQL Server Cluster 2000 Fail when Database Failover to node-2

We have a DBLINK from Oracle database that connects to SQL Server Database version 2000 using SQL Authentication. Whenever the database that DBLINK uses failover to node-2 of the cluster (physical) it ...
0
votes
1answer
37 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 ...
0
votes
1answer
165 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 ...
0
votes
1answer
115 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 ...
3
votes
1answer
74 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 ...
0
votes
1answer
157 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 ...
0
votes
0answers
33 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 ...
1
vote
1answer
204 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 ...
1
vote
1answer
286 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
3answers
500 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
2
votes
1answer
1k 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
0answers
62 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 ...
0
votes
1answer
175 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(...
1
vote
1answer
86 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 ...
3
votes
2answers
1k 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 ...
0
votes
2answers
400 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? ...
1
vote
2answers
3k 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- ...
0
votes
1answer
73 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 ...
1
vote
1answer
350 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 ...
0
votes
1answer
79 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,...
2
votes
2answers
100 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 ...
1
vote
1answer
141 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 ...
1
vote
1answer
356 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
votes
3answers
3k 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 | ...
0
votes
1answer
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 ...
1
vote
1answer
856 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 ...
0
votes
1answer
2k 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 ...
0
votes
1answer
2k 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 ...
2
votes
3answers
5k 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 ...
6
votes
2answers
2k 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 ...
1
vote
1answer
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 ...
0
votes
2answers
3k 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....
1
vote
2answers
129 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 ...
0
votes
2answers
83 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 ...
2
votes
1answer
204 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
1answer
7k 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.
1
vote
0answers
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 ...
1
vote
1answer
25 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 + ...
2
votes
2answers
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 ...
2
votes
2answers
124 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
0answers
203 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. ...
1
vote
1answer
305 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 ...
1
vote
2answers
110 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?
4
votes
1answer
937 views

Get maximum, minimum values across columns

I want to get the minimum and maximum across multiple columns in a row. I found various working queries using CROSS APPLY, UPIVOT and VALUES, e.g. like this one: select column1, column2, code1, ...

1
2 3 4 5 6