title: SQL Server Running a Stored Proc from Another Database
body: <p>I have been executing a stored procedure which exists on database1 from another stored procedure on database2. eg: exec [database1].Schema.SPname 'parameters'</p>
  
  <p>But I am not sure if this is possible only if both database1 and database 2 are present on the same instance of sql server.
  Any idea?
  Thanks &amp; Regards,
  Sarin</p>