title: Connect to another database in stored procedure - SQL Server 2008
body: <p>We have two database in a same DB server. But both the database use different user name and password. I have a stored procedure in oue second databse that should connect to first database and pull some records?</p>
  
  <p>Is this feasible? </p>
  
  <p>Earlier both of our database were using same username and password. so it was easy for us to connect between datbase in stored procedure. But now we changed the password.</p>
  
  <p>We are using SQL Server 2008 DB</p>