Thanks Adrian.

I think I'll use the same concept but use a bat file containing one line per osql call where the osql will execute the script.

cheers

Thanks Adrian but I wanted to avoid the route you suggest since the EM sometimes generates other informations like collation etc. which I'd prefer not to carry over.

Great article, thanks.

I think you should use a stored procedure for this and use xp_cmdshell to check existence of the file.

I'm trying something similar right now and it appears that xp_sendmail cannot...

Can I use a database project in Visual Studio 6.0?

You could try http://www.sqlserver-performance.com  http://www.sqlteam.com

May be you could try the following: Open a DOS window and do oSQL -L to get a list of servers. And then run osql -E -S -Q \"SELECT "@@version\"....

I think the BULK INSERT statement is a good substitute to bcp. You avoid teh use of xp_cmdshell and also you avoid the overhead of having each field around...