Check Syntax on a Database
This script finds the first error on all Sprocs, Functions, Triggers and Views in a database. Works in SQL Server 2005 and 2008
2009-04-21 (first published: 2009-03-26)
916 reads
Scripts
2009-04-17 (first published: 2008-10-15)
1,143 reads
Comparing Stored Procedures, Part 6
Sixth in a series of scripts demonstrating a quantitative comparison between the text of two stored procedures
2009-04-15 (first published: 2009-02-26)
1,445 reads
2009-04-14 (first published: 2009-03-05)
2,104 reads
2009-04-10 (first published: 2009-03-13)
2,181 reads
2009-04-09 (first published: 2009-03-16)
1,426 reads
SQL 2000: Track Stored Procedure Changes
SQL Server 2000 does not log the procedures modified using ALTER statement. Here's the script to find out the same.
2009-04-07 (first published: 2009-03-02)
1,324 reads
Comparing Stored Procedures, Part 5
Fifth in a series of scripts demonstrating a quantitative comparison between the text of two stored procedures
2009-04-03 (first published: 2009-02-23)
1,458 reads
Return User Roles
A stored procedure that will return the roles assigned to a user. Can be called from software to validate a user set up with Windows Authentication.
2009-03-25 (first published: 2009-02-19)
1,194 reads
Determine Users with Permission on an Object
This script will walk the hierarchical chain of users and roles to find users with permissions on an object.
2009-03-24 (first published: 2009-02-18)
1,653 reads
Blogs
The #MS_DatabaseConnector## Role: #SQLNewBlogger
By Steve Jones
I had seen these roles in various instances, but never dug into the new...
Asking for Help Isn’t a Weakness
By Brian Kelley
During COVID, I attended training on software/enterprise architecture given by Mark Richards. One of...
The Proof of the Backup Is in the Pudding
For me, the objective is straightforward: have a backup strategy that is reliable, understandable,...
Forums
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
Planning for Change
Comments posted to this topic are about the item Planning for Change
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