On Thu, 25 Sep 2008 07:41:01 -0700, Doug wrote: >Thanks Roy. I thought that if I qualified the SP with the database name, it >would look in that database for the SP and wouldn't find it. When you are in a database other than master and execute a stored procedure starting with sp_ without any database qualifier, it will first look in the local database. If it finds it there that is what will be executed. If it is not found locally it looks for it in master. The same is true when you qualify an sp_ stored procedure with a database name, it first looks locally and then in master. Roy Harvey Beacon Falls, CT
