not natively in SQL server; there's no implicit conversion funcitons in SQL for images.

you have to farm it out to a .NET object for example, convert it, and then put...

there are a lot of script contributions that do decimal to hex and hex to decimal for example, but non of them have the exact format you are looking for;

take...

I agree with Colin; Server does not exist or Access Denied.  is typically the application cannot connect, and has nothing to do witht he number of allowed connections.  A different...

because spids that are below 50 are system processes, i usually use this for the rough guestimate:

select count(*) from master.dbo.sysprocesses where spid >=50

did you create a program called HTTP.exe?

that is the error you are getting.

maybe it does exist, but it's not in the path of the server when it's run?

maybe something like...

I hope this helps:

open profiler( Start>>Run>>Profiler)

File>>New>>Trace Template

Add all the Events, Data Columns and Filters you want to capture.

Save the Trace Template.

Test the template by doing Start>>Run>>Profiler.exe C:\PathToTemplate\YourTrace.tdf

if it seems...

i think something like this, which does it all in one fell swoop, is what you are after:

there are three virtual tables, x1,x2,x3, which are really the big select statements...

ok, I see the issue is that you need an inet control to read a web page....no problem...so i built a dll in vb6 with just one public method.

a .vbs...

you are right...i get the same results...it runs to completion and returns null.

what are you expecting to get back, though? you don't expect it to return the html as results...

to run a vbs file dont you need xp_cmdshell 'wscript.exe c:\Name.vbs' as the command?

function not supported by sql 2000....so you'll write your own function...um...that is also not supported?

I think you mean simply not explicitly written by microsoft...technically all stored procs, functions, views, or...

curses on cursors! I am appropriately humbled. Thanks for putting me back on the path of enlightenment, Robert; I just couldn't "see" the subselect; nice solution.

eek I'm gonna say the words " only a cursor can solve this"; while I know cursor is the antithesis to all things SSC, sometimes you have to use the...

i'm assuming the procedures return the same number of rows? or it's the same proc with different paramters, or that they return a single value?

Hopefully this will get you started...

more than one way to do it, and lots of quick answers; that's why i love this site.