April 27, 2004 at 5:57 am
Hi all. Desperately need help for the following scenario:-
I am trying to produce XML documents from tables held on SQL Server 7.0. As the XML functionality is not available in SQL Server 7.0, I first installed the client components of SQL Server Developer 2000 on our local machines and then tried SQL Server 7.0 Standard editon - none of which worked (service pack 2 applied).
I am running Windoes XP Pro (Service Pack 1), Entreprise Manager version 8.0. When I run the statement SELECT @@VERSION from SQL QUERY ANALZER I get
"Microsoft SQL Server 7.00 - 7.00.623 (Intel X86)
Nov 27 1998 22:20:07
Copyright (c) 1988-1998 Microsoft Corporation
Standard Edition on Windows NT 4.0 (Build 1381: Service Pack 6)"
Below is an example of SQL that I tried in SQL Query Analyzer to retrieve XML. The 'FOR XML RAW' appears in blue - so it looks like it does acknowledge the command.
SELECT * FROM <tablename>
FOR XML RAW
Do I need some sort patch on SQL SERVER 7.0, or does the data need to reside on SQL SERVER 2000 as well?
Many thanks for any help.
April 28, 2004 at 8:30 am
Its ok. We've switched to SQL SERVER 2000. Problem solved.
Cheers
May 26, 2004 at 2:52 pm
You did the right thing. There is no xml features in 7.0.
2000 is the ticket.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply