Stored Proc and Master DB

• noeld

  SSC Guru

  Points: 96590

  More actions

  November 13, 2003 at 8:03 am

  #481868

  I don't know how are you using the parameter

  but this sholud helpyou going

   
  
  Declare @str varchar(200)
  
  SET @str = DB_NAME()--Assuming is going to be runned from other databases only 
  
                       --otherwise use dbname as a parameter
  
  
  
   +'.dbo.sp_helprolemember '
  
   + '''' 
  
   + 'RoleName' 
  
   + ''''
  
  --print @str
  
  exec  (@str)
  
  
  
  

  I don't know why can't the "plus" sign show

  
  * Noel

• prn9974

  SSCrazy

  Points: 2060

  More actions

  November 13, 2003 at 8:37 am

  #481881

  Thanks very much mate. The 'DB_Name()' is going to be helpful for me on this. I shall have a go at it.

  Thanks