title: Is it possible to create a global stored procedure at Sql server level
body: <p>I created a query that takes a database backup at certain specified location.
  I want to use it as a stored procedure but this should act as a global stored procedure so that whenever this SP is called. Then database backup is taken.</p>
  
  <p>It uses DB_Name() to take database backup of owner database.</p>
  
  <p>Is it possible to create any such SP or Function.</p>
  
  <p>I am using sql server 2005</p>