Stack Overflow
Stack Overflow

Questions tagged [sql-server-7]

Use this tag for questions specific to the 7.0 version of Microsoft's SQL Server.

18 questions
11
votes
6 answers

How can I check for average concurrent events in a SQL table based on the date, time and duration of the events?

I have a set of call detail records, and from those records, I'm supposed to determine the average concurrent active calls per system, per hour (at a precision of one minute). If I query 7pm to 8pm, I should see the average concurrent calls for the…
scottm
  • 27,829
  • 22
  • 107
  • 159
4
votes
2 answers

Is it possible to restore a SQL 7 DB to SQL 2008?

I have an old SQL 7 DB .bak file I am trying to work with now. I tried to restore the backup in SQL 2008, but it said that it was unable to work with the file. Does anyone know how I could restore this DB?
Noah
  • 728
  • 13
  • 28
3
votes
1 answer

Hamming distance in ancient Microsoft DBMS

The Problem I want to find image duplicates and similar images in MS SQL Server 7. Edit I got it running using sql cursors - it's slow but it works, thanks again for the comment. See my answer for the solution I came up with. Specifically ... I…
mfeineis
  • 2,607
  • 19
  • 22
3
votes
1 answer

How to Restore a old Backup from SQL Server 7 SP4 to newest SQL Server versions?

I'm trying to restore an very old code of mine, in that time the database was ms access and then I upgraded to SQL Server 7 SP4, now I want to restore those old backup, but SQL Server 2014 does not allow this.. So I would like to know how can I get…
Artemination
  • 703
  • 2
  • 10
  • 30
1
vote
2 answers

JDBC driver for SQL Server 7.0?

I need to retrieve datas from the SQL Server 7.0 through java. I have tried the following drivers msbase.jar mssqlserver.jar msutil.jar sqljdbc.jar sqljdbc4.jar These jars works fine for the SQL Server versions 2000 and above, but for the version…
harishtps
  • 1,439
  • 7
  • 20
  • 35
1
vote
2 answers

Help with a complex self referency query accross multiple colums

I am having difficulties with a complicated (for me any way) query. The table I'm querying has 3 colums, ClientID (int Not Null), ProductID (int Not Null) and ExpiryDate (smalldatetime nullable) Given two client ID's Master and Consolidated I need…
Jon P
  • 19,442
  • 8
  • 49
  • 72
1
vote
5 answers

SQL Server Error: Cannot sort a row of size x, which is greater than the allowable maximum of 8094. But I'm not sorting

I understand that the "Cannot sort a row of size 9754, which is greater than the allowable maximum of 8094." from SQL server is caused by a row that has over 9k characters in it, which is greater than the page size limit in SQL Server 7. But I'm not…
Cory House
  • 14,235
  • 13
  • 70
  • 87
1
vote
6 answers

Migrating From SQL Server Server 7 To 2005, What should I get excited about?

The company I work for has decided to join the 21st century and upgrade our main database cluster from SQL Server 7 to SQL Server 2005. As a web developer what new whiz-bang features of SQL Server 2005 should I get excited about or get to…
Jon P
  • 19,442
  • 8
  • 49
  • 72
0
votes
1 answer

Is there any mechanism to connect to sql server 7 from visual studio 2008?

We are currently moving our SQL Server 7 based database to SQL Server 2000 (Yeah progress) However in the mean time we have to support our SQL Server 7 database product. We currently have access to Visual Studio 2008 and I know that native support…
Sean
  • 517
  • 4
  • 11
  • 34
0
votes
1 answer

best way to import data from SQL Server 7.0 to 2005

I have a table in a SQL Server 7.0 database with columns like: Column_1 varchar(10) null Column_2 int null Column_3 varchar(15) null Column_4 float(53) null Column_5 float(53) null Column_6 …
RacerX
  • 2,566
  • 3
  • 23
  • 21
0
votes
0 answers

Data sync from different SQL Server versions databases

So I have an SQL Server 7.0 database that must not be upgraded, it only gets data read and written in it, and I created an SQL Server 2008 R2 database which is the same structure, I want to synchronize the data between both, so whatever addition,…
Mohamedali Hamdi
  • 5
  • 7
0
votes
1 answer

Speeding up partitioning query on ancient SQL Server version

The Setup I've got performance and conceptional problems with getting a query right on SQL Server 7 running on a dual core 2GHz + 2GB RAM machine - no chance of getting that out of the way, as you might expect :-/. The Situation I'm working with a…
mfeineis
  • 2,607
  • 19
  • 22
0
votes
2 answers

Error updating using SqlCommand

Error executing the code, I am using C# & SQL Server 7 / 2000. Steps I am doing are: get all the tickets then I read each ticket pass to web service method for validation if the return is true I need to update a table. Please review my code,…
Benk
  • 1,284
  • 6
  • 33
  • 64
0
votes
2 answers

Is there any ORM tool for sql server 7.0?

I have a sql server 7.0 database and I will implement a web service above it. How do I access the data without writing any sql query?
Sessiz Saat
  • 1,079
  • 8
  • 20
-1
votes
2 answers

SQLServer7 + VB6 EXE File does not run on Win7

How can I use my old VB6 customized SQLServer database application in Windows 7? I can not upgrade my old VB6 EXE file.
S. Rahman
  • 1
1
2