bug of synonym ?

hi
the clause :
EXEC mySy
works when i create the synonym by :
create synonym mySy for [database].[schema].[storedProc]
but fails when i create it by :
create synonym mySy for [SERVER_NAME].[database].[schema].[storedProc]
anybody knows WHY ? ?
THANKS
--
atte,
Hernánif the object pointed by the synonym is a table
i get no errors
atte,
Hernán
"bajopalabra" <bajopalabra@.hotmail.com> escribió en el mensaje
news:ek7aEd30GHA.2036@.TK2MSFTNGP05.phx.gbl...
| hi
| the clause :
|
| EXEC mySy
|
| works when i create the synonym by :
| create synonym mySy for [database].[schema].[storedProc]
|
| but fails when i create it by :
| create synonym mySy for [SERVER_NAME].[database].[schema].[storedProc]
|
| anybody knows WHY ? ?
|
| THANKS
|
| --
| atte,
| Hernán
|
||||I just ran a few create synonyms pointing to stored
procedures, used the for ServerName.DB.Schema.StoredProc and
they all run fine, didn't have any problems.
When you say it fails when you execute it, what is the
specific error message you get?
Can you provide any steps to reproduce this - just something
like a basic stored proc selecting from sys.databases or
something?
-Sue
On Fri, 8 Sep 2006 15:50:47 -0300, "bajopalabra"
<bajopalabra@.hotmail.com> wrote:
>hi
>the clause :
>EXEC mySy
>works when i create the synonym by :
>create synonym mySy for [database].[schema].[storedProc]
>but fails when i create it by :
>create synonym mySy for [SERVER_NAME].[database].[schema].[storedProc]
>anybody knows WHY ? ?
>THANKS|||i begin to prepare one example
at this moment
THANKS
--
atte,
Hernán
"Sue Hoegemeier" <Sue_H@.nomail.please> escribió en el mensaje
news:r8n3g2pnn28df5hekmlmfagce49199t9i2@.4ax.com...
| I just ran a few create synonyms pointing to stored
| procedures, used the for ServerName.DB.Schema.StoredProc and
| they all run fine, didn't have any problems.
| When you say it fails when you execute it, what is the
| specific error message you get?
| Can you provide any steps to reproduce this - just something
| like a basic stored proc selecting from sys.databases or
| something?
|
| -Sue
|
| On Fri, 8 Sep 2006 15:50:47 -0300, "bajopalabra"
| <bajopalabra@.hotmail.com> wrote:
|
| >hi
| >the clause :
| >
| >EXEC mySy
| >
| >works when i create the synonym by :
| >create synonym mySy for [database].[schema].[storedProc]
| >
| >but fails when i create it by :
| >create synonym mySy for [SERVER_NAME].[database].[schema].[storedProc]
| >
| >anybody knows WHY ? ?
| >
| >THANKS
|