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
|

BUG in SQL Server Manager - Default Schema

Hallo,
June CTP of SQL Server 2005 (NOT SQL Express)
########
Everything deleted from this post by Alle since it has no relevance to the RTM.
Unfortunately I can not delete the thread.
###########
Alle

There is now an invisible comment that has been added by a moderator (I hate that too, why isn't the comment / edit visible in the thread?) :

=== Edited by Paul Mestemaker - MSFT @. 28 Oct 2006 1:59 AM UTC===
This is a comment not a question. This bug has been fixed.

Paul,

you are absolutely right, it was fixed ages ago and in addition we are well over the CTP stage of SQL Server 2005 which was RTM one year ago.

Wouldn't it make much more sense to delete this entire thread since it now longer has ANY revelance?

I can't although I am the author (I tried).

Thanks,
Alle

BUG in SQL Server Manager - Default Schema

Hallo,
June CTP of SQL Server 2005 (NOT SQL Express)
########
Everything deleted from this post by Alle since it has no relevance to the RTM.
Unfortunately I can not delete the thread.
###########
Alle

There is now an invisible comment that has been added by a moderator (I hate that too, why isn't the comment / edit visible in the thread?) :

=== Edited by Paul Mestemaker - MSFT @. 28 Oct 2006 1:59 AM UTC===
This is a comment not a question. This bug has been fixed.

Paul,

you are absolutely right, it was fixed ages ago and in addition we are well over the CTP stage of SQL Server 2005 which was RTM one year ago.

Wouldn't it make much more sense to delete this entire thread since it now longer has ANY revelance?

I can't although I am the author (I tried).

Thanks,
Alle