/*==============================================================*/
/* 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