Would this give some ideas ? http://www.sommarskog.se/dynamic_sql.html

Aargh, there was a QOD on this topic.

IIRC, I think you're right, but it wouldn't hurt to search the QOD archive.

Thomas,

yes, I have intentionally installed the updated english version (I don't understand the technical terms that are translated into german anymore)

As for easy checking:

On the start page of BOL is...

You mean SQL80EN.chw ?

That one is dated 01/20/2004 and about 5.3 MB in size

I have the german edition of BOL installed in this ..\80\ dir and the english version in the \1033 dir.

Just took a look at the directory. There should be a lot of files modified on 11/21/2003.

Sorry, actually don't try the link above. Copy and paste seems to be harder than I thought

Dave,

when you start BOL and click on the ©1988-2004 Microsoft Corporation. All Rights Reserved. at thebottom of the start page, which Version number do you see there?

©1988-2004 Microsoft Corporation. All...

No, but I doubt that there will be a difference.

Can't you run the DTS package I've mentioned above?

To add to myself, as IE *requires* user interaction it will appear to hang and wait for response, thus not giving back control to you when using xp_cmdshell.

Why does it...

Hm, I don't know much about DTS, but I've just tried to create a local package with a Execute win32 task with your page as parameter.

It worked.

Just a thought

xp_cmdshell and the sp_oa* procedures are executed on the server, while the vb app is running on your workstation.

Did you have a look at the server? Is...

Aah, now it's working.

Looks interesting. Too much free time today?

I like these emoticons

I get this error

Server: Nachr.-Nr. 170, Schweregrad 15, Status 1, Zeile 20

Zeile 20: Falsche Syntax in der Nähe von '*'.

which translates to

Line 20: Wrong syntax near '*'

What I even like more in Erlands' article is the section about common cases and their workaround without advising to use dynamic sql. Sometimes these workarounds are amazingly trivial.