创建表的时候要添加目标语句use

/*==============================================================*/
/* DBMS name:      Microsoft SQL Server 2000                    */
/* Created on:     2012-3-1 16:55:14                            */
/*==============================================================*/

use ieye_db      /*******************目标语句***************/
if exists (select 1
          from sysobjects
          where  id = object_id('dbo.GetAllCameraByUserAndGroup')
          and type = 'P')
   drop procedure dbo.GetAllCameraByUserAndGroup
go