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

My first time at SQL Saturday New York City was an absolute blast! Thank...

Just a quick one this morning. I’m on the road and haven’t worked up...

Businesses rely on data for decision-making and strategy, but data silos hinder productivity. These...

Forums

Hi there I need help on creating a Linked Server to an MS Access...

Hi, I have a workstation with SQL Express 2019 installed and I have a...

Hello - I have attached a Word document here with details about my issue....

If I want to delete a log shipping secondary server where only one database is used to restore the logs, what should I do?