Technical Article

User Tables with Size  all DBs (SQL 2005 Only)

Hope this is helpful to someone.  This script will create a table and a stored procedure in the master database to gather and store table info for all datbases. The sp uses a temp table to hold the results returned by sp_spaceused, then transfers the information to the permanent table DatabaseTableSizes and adds the database […]

5 (1)

You rated this post out of 5. Change rating

2007-07-16 (first published: )

283 reads

Blogs

Down the Rabbit Hole: Dealing with Ad-Hoc Data Requests

By

"But I don’t want to go among mad people," Alice remarked."Oh, you can’t help...

Adding a Local Model to Ollama through the GUI

By

I saw some good reviews of the small gemma3 model in a few places...

Connect resiliently to SQL Server

By

 Why you should connect resiliently to SQL Server Transient failures happen — in the cloud...

Read the latest Blogs

Forums

using different credentials when debugging ssis

By stan

hi, now and then i want one connection in my ssis pkgs to use...

AlwaysON health check alerts

By Srinivas Merugu

Comments posted to this topic are about the item AlwaysON health check alerts

Bat and SQL script to generate DB user permissions for all Databases in SQL server

By Srinivas Merugu

Comments posted to this topic are about the item Bat and SQL script to...

Visit the forum

Question of the Day

PWDCompare

What does the PWDCOMPARE function do?

See possible answers