Execresultset?

Demo please!

Why can't you hardcode the dbname in the script?

USE DbName

GO

IF EXISTS... DROP VIEW

GO

CREATE VIEW...

GO

Any other option will involve creating a file on the fly with the correct db name, directly...

Hmm, looks like the dynamic sql doesn't work in this context.

In which context do you need to run this script?

Check out Frank Kalis site.  He has done extensive testing on this subject and my memory seems to want to confirm that your memory is right

You can't dynamically change the in the connection like that.  You have to use dynamic sql (including the following code) to make this work.

If you need to run this cod...

Nice idea Steve, a trip in space would be a great space for any geek .

Definitly.  My idea will be the best approach in this context.

You can use fileexists as the best approach in the case where you only want to check if 1 file...

That one I like, except for the thrash part .

Edited 2007-07-06.

How about a free plane ticket for next year (or rebate, as the ticket prrice is drstically different from one person to the next)?

I'd do it the other way around.  List all files that are in the directory(ies) and send this into a table.  Then you can do a left join to find...

Not likely, but it would potentially avoid many others!

Thanks Steve.

2005.

Check out the link in the aswer for more details of all the version names of every MS products ever written.

Nice to know.  I'm glad we're finally moving to 2k5 here at my current client.  It's gonna be a lot of fun to master this new tool

Agreed, your ego is telling you to do this.  However your ego seems to be up to date with technology and it would be nice for the site to be...