SQL 2005 Get Roles, Schemas & Object Permissions
Pulls all DB/Server fixed roles, default schemas & object permissions for all logins
2008-11-28 (first published: 2008-10-25)
2,430 reads
Pulls all DB/Server fixed roles, default schemas & object permissions for all logins
2008-11-28 (first published: 2008-10-25)
2,430 reads
Often during the development lifecycle columns are added to tables that become redundant or remain unused.
this script removes unused (empty) columns
2008-11-27 (first published: 2008-10-22)
1,204 reads
Get the all the SQL Server related services information,
2008-11-26 (first published: 2008-10-13)
1,292 reads
2008-11-25 (first published: 2008-10-20)
1,347 reads
This is related to my other autogenerate code. this is just an example of how to use it.
2008-11-21
800 reads
use metadata to generate basic create procedure statements for insert update and select
2008-11-21 (first published: 2008-10-10)
3,877 reads
2008-11-20 (first published: 2008-10-06)
1,013 reads
this is a MUCH simpler method of random randomize randomise rand data from a table
2008-11-19
322 reads
Find indexes associated with queries and vice versa. Helps figure out what procedures are using indexes.
2008-11-18 (first published: 2008-07-31)
1,727 reads
Script to found out how much time before Restore or Backup Process remain
2008-11-17 (first published: 2008-09-30)
1,075 reads
By Steve Jones
semaphorism – n. a conversational hint that you have something personal to say on...
This week I was at PASS Data Community Summit in Seattle, and I attended...
By James Serra
(This is the third post in a three-part series on how AI is changing...
Comments posted to this topic are about the item Pay for Performance, which is...
WhatsApp:0817819444 Jl. Pemuda No.3 C, Tawangsari, Leteh, Kec. Rembang, Kabupaten Rembang, Jawa Tengah 59217
WhatsApp:0817819444 Jl. Pemuda No.57B, Blora, Tempelan, Kec. Blora, Kabupaten Blora, Jawa Tengah 58211
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