use grbag
update tblPrmPdv set VlrPrm = 2 where codprm = 400085
update tblPrmPdv set VlrPrm = 9 where codprm = 400006
update tblPrmPdv set VlrPrm = 2 where codprm = 400007
update tblPrmPdv set VlrPrm = 'ELGIN i9(USB)' where codprm = 400089

update tblPdvPrm set VlrPrm = 2 where codprm = 400085
update tblPdvPrm set VlrPrm = 'ELGIN i9(USB)' where codprm = 400089
update tblPdvPrm set VlrPrm = 9 where codprm = 400006
update tblPdvPrm set VlrPrm = 2 where codprm = 400007

select CodPrm, NomPrm, VlrPrm from tblPrmPdv where CodPrm in (400085, 400006, 400007,400089)

select CodPrm, VlrPrm from tblPdvPrm where CodPrm in (400085, 400006, 400007,400089)

update tblpdvprm set VlrPrm = 'REDE' where codprm = 400088
update tblprmpdv set VlrPrm = 'REDE' where codprm = 400088

update tblLotDce set TipLot = ??  where CodLotDce = ??

*Tempo limite de consulta excedido. *
- Esse processo só é indicado quando as outras alternativas se esgotaram. 
- É necessário garantir que nenhuma pessoa esteja utilizando a base. 
- Desativar o site. (IIS)
- Reiniciar serviço SQL SERVER. 
- Não abrir sistema da GR. 

USE MASTER  
GO
USE corpsys
go
ALTER DATABASE corpsys
SET SINGLE_USER 
go
DBCC CHECKDB ( 'corpsys',REPAIR_REBUILD) WITH TABLOCK --ALL_ERRORMSGS
GO
DBCC UPDATEUSAGE (0)
     WITH  COUNT_ROWS 
go
declare @tab_nome varchar(255)
declare @tab_statistic varchar(255)
declare @sql_str varchar(255)
declare @db_nome varchar(255)

select @db_nome=name from master..sysdatabases where dbid=(select dbid from master..sysprocesses where spid=@@SPID)
--set @sql_str= 'sp_dboption ''' + @db_nome + ''',''auto create statistics'',''false'''
--exec (@sql_str)
checkpoint

declare cur cursor for SELECT object_name(id),name FROM SYSINDEXES WHERE NAME LIKE '_WA_Sys%'
set nocount on
open cur 
fetch next from cur into @tab_nome,@tab_statistic
while(@@fetch_status=0)
begin
  set @sql_str='drop statistics ' + @tab_nome + '.' + @tab_statistic
  print @sql_str
  exec (@sql_str)
  fetch next from cur into @tab_nome,@tab_statistic
end
close cur
deallocate cur
set nocount off
GO
DECLARE @COMANDO VARCHAR(255)
DECLARE @TABELA VARCHAR(100)

DECLARE CUR_TABLES CURSOR FOR
SELECT NAME FROM SYSOBJECTS WHERE TYPE = 'U'

OPEN CUR_TABLES
FETCH NEXT FROM CUR_TABLES INTO @TABELA

WHILE @@FETCH_STATUS = 0
BEGIN
	PRINT 'Atualizando indices da tabela '+@TABELA
	SELECT @COMANDO = (SELECT 'DBCC DBREINDEX ('+@TABELA+')')
	EXEC ( @COMANDO )
	FETCH NEXT FROM CUR_TABLES INTO @TABELA
END
CLOSE CUR_TABLES
DEALLOCATE CUR_TABLES

--SELECT @COMANDO = (SELECT 'DBCC UPDATEUSAGE ('+(select db_name())+')')
--EXEC ( @COMANDO )
GO
SET QUOTED_IDENTIFIER ON 

GO
SET ANSI_NULLS ON 
GO
DECLARE @tablename varchar(30)
DECLARE @tablename_header varchar(75)
DECLARE tnames_cursor CURSOR FOR SELECT name FROM sysobjects
	WHERE type = 'U'
OPEN tnames_cursor
FETCH NEXT FROM tnames_cursor INTO @tablename
WHILE (@@fetch_status <> -1)
BEGIN
	IF (@@fetch_status <> -2)
	BEGIN
		SELECT @tablename_header = 'Atualizando '  + RTRIM(UPPER(@tablename))
		PRINT @tablename_header
		EXEC ('UPDATE STATISTICS '  + @tablename + ' WITH FULLSCAN ')
	END
	FETCH NEXT FROM tnames_cursor INTO @tablename
END
PRINT ' '
PRINT ' '
SELECT @tablename_header = '*****  Fim das Tabelas  *****'
PRINT @tablename_header
PRINT ' '
PRINT 'As estatisticas foram atualizadas para todas as tabelas'
DEALLOCATE tnames_cursor

GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO
SELECT 'Index Name' = i.name, 
       'Statistics Date' = STATS_DATE(i.id, i.indid)
FROM sysobjects o, sysindexes i
WHERE o.id = i.id
  and  o.type = 'U'

go
sp_helpdb corpsys
go
DBCC SHRINKFILE  ( corpsys_log)
go
DBCC SHRINKFILE  ( corpsys_data)
go
DBCC SHRINKFILE  ( corpsys_log) 
go
sp_helpdb corpsys
go
ALTER DATABASE corpsys
SET MULTI_USER 
GO