Who's this guy?

705days since
SQL Saturday KALAMAZOO

Sprawl Blog

  • SSIS hates varchar(max) While attempting to populate a SSIS string variable with the result set from a stored procedure that returns a varchar(max) value, you will get this error:   Error: 0xC002F309 at ...
    Posted Sep 4, 2012, 1:20 PM by Paul Olson
  • Change Owner of an Object in SQL Server So I have this custom app that was built by an unknown a few years ago and it is mission critical! Oh and great news; it assigns ownership to db ...
    Posted Aug 30, 2012, 7:25 AM by Site Admin
  • How To Create A Logfile Viewer in 15 minutes This is what I have been looking for...Sweet!
    Posted Aug 29, 2012, 10:44 AM by Site Admin
  • SQL Saturday 160 Kalamazoo 2012 SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. This event will be held Sep 22 2012 at Kalamazoo Valley Community College ...
    Posted Aug 24, 2012, 9:02 AM by Paul Olson
Showing posts 1 - 4 of 7. View more »
 
 

My T-SQL Stuff

  • CREATE SP - Exchange Object Owner IF exists (select * from sysobjects where id = object_id(N'[dbo].[sp_ExchangeOwner]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[sp_ExchangeOwner] GO   SET QUOTED_IDENTIFIER  OFF    SET ...
    Posted Aug 30, 2012, 7:13 AM by Site Admin
  • Create default user accounts USE masterGODECLARE      @ExitCode varchar(255)                          -- return code      ,@WindowsUser varchar(55)      ,@MSSQLUser varchar(55)      ,@MSSQLPass varchar(55)      ,@JobAction nvarchar(255)           SET @WindowsUser ='<username>'      SET @MSSQLUser ='<username>'      SET @MSSQLPass  ...
    Posted Aug 24, 2012, 1:05 PM by Paul Olson
  • SELECT Backup History Details /******************************************************************************** Purpose:    Simple: Most Recent Database Backup for Each Database in HistoryDetails: db name|Backup Start and end|Backup size|Physical location|Hours since last BackupWritten by: Paul Olson ...
    Posted Jul 5, 2013, 12:16 PM by Paul Olson
  • SP: List the row count of all tables in the database in descending order /************************************************************************************************* Purpose: To list the row count of all tables in the database in descending order. Output can be restricted to top n tables. That is you can pass the value ...
    Posted May 12, 2011, 9:31 AM by Paul Olson
Showing posts 1 - 4 of 4. View more »