Rotating Header Image

Posts from ‘May, 2009’

Finding the database owner using TSQL #SQL

As part of a cleanup initiative we have been reviewing all of our databases and their owners and looking for databases that needed their owner changed. We only wanted to touch the databases where the current owner did not equal the owner we wanted to use. I had to stop and think for a minute […]

@SQLFool SQL Server Rap Contest

So Ward Pond and Michelle Ufford started this SQL rap contest. I figured I’d post my entry on a Friday afternoon when most probably wont see it LOL but here it is….   To the tune of Regulate – Warren G (have a listen) DB Administrators we replicate any size of data and we damn good too […]

Running SSIS Packages – Security

So as most of my blog articles this post is inspired by an email I received asking for permissions to run SSIS packages.  In SQL Server 2005 there are 3 Database Roles in the msdb system database: MSDN Integration Services Roles 2005 Role Read action Write action db_dtsadmin Enumerate own packages. Import packages. or Enumerate all […]

Twitter links powered by Tweet This v1.6.1, a WordPress plugin for Twitter.