tompazourek

/* Drop all non-system stored procs */
DECLARE @name VARCHAR(128)
DECLARE @SQL VARCHAR(254)

SELECT @name = (SELECT TOP 1 [name] FROM sysobjects WHERE [type] = 'P' AND category = 0 ORDER BY [name])

WHILE @name is not null
BEGIN
    SELECT @SQL = 'DROP PROCEDURE [dbo].[' + RTRIM(@name) +']'
    EXEC (@SQL)

tompazourek

// NOTE: ELMAH logs the errors anyway

protected void Application_Error(object sender, EventArgs e)
{
    var exception = Server.GetLastError();
    var httpException = exception as HttpException;

    if (httpException != null)
    {
        switch (httpException.GetHttpCode())

tompazourek

<modules runAllManagedModulesForAllRequests="false">
  <!-- disable authorization section -->
  <remove name="UrlAuthorization" />
  <!-- disable unused authentication schemes -->
  <remove name="WindowsAuthentication" />
  <remove name="PassportAuthentication" />
  <!-- disable ACL file and directory check -->
  <!-- <remove name="FileAuthorization" /> -->
  <!-- We don't use ASP.NET Profiles -->
  <remove name="Profile" />

tompazourek

BEGIN TRY
    BEGIN TRANSACTION

    -- statements here

    COMMIT TRAN
END TRY
BEGIN CATCH
    IF @@TRANCOUNT > 0
        ROLLBACK TRAN

tompazourek

USE [master]

DECLARE @dbname SYSNAME
SET @dbname = 'DATABASENAME'

DECLARE @spid INT
SELECT @spid = MIN([spid]) FROM [master].[dbo].[sysprocesses] WHERE [dbid] = DB_ID(@dbname)

WHILE @spid IS NOT NULL
BEGIN

tompazourek

-- http://stackoverflow.com/a/16310139/108374
CREATE LOGIN [IIS APPPOOL\MyAppPool] FROM WINDOWS;
CREATE USER MyAppPoolUser FOR LOGIN [IIS APPPOOL\MyAppPool];

tompazourek

-- Disable all table constraints

ALTER TABLE MyTable NOCHECK CONSTRAINT ALL

-- Enable all table constraints

ALTER TABLE MyTable CHECK CONSTRAINT ALL

-- Disable single constraint

tompazourek

DECLARE @TableName varchar(255) 
 
  
 
DECLARE TableCursor CURSOR FOR 
 
SELECT table_name FROM information_schema.tables 
 
WHERE table_type = 'base table' 
 

tompazourek

ALTER DATABASE [VoracioPlatform]
SET READ_COMMITTED_SNAPSHOT ON
GO
ALTER DATABASE [VoracioPlatform]
SET ALLOW_SNAPSHOT_ISOLATION ON
GO

tompazourek

set statistics time on 
-- execute queries

set statistics time off



-- http://stackoverflow.com/a/11675263/108374