bug of "synonym" ??

• keyser soze-308506

  SSChasing Mays

  Points: 630

  More actions

  September 8, 2006 at 1:35 pm

  #367317

  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]

  when the pointed object is a table, there is no problem ( both ways )

  anybody knows WHY  ? ???

  THANKS

  --

  atte,

  Hernán

• Gopi Muluka

  SSCarpal Tunnel

  Points: 4594

  More actions

  September 8, 2006 at 2:39 pm

  #659461

  Four-part names for function base objects are not supported in Creation of Synonymns

  -- BOL

   

   

• keyser soze-308506

  SSChasing Mays

  Points: 630

  More actions

  September 8, 2006 at 3:31 pm

  #659471

  thanks gopi,

  but,

  if i right click the synonym

  then "Include as" and then "CREATE To"

  the script that i get

  contains a "four-part names"

  

• Gopi Muluka

  SSCarpal Tunnel

  Points: 4594

  More actions

  September 8, 2006 at 3:42 pm

  #659474

  But I am able to create a synonym for a SP and successfully executed that SP using synonym in SQL 2005

  CREATE

  SYNONYM [dbo].[SynTest]

  FOR

  [W-IKCRH5C3\GOPINATH].[GOPI_LAB].[dbo].[sp_User_Indexes]

• keyser soze-308506

  SSChasing Mays

  Points: 630

  More actions

  September 12, 2006 at 8:03 am

  #659880

  the problem is when i [exec synonym_to_sp]

  inside another [sp] in another db

  THIS SCRIPT REPRODUCES THE BEHAVIOR

  -- in db_A

  use

  db_A

  create

  procedure dbo.sp_test

  @par varchar(10),

  @out varchar(10) output

  as

  print @par

  set

  @out= @par

  go

  -- in db_B

  use

  db_B

  create synonym sy_sp_test for usr01.frba.dbo.sp_test

  -- create synonym sy_sp_test for usr01.frba.dbo.sp_test

  go

  create

  procedure dbo.sp_test

  as

  declare

  @returned varchar(10)

  exec

  sy_sp_test 'hello', @out= @returned output

  go

  -- NOW , TEST IT ON DATABASE db_B

  sp_test

   

   

• keyser soze-308506

  SSChasing Mays

  Points: 630

  More actions

  September 12, 2006 at 8:15 am

  #659883

  excuse me

  the synonym must point to   "db_A"   ( for this example )

  not to "USR01"   (  that is my actual environment  )