Some of these are tools I have had for years and may have changed names...

HappyFish - ERD Diagram

MyGeneration - Similar to CodeSmith

AdeptSQL Diff - Database Compare Utiliity

OpenProj - Project Management

yEd...

You are missing a space between the server name and -T

jparker2 (5/10/2010)

---

Make sure you do not try to resolve this by using SET statements. SET statements work well in Ad Hoc SQL statements, but not in SSIS package statements...

Is there a reason you chose not to perform the same tests on the GETUTCDATE function?

For the first day of the month, why use the double negative -- why not just

dateadd(day,1-datepart(day,@d),@d)

And the version for 2005 partitioned tables is located where??

>> "There is a separate SQL Server 2005 version if you need support for partitioned tables."

Looking at the site you mentioned that would make me think it would have to be PHP on a windows IIS Machine... What if it's LINUX or a variation...

I do the XML thing also to the stored procedure... But I am curious to know if there is any performance gain by using the table approach vs the...

Question is for the Article publisher (Jacob)... In the examples, the CTE uses an xml reference of ITEMS/ITEM, but ITEMS is not in the XML dataset... ITEM is...

Isn't the " " tag missing in your XML... Your CTE reader uses the ITEMS reference, but I do not see it within the XML being passed into the...

Isn't the tag missing in your XML... Your CTE reader uses the ITEMS reference, but I do not see it within the XML being passed into the...