thanks but this  givesa  slightly different  result than expected.i need same as in my initial post. i guess i need to tweak the query to do that.

But how can you have this as an int column when you ahve data as 2.1.1.2 and so on...any further hint please??

Yeah thats what i thought so . you are right snapshot works fine in such a situation. is it possible to have a snapshot replication for one article and a...

Thanks Noel. Another way of doing it. Appreciate your help...

Noel,

Finally i got it working. was afault from my end only. I had an extra space between UID and <userid> it should have been UID=<userid> and i had as UID= <userid> ...

You are right But in the sql there is a statement "FILEPROPERTY ( a.name, ''SpaceUsed'' ) * 8 AS UsedSpace  from DBName.dbo.sysfiles a "which basically should look thru the spaceused...

Thanks Noel. Really appreciate that. Let me make it more clear. Problem comes in executing MSDASQL as thats when i get the error. I tried using SQLOLEDB and it works...

Does anyone have a better idea or solution for this...

Yes thats right. I want to run this query on all servers and i have all these set up as linked server from my local PC.

Thanks that helped. even this gave me the answer.

select SUSER_sNAME(owner_sid),name from sysjobs

Sorry but i am trying for a user with sa rights which should work theoretically. any other thoughts??

Where i should be getting something > 0 i get all as NULL values

Not sure how do i check for this

Your SQL Server's service account is using a domain account (with access to the target servers in the OPENROWSET).  The service account can...

I checked the registry and all looks fine. I now tried using SQLOLEDB

SELECT a.*  FROM OPENROWSET( 'SQLOLEDB', 'dbname' ,'select * from dba.dbo.ServerTypes')AS a

and the error shows up as

Server: Msg...

Also when using SQLOLEDB I am now getting

Server: Msg 7399, Level 16, State 1, Line 1

OLE DB provider 'SQLOLEDB' reported an error. 

[OLE/DB provider returned message: Invalid connection string attribute]

OLE...