2018-04-18 (first published: 2018-04-12)
1,224 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,317 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,096 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,048 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,842 reads
Blogs
Dec 8 Webinar with Pavilion – Boost SQL Server on VMware Performance 400% with 2-Step Tuning
By kleegeek
Join us on December 8th at 10am Pacific time for an exciting new webinar!...
Daily Coping 3 Dec 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Daily Coping 2 Dec 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Forums
Dates got changed to string when imported
Hi Everyone For some reason, all the values I imported into SS got changed...
Holiday Fun for Your Career
Comments posted to this topic are about the item Holiday Fun for Your Career
Get backup folder sizes from shared Location
Comments posted to this topic are about the item Get backup folder sizes from...
Ask SSC