Great, Thanks. I was looking in HKLM\SYSTEM not HKLM\SOFTWARE.

WOW!!! Easy and wonderful. I did not look forward to trying to build something like this. Thanks to all that are responsible. This hit the ball right out of the...

for your pleasure and amusment, i have correctly identified my self in my avatar

i would lean toward DNS issues then

ping servername -a

it should say "Pinging servername.domainname.com......."

if DNS resoultion is working correctly.

Did you allow network access to the service as well?

DOH!!!!

syslogins is a view.....

I will paint an "L" on my forehaed for the rest of the day!!

Thanks for the input, if I execute this in QA

select [name] from master.dbo.sysobjects where type = 'S' order by [name]

I get

sysaltfiles

syscacheobjects

syscharsets

syscolumns

syscomments

sysconfigures

syscurconfigs

syscursorcolumns

syscursorrefs

syscursors

syscursortables

sysdatabases

sysdepends

sysdevices

sysfilegroups

sysfiles

sysfiles1

sysforeignkeys

sysfulltextcatalogs

sysfulltextnotify

sysindexes

sysindexkeys

syslanguages

syslockinfo

syslocks

sysmembers

sysmessages

sysobjects

sysperfinfo

syspermissions

sysprocesses

sysproperties

sysprotects

sysreferences

SYSREMOTE_CATALOGS

SYSREMOTE_COLUMN_PRIVILEGES

SYSREMOTE_COLUMNS

SYSREMOTE_FOREIGN_KEYS

SYSREMOTE_INDEXES

SYSREMOTE_PRIMARY_KEYS

SYSREMOTE_PROVIDER_TYPES

SYSREMOTE_SCHEMATA

SYSREMOTE_STATISTICS

SYSREMOTE_TABLE_PRIVILEGES

SYSREMOTE_TABLES

SYSREMOTE_VIEWS

sysservers

systypes

sysusers

sysxlogins

syslogins is not in the list???????

2003 machines need a config change to participate in distributed queries. look at my explination here.

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=165231

HTH

it may be the dcom config of the xp machine.

at the run prompt type "dcomcnfg"

go to component services, then to my computer

right click my computer and choose properties

click the MSDTC...

ty

DOH!!!! yes it does, it just took a little longer for osql to return a connection error that I tought it would. At least If ound a way to do what...

That doesnt work either. It still halts. I am running out of ideas. help

push come to shove I just realized that I can call xp_cmdshell and open a osql connection and dump the selection results to a temp table. Is there a more...

I just tried this too, didn't work.

begin

 select @fqinstancename = (select FQ_INSTANCE_NAME from MASTER_SQL where SQL_ID = @sqlid)

 select @sql = 'select [name] as [output] from [' + @fqinstancename + '].master.dbo.sysdatabases where...

I am not sure, but I will make a guess that IIS 5 is not processor aware (does not support multi threads). It might be worth a little research time to...