Create System Proc to Grab Row Counts for Tables
Really basic way to help identify tables that have 0 rows, etc. It uses the sp_MSForEachTable to crawl the database. Very simple script.
2007-01-10 (first published: 2006-12-01)
254 reads
Scripts
Catalogue of tables and fields by datatype SS2005
Returns the datatype, table name and field name for all user tables in the current SQL Server 2005 database. Results are sorted by type, table and field.
2007-01-08 (first published: 2006-12-05)
137 reads
Function to find the current age
Use this script to figure out the current age of a person or object. It also takes leap year birthdates into consideration. You can also use this to find out the age of something at a particular point of time.
2007-01-04 (first published: 2006-12-19)
231 reads
Backup database (Red Gate/Native Backup)
This is just an update which fix a small bug (0 day backup bug with SQL Backup)
2007-01-03 (first published: 2006-12-19)
599 reads
Date String format with optional Timestamp
I find it so annoying to format dates. Sometimes I want to include the timestamp, but if it is a midnight time stamp, the time is irrelevant. Sending in a datetime will return either the date string or a date string with a timestamp up to the seconds with either AM or PM.
2007-01-02 (first published: 2006-12-20)
230 reads
Check and Set Default file Locations with TSQL
Checks the default file locations for your data and log files. If not set, it sets them to the specified values. This is written for a SQL 2005 default instance. Registry paths may be different for SQL 2000 or named instances.The script can be easily modified to update it if the current value is set […]
2007-01-01 (first published: 2006-12-21)
940 reads
Execution of Code on Multiple Servers Remotely
Do you have more than 10 sql servers you must manage? Most DBA s do, I have over 120 sql instances to manage. Before I used to use ISQL/OSQL in a batch to execute a command on all these instances. It works but not very nice. Below is the code I use to collect information […]
2006-12-28 (first published: 2006-10-16)
831 reads
Checking SQLAgent service and starting it if not.
Because many programs I wrote depends on the SQL Agent Service and to really make sure that no one has configured this service to run manually (you see many things in life) I rely on this litle piece of code
2006-12-27 (first published: 2004-09-16)
223 reads
Find Missing Constraints
Procedure to help find missing constraints when comparing two databases that are supposed to be the same. SP has ability to show all constraints per database, and the ability to generate create scripts to make adding the missing constraints easier.
2006-12-26 (first published: 2002-03-12)
827 reads
Checking the REMOTE site of a database-link
When gathering SQL server statistics on ALL our Active SQL servers the script was failing sometime when one of our servers was not reachable for one reason or another.This script is checking if the LINKED SERVER is up and running before executing the "gathering statistics" script for this particular server.
2006-12-25 (first published: 2006-09-29)
218 reads
Blogs
Wait… Could This Be the End of Index Maintenance?
While attending SQLCon and FabCon Europe in Barcelona, there were a lot of announcements...
Copilot on the Power BI Report Canvas vs. Modern Report Builder
By James Serra
(This is the second post in a three-part series on how AI is changing...
The #MS_DatabaseConnector## Role: #SQLNewBlogger
By Steve Jones
I had seen these roles in various instances, but never dug into the new...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Access + ODBC Driver 18 + SQL Server 2025: ~150–250 ms per request
Has anyone encountered recurring request latency when using Microsoft Access with SQL Server 2025...
The ##MS_DatabaseConnector## User
Comments posted to this topic are about the item The ##MS_DatabaseConnector## User
Question of the Day
The ##MS_DatabaseConnector## User
On SQL Server 2025, I run this code as a sysadmin:
CREATE LOGIN Demo WITH PASSWORD = 'Demo1234567' GO ALTER SERVER ROLE ##MS_DatabaseConnector## ADD MEMBER Demo GOI then login as Demo and run this:
USE sandbox go SELECT CURRENT_USERWhat is returned? See possible answers