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...
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