The script will produce a Drop/Create script for all the jobs existing on the server. Instead of scripting them individually.
The output script will also have schedules scripted out
2009-09-18 (first published: 2009-09-08)
7,323 reads
This script will list columns data type and size for every table in a database.
2009-09-15 (first published: 2009-09-02)
2,020 reads
Query to generate a dynamic Select statement from any table for moving data between servers.
2009-09-11 (first published: 2009-09-01)
1,622 reads
this code encrypts all stored procedures that meet a certain format. this code is easy to change to suit your particular needs, but be sure to back up your stored procs first.
2009-09-10 (first published: 2008-11-21)
3,334 reads
2009-09-09 (first published: 2009-08-31)
1,319 reads
2009-09-08 (first published: 2009-08-31)
491 reads
To find date at nth occurrence of a weekday in a month and year
2009-09-07 (first published: 2009-09-01)
756 reads
2009-09-04 (first published: 2009-08-31)
2,298 reads
This script copies all tables found in a specific filegroup to another specific filegroup.
2009-08-19
123 reads
Find all Procedures, Views, Functions that have been renamed with sp_rename where syscomments does not match.
2009-08-17 (first published: 2009-08-06)
966 reads
Creating a Fabric workspace takes about 30 seconds. Restructuring workspaces after people have built...
By Steve Jones
It’s a small change, but a handy one. Flyway Desktop (FWD) now includes the...
By Steve Jones
Software is hard. While I love our Lucid Gravity, I realize that they are...
Comments posted to this topic are about the item Adding new column with DEFAULT...
Comments posted to this topic are about the item Advanced Deployment Scenarios: Stairway to...
Comments posted to this topic are about the item You Need a DBA Pipeline
Which number did the two COUNT(*) return:
DROP TABLE IF EXISTS #tmp CREATE TABLE #tmp (id INT NOT NULL) INSERT INTO #tmp (id) SELECT gs.value FROM GENERATE_SERIES(1, 5) AS gs ALTER TABLE #tmp ADD my_value INT NOT NULL CONSTRAINT df_tmp_my_value DEFAULT 1 SELECT COUNT(*) FROM #tmp AS t WHERE my_value = 1 ALTER TABLE #tmp DROP CONSTRAINT df_tmp_my_value ALTER TABLE #tmp ADD CONSTRAINT df_tmp_my_value DEFAULT 2 FOR my_value SELECT COUNT(*) FROM #tmp AS t WHERE my_value = 1See possible answers