please do not double post your issues.

I think Ctrl+Shift+Q is the best M$ have given us. Otherwise you can seem as if you are creating a view for you to have the 2000 style and then...

you can try instantiating the object in vb script and see if you get any errors there because I don't think the problem is with your sql installation.

try this site...

no i don't think there is.

you create your own UDF for that.

did you try running the script i put above?

i did have a problem with Outlook formating sometime back, but I can remember which setting I changed. I will trawl thru my brains. 🙂

your script works fine check the settings for your mail client. Which email client do you use?

what version of sql server did he install?

if you are using SQL 2005, why not try using a CLR assembly with EXTERNAL_ACCESS

but the one by JG should work. matser -> master

works with views only. right click on the View Folder Icon on your database and create new, that should enable the toolbar you want.

the query designer has got an Access...

I managed to run your proc without a problem.

for the account you are using check to see if you have permissions to instantiate the 'Scripting.FileSystemObject' library. run the statement below

DECLARE...

i did want to point out that you should check the security settings.sometimes SQl server will throw up errors masquarading as something else but yet they are security issues

can you give sample data and sample expected results.

i think IN {list} should do the trick unless if you did not specify your requirement fully.

Are you able to send any other file.

Are there any perculiar settings on your db server, that would help if i want to try to recreate your problem.

SQL Noob,

TRY this one , i have ammended your code a BIT. i have removed the temporary TABLE you were USING because it does NOT bring ANY benefits WITH it...