I used to list from sysobjects to get this information, but found the INFORMATION_SCHEMA is a lot easier.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2003-05-05

170 reads

Blogs

Everything in SQL Server is waiting for something…this is by design. And most people...

Hey fellow data friends! Wow, March was an absolutely crazy month (in the best...

We value your privacy. This policy explains what personal data we collect and why. What...

Forums

hi i never used shared datasets before in ssrs. i created a dataset called...

Hi Is it possible to get distinct values using string_agg Select T1."transType", WHEN T1."TransType"...

Hi everyone, I'm working on optimizing a DELETE query used in a data cleanup...

What types of sources can be used with the Import Flat File Wizard in SQL Server Management Studio (SSMS)?