Createing a Stored Proc from a Stored Proc

• Steven.

  SSCrazy Eights

  Points: 9806

  More actions

  December 18, 2001 at 8:52 am

  #77571

  (SQL 2000 SP1)

  Basically I have been asked to find a way to create a new stored procedure in a different database.

  I have got as far as creating a stored procedure from a stored procedure using the following code.

  CREATE procedure b as

  declare @SQLString nvarchar(500)

  set @SQLString =N'CrEATE procedure a as select * from sysfiles'

  EXECUTE sp_executesql @SQLString

  But I need the stored procedure to be created in a different database, Any ideas anyone?

  Steven

• Steven.

  SSCrazy Eights

  Points: 9806

  More actions

  December 18, 2001 at 8:56 am

  #421222

  Found the solution just after posting the

  question

  If I execute the sp_executesql command from the destinaction database it works eg.

  EXECUTE northwind..sp_executesql @SQLString

  Steven

• Steve Jones - SSC Editor

  SSC Guru

  Points: 738160

  More actions

  December 18, 2001 at 10:04 am

  #421238

  Thanks for the followup and good work.

  Steve Jones

  steve@dkranch.net