THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » metadata » linked servers   (RSS)
  • Finding keyless tables across multiple servers

    Christina Leo (@christinaleo) asked this question on twitter today: So, if I ever needed a POSH script, today is the day. Having to inventory all prod databases to find tables missing primary keys.I have a query that returns what I need, but I need a report for each of 60+ databases across 3 servers I haven't joined the ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on October 20, 2011
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement