Data Dictionary using sys.objects - SQL 2008
Create a data dictionary with two stored procedures using sys objects to view via SSRS (or other reporting tool) report
2010-10-21 (first published: 2010-10-16)
2,242 reads
Delete constraints - SQL Server 2005
This script will DELETE ALL constraints within the database that you define and in the following order: Foreign Key, Primary Key and then Unique Key.CAUTION:This script does not print out the ALTER TABLE statements, it drop the constraints immediately, therefore backup your database before testing or using this script. I ran the script below and […]
2007-09-19 (first published: 2007-05-23)
4,077 reads
Data Dictionary - SQL 2005
I know there are several scripts out there showing you on how to create a data dictionary... I created this script for creating a data dictionary for SQL 2005. It stores the data into a table in the database that you choose. The script only stores the table name, column name, default value of the […]
2006-10-24 (first published: 2006-07-06)
3,119 reads
Blogs
How To Restore Change Data Capture – CDC Tables When Restoring a SQL Server Database
By Tim Radney
I have recently had the privilege of working with multiple clients who have been...
KDA: Echoes of Deception - Onboarding
By Zikato
I’ll walk through the KDA UI and tackle the first challenge before diving into...
Kusto Detective Agency - Intro
By Zikato
While I mostly write about SQL Server, I have a soft spot for Kusto....
Forums
2022 SSIS PackageFormatVersion?
Recently I upgraded my ssis package from 2016 to 2022, but package format version...
officialsprinklezshop.com/Buy Sprinklez Cotton Candy Vanilla Swirl Strain
Website: https://officialsprinklezshop.com/ Buy Best quality Sprinklez Strain from Officail Sprinklez Shop Sprinklez Cotton Candy...
https://officialsprinklezshop.com/ Sprinklez Super Sweet Sugar Sparks Strain
Website: ttps://officialsprinklezshop.com/ Buy Top Notch quality product from Official Sprinklez Shop. 100% Trusted -...
Question of the Day
The Monitor Server
What does the monitor server do in log shipping?
See possible answers