Technical Article

get rich schema details of all or some tables

to get information about tables+columns+primarykeys+foreignkeys+identity, i firstly used SQL server built-in INFORMATION_SCHEMA.xxx. however, my company have various DBAs and each of them owns objects. when using INFORMATION_SCHEMA.xxx, it retrieves data based on current login (version 2005 resolves this schema v.s. object owner problem already... yeah) , which bring me a great trouble. if you want […]

3 (2)

You rated this post out of 5. Change rating

2006-08-30 (first published: )

566 reads

Blogs

Speaking at SQL Saturday Austin 2025

By

SQL Saturday Austin 2025 is in just a few days. I am honored to...

Updating SSMS is Easy (w/ v21)

By

I’ve been using the SSMS preview for v21. This is the next evolution of...

Execute Fabric Data Pipeline from Azure Data Factory

By

In the blog post Call a Fabric REST API from Azure Data Factory I...

Read the latest Blogs

Forums

importing from PowerQuery... but with multiple powerqueries

By pietlinden

I finally got the PowerQuery source to "show" in SSIS (so I can see...

Third party backup softwares

By ashrukpm

Hi Team, Can you someone suggest a few good third part backup tools, with...

2022 SSIS PackageFormatVersion?

By TG

Recently I upgraded my ssis package from 2016 to 2022, but package format version...

Visit the forum

Question of the Day

The Monitor Server

What does the monitor server do in log shipping?

See possible answers