grzech.webio.pl

declare @isql varchar(2000), @dbname varchar(64) declare c1 cursor for select name from master..sysdatabases where name not in ('master','model','msdb','tempdb') open c1 fetch next from c1 into @dbname While @@fetch_status <> -1 begin select @isql = 'ALTER DATABASE [@dbname] SET AUTO_CLOSE OFF' select @isql = replace(@isql,'@dbname',@dbname) print @isql exec(@isql) select @isql = 'ALTER DATABASE [@dbname] SET RECOVERY SIMPLE' select @isql = replace(@isql,'@dbname',@dbname) print @isql exec(@isql) select @isql='USE [@dbname] checkpoint' select @isql = replace(@isql,'@dbname',@dbname) print...

DECLARE @DatabaseName nvarchar(50) SET @DatabaseName = N'NAZWABAZYDANYCH' --SET @DatabaseName = DB_NAME() DECLARE @SQL varchar(max) SET @SQL = '' SELECT @SQL = @SQL + 'Kill ' + Convert(varchar, SPId) + ';' FROM MASTER..SysProcesses WHERE DBId = DB_ID(@DatabaseName) AND SPId <> @@SPId -- SELECT @SQL EXEC(@SQL) Źródło: http://www.kodyaz.com/articles/kill-all-processes-of-a-database.aspx

EXEC SP_CONFIGURE 'remote query timeout', 1800 reconfigure EXEC sp_configure EXEC SP_CONFIGURE 'show advanced options', 1 reconfigure EXEC sp_configure EXEC SP_CONFIGURE 'remote query timeout', 1800 reconfigure EXEC sp_configure Źródło: http://sqlserverplanet.com/troubleshooting/fix-timeout-expired-the-timeout-period-elapsed-prior-to-completion-of-the-operation-or-the-server-is-not-responding/

sp_msforeachtable ' select ''?'' as ''Table'', count(*) as ''Rows'' from ? '