• aha!!! I had a feeling this was a loop through all the databases on my server and do something kind of situation. In general cursors are to be absolutely avoided. There are however cases where they are the only tool for the job and this happens to be one of those cases. You might take a look at the undocumented sp_msforeachdb stored proc. It builds a cursors under the hood and provides some ability for doing this type of thing a bit easier. If you get hung up in trying to implement that give me a shout back and I will put something together that should help. 😉

    _______________________________________________________________

    Need help? Help us help you.

    Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

    Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

    Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
    Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
    Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
    Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/