The Stack Overflow podcast is back! Listen to an interview with our new CEO.

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
0
votes
1answer
44 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
26 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
47 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
103 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
363 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
415 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
49 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
67 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
55 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
463 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
254 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
2k 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
35 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
237 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
53 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
94 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
132 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
259 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
659 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
1k 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
275 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
920 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
1k 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
2k 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 ...
5
votes
2answers
1k 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
3k 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
2k 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
61 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
81 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
179 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
4k 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
22 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
23 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
2k 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
93 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
178 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
101 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
104 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
407 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, ...
0
votes
1answer
136 views

Query slowness after migration from sql server 2000 to 2014

I'm not a DBA. I have two servers. One of them runs on sql server 2000, the other on sql server 2014. Both have almost identical hardware (2014 has more RAM). My job is to migrate all databases and ...
2
votes
2answers
48 views

Generating Backups of Databases

I would like to create a backup of four databases on one SQL Server 2000 instance at the exact same moment in time. How can I achieve it? Creating different jobs with the same schedule date and ...
0
votes
1answer
95 views

How to change SQL Server in a domain with a new server machine and latest SQL database? [closed]

We have an SQL Server in our domain. The SQL Server version is MS SQL 2000 and the Operating System is Windows Server 2003. Now I want to change the machine itself with new computer running windows ...
1
vote
3answers
195 views

Dynamic Server Name in SQL Statements (from clause)

My scenario is I have a thick client side app using a SQL DB. The use of the app is divided into 10 "sites" mostly by Geography but some by Usage. I've written an SP to archive selected data out of ...
4
votes
2answers
241 views

Will a DBCC CHECKDB with repair have to rescan?

I've run a DBCC CHECKDB and it found allocation errors. When I run it with REPAIR_ALLOW_DATA_LOSS - will it need to take the same amount of time to scan for errors, or will it attempt to use the last ...
1
vote
1answer
135 views

Splitting a large table

My scenario is I look after an old system with a VB6 based front end and a SQL back end (good news, the replacement is being developed but in the meantime I need to keep this up). Now the application ...
0
votes
1answer
2k views

Querying a date range

i query this SQL query: SELECT * FROM [DB].[dbo].[Table] WHERE [DATE] BETWEEN '01-01-2016' AND '31-03-2016' AND ([TIME] >= '00:00:00' OR [DATE] > '01-01-2016') AND ([TIME] <= '00:00:00' OR [...
0
votes
1answer
387 views

How can I do a SQL Server 2000 bak?

I have 2 databases .mdf SQL Server 2000, and I need to restore them on SQL Server 2014. After some research, I saw that the best approach is making a .bak of this 2 files. Well, I need to install SQL ...
1
vote
0answers
77 views

full-text search 7608 (0x80004005) error message debug

Someone tries to run the following line : exec sp_fulltext_column 'tbElementFullTextMvCustomProperty5', 'EMVCP_E_NAME', 'add', 0, NULL and then receives the following error : (1 row(s) affected) (...
1
vote
2answers
1k views

Converting old SQL 2000 Non-Ansi code to SQL 2012 compatible

We have a legacy application that is only used for a read only reference. It is using SQL Server 2000. We want to migrate its database to SQL version 2012, however we can't upgrade the software and ...
1
vote
2answers
207 views

Migrating master databases between clusters by detaching/attaching them

As a migration strategy is it possible or feasible to detach a master database in a Microsoft SQL Server cluster and then attaching a different master database's files from another cluster? The goal ...