2023-04-17
435 reads
2023-04-17
435 reads
2023-04-03
547 reads
A stored procedure from longtime community member Lowell Izaguirre, returns the CREATE TABLE definition for any table, including PK, UQ, Identity, FK, Defaults, and more.
2019-04-16
15,556 reads
2016-05-30
1,413 reads
2015-04-20
1,780 reads
Even where Source Control isn't being used by developers, it is still possible to automate the process of tracking the changes being made to a database and put those into Source Control, in order to track what changed and when. You can even get an email alert when it happens. With suitable scripting, you can even do it if you don't have direct access to the live database. Grant shows how easy this is with SQL Compare.
2011-10-20
2,823 reads
The term DDL designates Data Definition Language, which implies an action involving creating data structures. In the context of Analysis Services Execute DDL Task, this is a bit of a misnomer because its capabilities are much more diverse, extending to such areas as backups, restores, deletions, modifications, or processing. This is accomplished by employing Analysis Services Scripting Language (ASSL).
2011-09-07
2,257 reads
This script will allow you to update 2 databases with the same names, but different schemas/software/database versions.
2011-03-14 (first published: 2011-03-03)
2,189 reads
DDL triggers enable us to audit DDL changes but there are a few missing events, design decisions and installation complications.
2010-08-17
7,677 reads
By Steve Jones
vicarous – adj. curious to know what someone else would do if they were...
Say we have a database that we want to migrate a copy of into...
We are trying to get apps and users off of using SQL accounts to...
Hi I have this view to check if a job is running: SELECT...
All, if you are like me and do not care for the built-in color...
Certain internal SQL Server actions cause internal checkpoints. Which of these actions does not cause an internal checkpoint?
See possible answers