Tools, scripts for working with SQL Server 2008

Question

Hi,

While working with DB, I find useful using some tools, that help me to solve DB problems.

Some of them are:

1) Insert generator

2) A tool that can execute a script on a list of DB's

3) Finding a text in stored procedures and functions.

4) DB Back up scripts

My question is, what are most useful tools, scripts(anything else), that help you to work with SQL Server?

Thanks in advance.

UPDATE

I assume, there are no other tools for SQL Server 2008 or any other version?

Answer 1

Redgate has a collection of quite powerful tools for Sql Server.

Answer 2

I have stored procedures that do the following:

system utilities:

• find and list every occurrence and info about a given column name or partial column name
• find and list every occurrence and info about a given object name or partial object name
• list out all the information for a given table, all columns, computed columns, column data types, nullability, defaults, identity, check constraints, index, pk, fk, triggers, and column comments.
• find every trigger, view, stored procedure, or function that contains a given string

business utilities:

I also make stored procedures that work with business info. When working on an area of our application I'll make a procedure that displays out all the related info of a given thing. I'll usually display all the info using multiple PRINTs and SELECTs for everything that can join to the given PK (not if there are thousands or rows though). For example, one utiltiy would take a DoctorID as a parameter and list out all the doctor's info, offices that they work at, insurance they accept, etc. I like to include the table names in the output so I can remember where the data comes from without looking at the code. I also join in all the codes tables in these displays, so I'm not looking "A" but "Active (A)". After working on a system for a while, I have loads of these utilities, which greatly helps when a support call comes up or you need to debug a problem, etc. I usually build these as I develop, it is difficult to find time to go back and make them.

Answer 3

Check out the SMSS Tools Pack.

Answer 4

1) Insert generator

RedGate SQL Generator or DB Data Generator or dtm data generator

2) A tool that can execute a script on a list of DB's

SQL multi scripts or DB MultiRun