Use Replication. Create a Publisher/Distributor on the central server, then set up transactional or merge subscriptions to the 4 satellites on a regular basis.

You are probably only seeing tables that your login has been granted access to. That is the most likely scenario. Are you able to open and use the Management...

You are probably only seeing tables that your login has been granted access to. That is the most likely scenario. Are you able to open and use the Management...

What user are you logging in as? SA?

Try NULL instead of DEFAULT.  DEFAULT is a keyword that is not in context for this use.  Generally, DEFAULT is NULL as far as SP/UDF parameters go; you can supply...

Are you getting back one record? Or 1000?  If you are getting 1000, I would tend to agree with JackSteezo - Otherwise, please post your entire t-sql statement for us...

You are absolutely correct about undocs - And I have even heard it coming out of my mouth.  It must have been a moment of weakness at some point...

I think that the easiest way to do this would be to create a view in DB1 that exposes the table in DB2 and then construct the query from DB1...

I can tell you exactly what security problems you could encounter:

EXEC @hr = sp_OACreate 'Scripting.FileSystemObject', @toNewObject OUT

Use your imagination for ideas on how anyone who gets access to the oa...

wz700 - Thanks for the hint - I followed up on your suggestion: Check on sp_helptext [information_schema.tables] to find it out.

As with my direct select attempt, it works fine on...

No, it isn't, but that was a good thought - this works on every other db I have - I'm beginning to think this is an anomoly, but if anyone...

We do it something like this:

create procedure yadayada

(...

...

@pVersion char(2) = NULL) 

AS

declare @lVersion numeric(10,2)

SELECT @lVersion=1.01

IF (UPPER(COALESCE(@pVersion,'')) = '-V')

begin

SELECT @lVersion as [SPVersion]

return

end

...

return

 This helps us determine within the app if we...

This has bit me recently as well.  I have decided that the simple solution is to stop using * and list out the columns - it makes it larger and...

I have used the sp_OA procedures to create and use instances of the File System Object found in scrrun.dll, but these are fraught with security implications and take a lot...

You did not spend one too many thoughts - This one was poorly worded and incorrect. My first instinct was was nocheck, but the *temporary* word is the key.

<RANT>...