creating a stored procedure in a different database

• Puneet Dhingreja

  Newbie

  Points: 1

  More actions

  August 27, 2005 at 4:46 am

  #102747

  i want to create a stored procedure in different database from one database theough a stored procedure..i have some idea about opendatasource but don't know how to go about implementing it..please help me

   

  thanks in advance

• Ray M

  SSC-Insane

  Points: 21093

  More actions

  August 29, 2005 at 5:02 pm

  #586015

  Opendatasource can only be used for querying another server.

  you can try to use dynamic sql, but there are always challenges doing so.

  http://www.sommarskog.se/dynamic_sql.html

  But using a stored procedure to create another stored procedure is unusual at best.