Ok.. forget I even mentioned one is on 2000 and the other on 2005.

I can have both on 2000, that's barely even an issue.

I executed instcat.sql.... no difference.

Let me get...

On my local server, yes.. but on the remote one, I wouldn't be able to check, right?

EDIT:

I found some info here:

http://www.alagad.com/go/blog-entry/one-solution-to-this-error-sql-server-does-not-exist-or-access-denied

But this seems to be a resolution for SQL Server...

SELECT a.*

FROM OPENROWSET('SQLOLEDB','xxx.xxx.x.xx';'sa';'sa',

'SELECT *

FROM DService.dbo.device') AS a;

Error:

Msg 17, Level 16, State 1, Line 2

[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist...

I tried using openrowset. Do I need permissions for that too?

I executed the following query on the remote server with IP of my local server in place of xxx.xxx.x.xx :

SELECT...

Should I be posting this in 'administration' now?

Please help, people!

I need to send a request to the client to grant me necessary permissions. So what exactly is it that I...

Ok I figured out what my problem was!

I mentioned only the IP Address rather than IP\instance name

and then I did the following:

LinkedServer>> Properties>> Server Options >> Use Remote Collation >>...

That would be like Device ID + Image_Surr_Key?

That's not going to work either.

Lets take an example:

Today

Device1 pushed 5...

Thanks a ton, guys!

What I was trying to do was -

I had been given the task to compare three systems (similar working but 3 versions for 3 diff clients)...

but that doesn't show me the result in table format, chirag!

I can see it only delimited my spaces.. although I chose column aligned in query options!

Now that you have all your tables in place, why not simply 'Import Data' using the Import/Export Wizard... very convenient and has always worked for me 😎 :hehe:

That's perfect, Gail. That's exactly what I've done. Its only after I pasted the code here that I realized there was nothing in it except for update/insert into a single...

I know this does look messy but now since I've been asked to look into it,

I was wondering whether I should just leave it as it is and introduce...

Ok this is the exact scenario:

I have a staging table for Ads. It stores Ad_ID, Description, etc.

We have an SP that imports these Ads from the staging table into our...

With DB set to compatibility level 90, which uid_design am I ordering by here..... because this works:

SELECT DISTINCT uid_design AS U1, uid_design AS U2

FROM Ad_Master_Import

ORDER BY uid_design

Gail, do you mean the syntax is incorrect in SS 2k5?