Effective Permissions on a Database
written by David Postlethwaite
Ever wondered who has what access to your database or a particular object within? With the ever...
2011-07-14
2,348 reads
written by David Postlethwaite
Ever wondered who has what access to your database or a particular object within? With the ever...
2011-07-14
2,348 reads
In order to keep the content fresh and the posts flowing here on my blog I have decided to publish...
2011-07-13
602 reads
I have seen this question come up several times over the last few months. Can you delete from a view?...
2011-07-11
57,730 reads
After posting on twitter last week that I needed something to write a blog post about my good friend Christian...
2011-06-15
690 reads
After posting on twitter last week that I needed something to write a blog post about my good friend Christian...
2011-06-14
857 reads
I was going to write a short post showing some useful queries that can help you manage your vCentre environment,...
2011-06-10
516 reads
Amazingly It’s been just over 4 months since I started my list of UK based SQL Server bloggers, and I...
2011-05-03
599 reads
This is a little off topic:
Well Well, it’s the 29th April and all being well in about 2 hours from...
2011-04-29
1,535 reads
Its the sale of the century. To coin a cleaned up phrase from a Guy Ritchie film (either Snatch or...
2011-04-27
648 reads
It was announced yesterday that the cost of taking a Microsoft exam will increase from the 1 July. In the...
2011-04-27
2,411 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...
Comments posted to this topic are about the item Helping an English Student with...
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