Linked Server Question

29 Sep 2005 7:41 PM

Mike Labosh

We have a dev server, HORSQL01 and a production server, HORSQL02

Each one is listed under the EM Linked Servers node of the other. But I am
confused. When I open up the Linked Servers\HorSql01 node, I don't see a
list of databases on HorSql01, I just see a tables node and a view node.

Can someone point me to some relevant explanation of this?

--
Peace & happy computing,

Mike Labosh, MCSD

"When you kill a man, you're a murderer.
Kill many, and you're a conqueror.
Kill them all and you're a god." -- Dave Mustane

29 Sep 2005 8:05 PM

Tony Sebion

Enterprise Manager will use the credentials specified within it to
connect to the other server. The list of tables you're seeing are the
tables of the default database of the login the linked server is
configured to use. This shouldn't prevent you from creating queries
that use the linked server, as long as the login passed through the
linked server has been granted the proper authority.

Good luck,
Tony Sebion

Show quote

"Mike Labosh" <mlab***@hotmail.com> wrote in message
news:esKpR3SxFHA.3000@TK2MSFTNGP12.phx.gbl:

> We have a dev server, HORSQL01 and a production server, HORSQL02
>
> Each one is listed under the EM Linked Servers node of the other. But I am
> confused. When I open up the Linked Servers\HorSql01 node, I don't see a
> list of databases on HorSql01, I just see a tables node and a view node.
>
> Can someone point me to some relevant explanation of this?
> --
> Peace & happy computing,
>
> Mike Labosh, MCSD
>
> "When you kill a man, you're a murderer.
> Kill many, and you're a conqueror.
> Kill them all and you're a god." -- Dave Mustane

29 Sep 2005 8:10 PM

Rick Sawtell

Show quote

"Mike Labosh" <mlab***@hotmail.com> wrote in message
news:esKpR3SxFHA.3000@TK2MSFTNGP12.phx.gbl...
> We have a dev server, HORSQL01 and a production server, HORSQL02
>
> Each one is listed under the EM Linked Servers node of the other. But I
> am confused. When I open up the Linked Servers\HorSql01 node, I don't see
> a list of databases on HorSql01, I just see a tables node and a view node.
>
> Can someone point me to some relevant explanation of this?
> --
> Peace & happy computing,
>
> Mike Labosh, MCSD
>
> "When you kill a man, you're a murderer.
> Kill many, and you're a conqueror.
> Kill them all and you're a god." -- Dave Mustane
>

Don't use SEM. <wink>

It is showing you the tables in the default database for your linked server.
You can specify a different database if you wish.

Your queries however will have no problem doing what they need to do.

SELECT col1, col2... FROM linkedServerName.database.owner.object

HTH

Rick Sawtell
MCT, MCSD, MCDBA

29 Sep 2005 8:15 PM

Hugo Kornelis

On Thu, 29 Sep 2005 15:41:50 -0400, Mike Labosh wrote:

>We have a dev server, HORSQL01 and a production server, HORSQL02
(snip)

Hi Mike,

(Thinking of some of your other posts here)

Are these abbreviations for "Horror-SQL 01" and "Horror-SQL 02"?

Best, Hugo

--

(Remove _NO_ and _SPAM_ to get my e-mail address)

29 Sep 2005 8:50 PM

Mike Labosh

> Hi Mike,
>
> (Thinking of some of your other posts here)
>
> Are these abbreviations for "Horror-SQL 01" and "Horror-SQL 02"?

Actually, I like to think of it as "Whore-SQL-01", etc.

Our facility is one of many in north america, and our facility is in a town
called "Horsham" so they prefix most of the internal servers with "HOR" --
but it's really funny how much sexual innuendo is involved in some of the
stuff here.

IIS Box = HorWeb01
HorSql01 has a database called "Slutsky" (the name of the guy who created
it. bummer)
On one of the network shares, there's an Access database for Analysis called
"anal.mdb"

Oh, it just goes on and on.

--
Peace & happy computing,

Mike Labosh, MCSD

"When you kill a man, you're a murderer.
Kill many, and you're a conqueror.
Kill them all and you're a god." -- Dave Mustane

Show quote

"Hugo Kornelis" <hugo@pe_NO_rFact.in_SPAM_fo> wrote in message
news:5pioj117l4uenplc7oill72rlrfv36uirf@4ax.com...
> On Thu, 29 Sep 2005 15:41:50 -0400, Mike Labosh wrote:
>
>>We have a dev server, HORSQL01 and a production server, HORSQL02
> (snip)
>
>
> Best, Hugo
> --
>
> (Remove _NO_ and _SPAM_ to get my e-mail address)