Brandie,

Did you ever determine what was causing this problem? I am suddenly having this problem as well. DTA runs for about a half hour on the 'Submitting Configuration...

When I evaluated such products a year or so ago it turned out to be pretty close between SQL Compare and SQL Delta. I eventually chose SQL Delta because...

Sorry, that should be:

dump transaction databasename with no_log

You might try:

dump transaction with no_log

If your database is set up for replication, transactions marked as not replicated can prevent the log from being shrunk. You may need the run the sp_repldone stored...

I get similar results after applying CU4 and enabling the 2 trace flags. It does not seem to help my problem queries with outer joins. I still...

Yes, that is what I am seeing. I will have CU 4 installed this week-end so I can verify that it goes away afterwards. But if you can't...

I guess I should have said 'a perfectly formed outer join', using a LEFT Join for example.

Cliff

No, the queries can have what looks like a perfectly formed join condition. But when you examine the query plan you will see a warning indicating 'No Join Predicate'...

Displaying help information about the stored procedure when someone passes in 'help' as the first parameter is a nice touch.

There is a known issue if you are missing a join predicate in one of your join conditions. Refer to KB article:

http://support.microsoft.com/kb/942444/

We have seen several instances...

Yes, as the previous poster just pointed out, in SQL 2005 the Collation can be set at the database and column level as well.

The question should have asked to check all that apply.

Had you written the question like this I probably would have gotten it right.

SELECT * FROM dbo.Customers MIDDLE

JOIN dbo.Employees ON CustomerID=EmployeeID

I guess I did learn that indentation improves...

AddTestWithoutNoCount is shown on the bottom right of the 4 stored procedures but as you point out it is identical to AddTestWithdbo.