Table Sizes in database
This script uses the same information sp_spaceused does. It just formats it in a different way.
2005-05-10 (first published: 2005-04-26)
187 reads
Execute SQL-DMO Database method on all databases
This script allows you to specify a method and a server (or multiple servers.) It will then execute the method on every database on the server. With very minor tweaking you could have it search for the servers, then call the server db script with each one, or add another nesting to call tables or […]
2005-04-27 (first published: 2005-04-14)
697 reads
Blogs
Why I tweet about work and personal topics from the same account
Over the last few years, I’ve had a few people ask me why I...
Daily Coping 26 Sep 2022
By Steve Jones
Today’s coping tip is to enjoy photos from a time with happy memories. On...
Daily Coping 23 Sep 2022
By Steve Jones
Today’s coping tip is to notice what you are feeling without any judgment. Today...
Forums
3616 Trigger Error when Calling Stored Procedure on Linked Server
I am updating a proprietary database using an SSIS package. From a web UI...
Seggregating access within a database to users
For some folks that have gotten used to working in Oracle where a user...
Replication Error on identity Column : Transactional Replication
I have manually deleted data from a subscriber replicated table, and broken replication....
Ask SSC