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,155 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,012 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,093 reads
Blogs
Event Notifications Example
By SQLPals
Event notifications are kinda like a trigger in the sense that they respond to...
Did you know we have another SQL Server book coming out?
SQL Server 2017 Administration Inside Out was the first technical book I contributed to,...
Batch Scripting SQLCMD–#SQLNewBlogger
By Steve Jones
Another post for me that is simple and hopefully serves as an example for...
Forums
Using sftp in Visual Studio for SSIS packages
Hi, I've inherited the maintenance of SSIS packages that were created by our former...
Merge vs other options
Hi, I need to load a table that has 5,000,000 records, I usually use...
Password changes
I would like my SQL users to be able to change their SQL password.Using...
Ask SSC