Error Creating Remote Distributor When Creating a Local Distributor
Recently, I was working on a Peer-to-peer replication automation project. When I switched from my local test servers to some...
2015-04-16
762 reads
Recently, I was working on a Peer-to-peer replication automation project. When I switched from my local test servers to some...
2015-04-16
762 reads
The April Blogger Challenge is from Ed Leighton-Dick and aimed at new bloggers, but anyone is welcome. I’m trying to...
2015-05-01 (first published: 2015-04-16)
5,251 reads
Just a brief note today to point to an article by Time Ford on SQLMag.com announcing that SQL Server 2014 SP1 has...
2015-04-16
636 reads
I spend many of my evenings researching and writing. Sometimes it’s writing new books. Sometimes it’s fixing and rewriting old...
2015-04-16
689 reads
This post is part of a series on this blog that will help me, and hopefully you, pass exam 70-463: Implementing...
2015-04-28 (first published: 2015-04-16)
5,347 reads
Last year, I was very much honored to be selected to deliver a pre-con with my friend brother Chris Shaw (B|T). I...
2015-04-16
425 reads
2015-04-16
543 reads
I was recently asked to do some fairly heavy modifications to a table. It involved adding 6 new columns, removing...
2015-04-16
1,755 reads
Today we’ll learn how you can use T-SQL to calculate your zodiac sign from your birthdate.
“Heeeeeere’s Johnny!” – Ed McMahon introducing...
2015-04-16
1,360 reads
Every now and then we will need to convert datetime to string for display, and would you remember all the...
2015-04-16
461 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