SQLServerCentral.com Scripts tagged DBA

Get IP Addresses of all Hostnames using SQL Server

Thu, 02 May 2013 06:00:00 UT

To get the IP addresses of Multiple hostnames from below stored procedure.

How to automate your .NET and SQL Server deployments
Deploy .NET code and SQL Server databases in a single repeatable process with Red Gate Deployment Manager. Start deploying with a 28-day trial

sp_who3

Mon, 01 Aug 2011 06:00:00 UT

A compatibility view for DBAs used to using sp_who2

Another sp_who3

Thu, 07 Oct 2010 06:00:00 UT

Get processes run and the command.

EXECute SQL Commands over entire sets of parameters!

Tue, 16 Mar 2010 06:00:00 UT

A super-powered EXEC on steroids, the Power Tool every DBA wants for Christmas.

Function to Add Leading 0's (Zeros) to an INT

Thu, 05 Mar 2009 07:00:00 UT

Very simple function code to add leading zeros to a passed in int for a length also passed.

12 essential tools for database professionals
The SQL Developer Bundle contains 12 tools designed with the SQL Server developer and DBA in mind. Try it now.

Function to Return Date and Time String for File Archiving

Wed, 18 Feb 2009 07:00:00 UT

This function will return a string in sortable format YYYYMMDD-hhmmssnnn to append to file names for archiving.

Find Text in all columns of all tables in a Database

Thu, 31 Mar 2011 06:00:00 UT

Will find the Table Name, Column Name and the number of occurances some text appears in a database.

Make working with SQL a breeze
SQL Prompt 5 is the effortless way to write, edit, and explore SQL. It's packed with features such as code completion, script summaries, and SQL reformatting, that make working with SQL a breeze. Try it now.