Report SQL SERVER 2005 Permissions
Reports permissions to three levels: database, schema and table -- in three formats: readable, structured, scripted.
2011-12-12 (first published: 2008-02-22)
3,837 reads
Delete Duplicates using CTE
Delete duplicates with a CTE (common table expression).This script uses the same setup as the anonymous post using a cursor (http://www.sqlservercentral.com/scripts/viewscript.asp?scriptid=1872).
2007-08-23
1,093 reads
Blogs
2020 Advent of Code–Day 3
By Steve Jones
This series looks at the Advent of Code challenges. As one of my goals,...
Welcome to the Azure Data Community, empowered by Microsoft
After the Professional Association of SQL Server (PASS) unceremoniously closed down in January this...
Daily Coping 24 Feb 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Forums
Some questions regarding Service Broker
Hi all, I have a third-party database/application that I'm attempting to augment with functionality...
Multiple listener for same AG
I am trying to educate myself and understand what are some of the advantages...
T-log Alert
i need to configure alert on multiple servers when the t-log reaches or exceeds...
Ask SSC