• Samuel Vella (4/21/2011)


    Another little tip when adding a template:

    When adding a new item you might be tempted to change the file name in the Add New Item dialogue box.

    DO NOT DO THIS

    Instead, add the package/report leaving in the default file name, then rename it in the project explorer tree.

    The reason for this is simple, renaming the file in the dialogue box will not change the object name. Waiting until afterwards will give you the option of automatically changing the object name to reflect the file name.

    Excellent tip Samuel. (And yet another excellent example of why you need to read the discussions on the articles - lot's of goodies in them, like this!)

    Wayne
    Microsoft Certified Master: SQL Server 2008
    Author - SQL Server T-SQL Recipes


    If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
    Links:
    For better assistance in answering your questions
    Performance Problems
    Common date/time routines
    Understanding and Using APPLY Part 1 & Part 2