<div>
You need to point to the database that contains the tables otherwise you would get errors since the SP will not be able to access the tables, unless your queries specifically use the database name<br />
eg<br />
&nbsp; &nbsp;select * from DB1.dbo.Table1<br />
<br />
This is useful if you are mixing tables from different databases in which case I would prefer to change the db to master <br />
USE [master]<br />
<br />
For me its more of a maintenance issue, if my queries reference one database, then there is no need to change the active database to some other db
</div>


<div>
You better not create something in master-db, keep your stuff in your databases.<br />
<br />
For objects in a SP it's best not to give db-name for objects that are in same db as the SP itself. Why? When you restore database with another name (*_test) then it does not point to the original db.<br />
<br />
Objects of another db there you don't have much choice but referencing them with the specific db-name. It's better as dynamic sql.
</div>


<div>
If your SP is only referencing objects of your other database then it's better to create that procedure in that other database. But you still can cover it for the caller.<br />
<br />
(short version<br />

<pre><code class="code-10 nolinks" id="code-20-38174624-1"><span>GO</span>
<span>use db1</span>
<span>GO</span>
<span>Create procedure dbo.proc1</span>
<span>as begin</span>
<span>  select * from dbo.table1</span>
<span>end,</span>
<span>GO</span>
<span>use db2</span>
<span>GO</span>
<span>create procedure dbo.proc1</span>
<span>as</span>
<span>begin</span>
<span>  -- Call procedure from other database</span>
<span>  exec db1.dbo.Proc1</span>
<span>end;</span>
<span>GO</span>
</code></pre>
<br />
And then if you execute dbo.proc1 in db2 it is only a cover that executes the dbo.proc1 from db1.
</div>


<div>
Normally it goes to master. because always master as default &nbsp;database.
</div>


<div>
<div class="content wysiwyg-content">
I have a stored procedure that has gone through table changes none of which are in the original Use [DBNAme] database. &nbsp; <br />
<br />
How do I best determine which database I need to point it to. &nbsp;<br />
<br />
Please explain why this matters as well.
</div>
</div>


I have a stored procedure that has gone through table changes none of which are in the original Use [DBNAme] database.   

How do I best determine which database I need to point it to.  

Please explain why this matters as well.

What determines the DBName where Use [DBName] is at Top of Stored procedure?

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.

Microsoft SQL Server 2008

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.