Not sure if this will help you and Ive never tried it myself but atleast its something to look at:

sp_addlinkedserver [ @server = ] 'server'

...

check out my article ASP - Reaping the benefits of SQL 2000's FOR XML clause.

http://www.sqlservercentral.com/columnists/lplatt/article4_1.asp

Yes it is very possible and not too difficult to do what you have proposed.

A couple of notes:

1. the active X component that your are refering to is called...

can your in clause be expressed as a Sql statement or are the values derived from somewhere else?

I will play with this some when I get a chance. Unfortunately I don't have my sql server at home set up to support xml templates. Probably slacking a...

Is the COM module running in a sql job? If so try stoping the Sql Server Agent, upgrade the COM module then re-start Sql Server Agent

You could get the info from the versionString property of the SqlServer object

Visual Basic ? Results from my sql server:

? objSqlServer.VersionString

Microsoft SQL Server 7.00 - 7.00.623 (Intel X86)

...

Not that I know of. Before SQL2000 came out there was an ISAPI filter that ran on IIS server to provide the same functionality but I can't seem to...

You can accomplish it doing full joins.

Create this table and enter the following data:

CREATE TABLE [test1] (

[rowid] [int] IDENTITY (1, 1) NOT NULL ,

[student] [int] NOT NULL ,

[Qid] [char] (3)...

Sql works on sets of data. You can only retrieve what you ask for. Once the data is retrieved thats it, Sql server does not remember that you...

Sorry don't have any experience with updg yet but maybe you could run sql profiler and get a clue what is actually going on at the sql server side.

There is no way to run a shape command in TSQL. In order to use the shape language you need to go through ADO, that is why you need two...

select isnull(wildcard,product) from products p left outer join prod_lookup pl

on p.product like pl.wildcard+'%'

Table1 = products

Table2 = prod_lookup

Glad you got things working. Sorry about the comment problem. Thats what happens when you try to add comments as an after thought instead of doing it while...

Don't know why you would get that error. Just to verify please open an Ado connection and then print the version:

set dbConn=server.createobject("adodb.connection")

dbConn.Open "file Name=c:\code\cnLanWeb.udl" 'need to put your connection...