andywhite37

// ==UserScript==
// @name       RallyDev Tweaks
// @namespace  http://acdub.com
// @version    0.1
// @description  Usability tweaks for rallydev.com
// @match      http://*.rallydev.com/*
// @match      https://*.rallydev.com/*
// @copyright  2013+, Andy White
// @require http://code.jquery.com/jquery-1.8.3.min.js
// ==/UserScript==

andywhite37

@echo off
rem
rem ****************************************************************************
rem
rem    Copyright (c) Microsoft Corporation. All rights reserved.
rem    This code is licensed under the Microsoft Public License.
rem    THIS CODE IS PROVIDED *AS IS* WITHOUT WARRANTY OF
rem    ANY KIND, EITHER EXPRESS OR IMPLIED, INCLUDING ANY
rem    IMPLIED WARRANTIES OF FITNESS FOR A PARTICULAR
rem    PURPOSE, MERCHANTABILITY, OR NON-INFRINGEMENT.

andywhite37

-- Kill all processes connected to a database.
use master;

declare @DatabaseName varchar(50);
declare @Spid varchar(20);
declare @Command varchar(50);

set @DatabaseName = 'MyDatabase';

print 'This query''s SPID: ' + convert(varchar, @@spid);

andywhite37

declare @TableName nvarchar(50);
declare @RecordCount int;
declare @Sql nvarchar(255);

declare TableCursor cursor for
select t.table_name from information_schema.[tables] t
order by t.table_name;

open TableCursor;