sql-server-7

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? ...

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 of connecting to SQL Server 7 does not exist. Does anyone know of any third party solutions...

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 hour (averaging the concurrent calls for each minute) within that hour (for each system). ...

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 know? Currently I'm mainly writing CRUD style queries, pretty much exclusively using Stored Procdur...

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 calling an order by on the data below, so why does the error say it cannot sort? SELECT...

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? ...

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 to perform the following business logic to return a single data set: Select the Clien...