Red Gate SQL Compare is a pretty good tool for this.

Visual Studio Team System Database Professional Edition is a great tool for all aspects of managing database projects, including deployment.

There...

I still don't see what's so complicated about the BACKUP and RESTORE commands. If you need some obscure option, you need to understand how to use it.

The maintenance plan...

Are BACKUP and RESTORE really that complicated? Compared to, for example, limitations on recursive common table expressions or all the tricks you can perform with MERGE and OUTPUT? ...

Linson.Daniel (11/1/2009)

---

Then again....would someone tell me why would I go about generating scripts like the way that was shown here when SQL server itself provides all the necessary options to...

The line breaks can be included in the literal strings, so you don't need to worry about which characters are used. You do have to put " ' +...

You don't need carriage return for a valid end-of-line sequence, only line feed. Drop the CHAR(13) and just use CHAR(10) and it works fine.

You could use an expression that evaluates the time of day and determines whether this is the correct time to execute the Send Email task. This expression could be...

Management Studio seems to be pretty forgiving on EOL sequences. You...

I liked the article, but since most of the discussion revolved around generating column lists I thought I'd add my two cents.

All of the obvious methods (drag-and-drop Columns from Object...

How on earth can you claim "no changes" is an action that was executed?

I'm really getting tired of questions that play word games.

From Nov 2008 Books Online:

DBCC CHECKALLOC checks the allocation of all pages in the database, regardless of the type of page or type of object to which they belong. It...

I hesitated to answer because I was positive at least one of the answers was going to have some wacky interpretation.

DBCC CHECKDB does not fail when run against either master...

When you use "ORDER BY [name]" the execution plan shows it sorting the input rows and feeding them to the Compute Scalar steps to evaluate the expression, and it performs...

No, the query has to be compiled and it will find out that the table doesn't exist before it runs the query and evaluates the WHERE clause.

You have to do...

The error output should include the ErrorColumn value. This is not the name of the column, but the ID number for the column within the dataflow. You could...