• Interests: Sailing, boats, wooden boats, wooden boats with sails - oh, and sailing

Technical Article

Get all Tables and Columns for each Database

This script will get the name of each database from master..sysdatabases, then use each database's Information Schemata to get the tables and columns in each of the databases. Several recent requests for assistance have used this to answer their needs. I ran it across 245 databases and pulled back 1.4 million results in about 30 […]

5 (1)

2004-04-15

1,323 reads

Blogs

Tagging in SQL Monitor

By

For many of us, we’ve learned over time that we need to filter out...

Daily Coping 6 Dec 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Dec 8 Webinar with Pavilion – Boost SQL Server on VMware Performance 400% with 2-Step Tuning

By

Join us on December 8th at 10am Pacific time for an exciting new webinar!...

Read the latest Blogs

Forums

Extracting out elements from XML String based on condition in tag

By Weegee71

Hi there I am trying to the Channel list from a particular XML file ...

Problem understanding SUM function with GROUP BY

By DaveBriCam

I have code I'm trying to write to sum the time in decimal for...

Problem understanding SUM function with GROUP BY

By DaveBriCam

I have code I'm trying to write to sum the time in decimal for...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers