use master
go

/* 
** Setup required for SQL Monitor. Note: to allow a user group other 
** than dbo to use the SQL Monitor, change public in the grant 
** statements below to the desired group (or user).
*/


/*
** Procedure used by SQL Monitor Server when starting.
*/
if exists (select * from sysobjects
           where type = 'P'
           and name = 'mon_rpc_attach')
begin
        drop procedure mon_rpc_attach
end
go

create procedure mon_rpc_attach as
begin
         select @@kernel_addr, @@kernel_size, @@shmem_flags, @@mempool_addr

return 0
end
go

grant execute on mon_rpc_attach to dbo
go

/*
** Procedure used by SQL Monitor Client when connecting to SMS.
*/
if exists (select * from sysobjects
           where type = 'P'
           and name = 'mon_rpc_connect')
begin
	drop proc mon_rpc_connect
end
go

create proc mon_rpc_connect as return 0
go

grant exec on mon_rpc_connect to dbo
go

grant select on sysmonitors to dbo
go