This might seem a basic question but please do respond. I created a stored procedure i.e wrote code in notepad using logic and T-SQL statements. I named this file as SP.sql. I put in in my C drive. I want it to be a part of database A. Now how do I transport this SP.sql to the Stored Procedures in Database A.