COMANDOS PARA O SCRIPT DO SQL_db5.txt

(0 KB) Pobierz
DBCC MEMORYSTATUS
DBCC DROPCLEANBUFFERS
DBCC FREEPROCCACHE
DBCC FREESYSTEMCACHE ( ‘ALL’ )
DBCC FREESESSIONCACHE WITH NO_INFOMSGS; 


sp_configure 'max ser' ,2048
go
sp_configure 'min ser' ,1024
reconfigure
set nocount on;
set IDENTITY_INSERT [dbo].[cidade] on; 




*-*-*
sqlcmd -S DATABASESERVERNAME \ TESTINSTANCE -i "F: /DeploymentScripts/DataPopulation.sql"


sqlcmd -S .\SAGE2014 -i "c:\FOX_SQL\CONFIGURAÇÕES\DB5.sql"
Zgłoś jeśli naruszono regulamin