Monthly Archives: October 2012

  1. Looping through multiple servers in SSIS


    October 31, 2012 by Kenneth Fisher

    This is just a quickie post to answer a question on how to loop through multiple servers in SSIS.  There …
    Continue reading

  2. How do I find all stored procedures or views that use a specific table?


    October 26, 2012 by Kenneth Fisher

    Many years ago when I was still working on SQL 2000 I occasionally needed to find all stored procedures and views …
    Continue reading

  3. I can connect to my instance locally but not remotely


    October 23, 2012 by Kenneth Fisher

    Every now and again (today for example) I’ll get a call that one of our SQL Server instances is down.  …
    Continue reading



    October 19, 2012 by Kenneth Fisher

    I recently started using OBJECT_NAME, OBJECT_SCHEMA_NAME and OBJECT_ID functions; unfortunately I really could have used OBJECT_TYPE but it doesn’t exist …
    Continue reading

  5. A review of SQL Interoperability / Joes 2 Pros Volume 5 by Rick A Morelan


    October 15, 2012 by Kenneth Fisher

    I recently passed my MCTS 2008 Development (70-433).  Yay me!  That made my 3rd 2008 certification.  This one was probably the …
    Continue reading

  6. Multiple CTEs


    October 9, 2012 by Kenneth Fisher

    Multiple CTEs It’s somewhat obscure in BOL and I wasn’t able to find any examples but it turns out you …
    Continue reading

  7. Active flag on the TCP/IP Properties page of SQL Server Configuration Manager


    October 5, 2012 by Kenneth Fisher

    I’ve been unable to connect to a server via one of its aliases for about a week.  When I looked …
    Continue reading

  8. When I get stumped I ….


    October 2, 2012 by Kenneth Fisher

    I work with a reasonably large team of DBAs.  There are 9 of us and we support not only 70+ …
    Continue reading

Enter your email address to follow this blog and receive notifications of new posts by email.

Join 3,753 other subscribers

Follow me on Twitter

ToadWorld Pro of the Month November 2013