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