List All Databases, Sizes and Properties
This script will list all the databases on your server (SQL2000 only) as well as their sizes and some key properties. Very useful for keeping rogue developers under control 🙂
2003-05-17
784 reads
Mike Pearson
Get the Foreign Key Hierarchy
This script will run through the foreign keys on tables to produce a hierarchy of the tables in a database.This is useful when you need to purge and repopulate test databases with foreign key contraints
2002-07-24
1,765 reads
List All Jobs and Their Schedules
This queries the sysjobs, sysjobschedules and sysjobhistory table to produce a resultset showing the jobs on a server plus their schedules (if applicable) and the maximun duration of the job.
2002-06-20
4,102 reads
List All Jobs and Their Schedules (SQL7.0 & 2000)
This queries the sysjobs, sysjobschedules and sysjobhistory table to produce a resultset showing the jobs on a server plus their schedules (if applicable).
2002-06-04
1,733 reads
Get table sizes and rowcounts in MB (for VLDB)
This simple script is based on sp_spacedused, but returns values for all user tables in the database, with information in MB instead of the usual KB - which is useful for large databases. Simply run it in query analyser against the database concerned
2002-05-03
718 reads
Blogs
Goal Progress for June 2022
By Steve Jones
I set goals at the beginning of the year, and I’m tracking my progress...
Using Sessionize for Your User Group – Part 2
Now that your CFS has been setup it’s time to get the word out...
Daily Coping 1 Jul 2022
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Forums
Christmas in July
Comments posted to this topic are about the item Christmas in July
status of database in availibility group
I setup a staging environment to test basic always on availability group on SQL...
Updating a table from another table or a query.
I have a procedure that creates a table. One of the fields labeled delay...
Ask SSC