I think if you buy InstallShield they provide updated merge modules with the product. Worth checking. Hard to believe they don't make the merge modules generally available.

Andy

I dont have a Win95 machine to test on, but MDAC 2.6 is correct. You can still do it with earlier MDAC's but you have to configure an alias -...

Did you look at the query plan? Maybe doing parallel processing if you have multi cpu?

Andy

Not really. You probably have one or more char/varchar columns, try converting the largest one to text. Unless you have a very few rows you're better off trying to cut...

No, you cant pass it as a string. You could guess at the max number of parameters you want to test and have that may inputs to your proc. Another...

You might try adding a computed column that is based on the convert and index it.

Andy

We dont mind trying to assist with the theory part anyway, sometimes you'll be better off visiting a VB specific site. You can bind the grid to a recordset at...

Its not showing up in the pick list, or you cant even enter it as get it work that way?

Andy

I think CDATA will work.

Andy

Not sure. I'd say two possibilities. One is that something is weird on the one machine, the other is that maybe it can't send the request across a subnet to...

Not bad. I'd suggest you use Scope_Identity() rather than @@Identity though.

Andy

For XML requires a table name in a from clause. You can work around by doing something like this:

create table Test2 (id int identity(1,1))

insert into test2 default values

select @@identity as...

Please don't cross post - we check all the topics daily. See this thread:

http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=3918&FORUM_ID=21&CAT_ID=2&Topic_Title=ID+Field&Forum_Title=XML

Andy

Could you post your select?

Andy

Dont see how you're going to gain much, any gain would be in client side prep if anything. Be interesting to see.

Andy