bvanskiver

for /R "C:\Database\Stored Procedures" %i in (*.sql) do sqlcmd -S -T . -d DatabaseName -i "%~fi"

bvanskiver

declare @spid int, @cnt int, @sql varchar(255)

select @spid = min(spid), @cnt = COUNT(*)
  from sysprocesses p
 inner join sysdatabases d on p.[dbid] = d.[dbid]
 where d.name like '%Internal%'

print 'Killing ' + CAST(@cnt as varchar) + ' processes.'

while @spid is not null

bvanskiver

-- Disables all FK constraints
exec sp_msforeachtable 'ALTER TABLE ? NOCHECK CONSTRAINT all'

-- Enables all FK constraints
exec sp_msforeachtable 'ALTER TABLE ? WITH CHECK CHECK CONSTRAINT all'

bvanskiver

-- Create role and grant permissions
create role db_executor
grant execute to db_executor

-- Add user(s) to role
exec sp_addrolemember 'db_executor', 'username'

bvanskiver

declare @spid int, @cnt int, @sql varchar(255)
 
select @spid = min(spid), @cnt = COUNT(*)
  from sysprocesses p
 inner join sysdatabases d on p.[dbid] = d.[dbid]
 where d.name like '%Internal%'
 
print 'Killing ' + CAST(@cnt as varchar) + ' processes.'
 
while @spid is not null

bvanskiver

select distinct name
  from sysobjects o
 inner join syscomments c on o.id = c.id
 where text like '%OrganizationID%'

bvanskiver

Server=myServerAddress;Database=myDataBase;User Id=myUsername;Password=myPassword;

bvanskiver

(New-Object System.Net.WebClient).DownloadFile("http://www.berndvanskiver.com/favicon.ico", "c:\temp\favicon.ico")

bvanskiver

-- Define the variables
declare @databases table (rowid int identity primary key, dbname varchar(500))
declare @rowid int, @dbname varchar(500), @sql varchar(2000)

-- Get the database names from the system function
insert into @databases (dbname)
select db_name
  from msdb.smart_admin.fn_backup_db_config (null)
 where is_managed_backup_enabled = 0
   and is_dropped = 0

bvanskiver

LogParser.exe -i:IISW3C -o:csv file:C:\Path\To\File.sql -stats:off > C:\Path\To\results.csv