create procedure sys.sp_MSgetmissingbm
@objid int,
@missingbm varbinary(128) output,
@missingcolcount int output
as
set nocount on
declare @maxcolid int
declare @idx int
select @maxcolid= max(column_id) from sys.columns where object_id = @objid
if @maxcolid is null return 1
set @missingbm= null
set @missingcolcount= 0
set @idx= 1
while @idx <= @maxcolid
begin
if not exists (select * from sys.columns where object_id = @objid and column_id = @idx)
begin
exec sys.sp_MSsetbit
@bm= @missingbm output,
@coltoadd= @idx
set @missingcolcount= @missingcolcount + 1
end
set @idx= @idx + 1
end
return 0