2018-04-18 (first published: 2018-04-12)
545 reads
Rename Foreign Key Constraints
Rename Foreign Key Constraints in a consistent manner. Ideal for preventing constraint errors during code promotion.
2015-02-09 (first published: 2013-03-19)
1,310 reads
Generate Create View statements for database tables.
Create views based on table definitions for backwards compatibility when relocating tables to a new database.
2013-08-16 (first published: 2013-07-30)
1,089 reads
Quick view of User database and server roles
Outputs an easily readable result of the database and server roles for database principals.
2013-07-18 (first published: 2013-06-14)
1,041 reads
Search for String in all columns
Find all columns containing a string value across all tables and schemas.
2012-11-07 (first published: 2012-10-12)
1,773 reads
Blogs
Weekly reading #29
By damianwidera
The Data Breach Game: The 9 Worst IT Security Practices Joey D’Antoni shows bad...
#PowershellBasics: Get-Help -Online
One of the other things I learned from the Powershell class I’m taking this...
Undercover TV Podcast – Scripting Options in SSMS
In this episode of the podcast, Adrian looks at the scripting options available in...
Forums
How to upgrade to SP3 with multiple named 2008R2 instances on same server
I have a server with two named instances of 2008 R2, SP1. I have...
Upgrade from SP1 to SP3 on server with two named instances, run upgrade twice?
I have a server with 2008 R2 SP1 using two named instances. When I...
Transactional Replication
Hi, I've setup some publications and subscriptions today and use a backup to start...
Ask SSC