Searching Column Name in All Tables
Use this script to search for a specific column name in all tables in a current database.
2010-01-01 (first published: 2009-12-09)
1,990 reads
Use this script to search for a specific column name in all tables in a current database.
2010-01-01 (first published: 2009-12-09)
1,990 reads
Automate All Database Backups with this script. handle full, diff, and log backups.
2009-12-31 (first published: 2009-12-15)
2,703 reads
2009-12-30 (first published: 2009-12-15)
1,083 reads
2009-12-23 (first published: 2009-11-26)
657 reads
To see the frequency of alerts in use, you can reset their fire count.
Restart count from zero for all alerts using the propre stored procedures.
2009-12-22 (first published: 2003-01-14)
535 reads
Synchronize source code between two servers for multiple stored procedures
2009-12-21 (first published: 2009-11-26)
2,302 reads
2009-12-18 (first published: 2009-11-26)
636 reads
2009-12-17 (first published: 2008-07-13)
1,877 reads
This script will synchronize all stored procedures between two servers, using spSynchStoredProcedure.
2009-12-15 (first published: 2009-11-26)
2,227 reads
2009-12-14 (first published: 2007-10-19)
1,373 reads
By Steve Jones
semaphorism – n. a conversational hint that you have something personal to say on...
By James Serra
(This is the third post in a three-part series on how AI is changing...
Continuing with my takeaways from SQLCon and FabCon Europe in Barcelona, let’s talk about...
Comments posted to this topic are about the item Pay for Performance, which is...
Jl. PB.Sudirman No.40, Tekoan, Tanggul Kulon, Kec. Tanggul, Kabupaten Jember, Jawa Timur 68155
Jl. YOS Sudarso No.49, Dusun Kp. Baru, Jajag, Kec. Gambiran, Kabupaten Banyuwangi, Jawa Timur...
I have a table, dbo.bittest, where I am testing an application response. This has this structure:
CREATE TABLE [dbo].[BitTest] ( [insertdate] [datetime] NULL CONSTRAINT [DF__BitTest__insertd__300F11AC] DEFAULT (getdate()), [a] [bit] NULL ) ON [PRIMARY] GOMy application runs this code:
INSERT dbo.BitTest
(
insertdate,
a
)
VALUES
(DEFAULT, 'true')
GO
See possible answers