Find Deny permissions on database objects
This script allows the DBA to quickly determine if a deny statement is stopping a user from accessing db objects.
2015-01-14 (first published: 2014-12-17)
7,146 reads
This script allows the DBA to quickly determine if a deny statement is stopping a user from accessing db objects.
2015-01-14 (first published: 2014-12-17)
7,146 reads
This script is to verify which login accounts have SID values that don’t match the correct SID values defined on the machine or in the domain.
2015-01-12 (first published: 2014-12-24)
1,691 reads
This function is used to calculate the actual unit of conversion for temperature.
2015-01-09 (first published: 2014-12-11)
1,047 reads
If you want to find TotalPages, Usedpages,datapages,totalspaceMB,UsedSpaceMB,DataSpaceMB then can use this query.
2015-01-08 (first published: 2014-12-26)
1,543 reads
This function is used to calculate the actual unit of conversion for angle.
2015-01-06 (first published: 2014-12-10)
673 reads
This function is used to calculate the actual unit of conversion for area.
2015-01-02 (first published: 2014-12-10)
709 reads
This function is used to calculate the actual unit of conversion for mass.
2015-01-01 (first published: 2014-12-10)
569 reads
Use this script to generate BACKUP DATABASE scripts for selective or all databases during Instance or Database migration.
2014-12-31 (first published: 2014-12-10)
1,325 reads
This function is used to calculate the actual unit of conversion for energy.
2014-12-30 (first published: 2014-12-11)
747 reads
Always wanted to know the OS details? This function tells you everything (MSSQL 2008R2 and newer version only)
2014-12-29 (first published: 2014-12-06)
1,604 reads
Recently, in an attempt to thwart leechers (1990s kids will know), I added some...
Once upon a time I had a series about some cool stuff in Snowflake:...
By Steve Jones
“Most overnight successes – in fact any significant successes – take at least 5...
Komplek Ruko Roxy Mas, Jl. Kh Hasyim Ashari No.6 Blok C.5 No, RT.6/RW.8, Cideng,...
Jl. Gajah Mada No.203 205, RW.207, Benua Melayu Darat, Kec. Pontianak Sel., Kota Pontianak,...
Comments posted to this topic are about the item Why Successful SQL Server Backups...
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