Just a hunch given I can't know the actual data, but it could be that you need left/right joins rather than inner ones. The query you use will only return...

Ellen-477471 (4/15/2013)

---

Is there an easy way to find all the bound defaults on table objects.

We have an app where many of the tables have defaults bound to columns.

The defaults were...

simon.murin (4/17/2013)

---

Just a note - a SQL Server database...

I...

pcwik (3/14/2013)

---

I setup replication using the impersonate settings, so it's using the SQL Agent account which is domain and is an Admin on both boxes. I'm still getting the...

Would transactional replication work for you? You could replicate to another box which could then be accessed by those who need reporting, without affecting your live database. It's not usually...

Hi all

I managed to fix it. Confusingly, although the error message was on the publisher/distributor, the folder it was referring to was on the subscriber. I gave the distribution agent...

A good question, in that if you knew the behaviour being asked about, then it was easy to pick the correct answer as there was no unnecessary obfuscation.

I'm working backwards through the QODs at the moment after a bit of a gap, so hadn't seen the March 8th question. However,...

It did occur to...

Not a bad question, and got me thinking about other possible questions, so here goes - how many rows are returned in the two following cases?

-- Query 1

SELECT 'A'

UNION ALL

SELECT...

Good question, thanks.

Thomas Abraham (7/3/2012)

---

Thanks for the question. I thought it was bad enough being in America where most everyone uses mmddyyyy. But, yyyyddmm makes even less sense to me. Anyone know...

Stewart "Arturius" Campbell (7/3/2012)

---

Duncan Pryde (7/3/2012)

---

Good question. Is this related to the behaviour of datetimes versus datetime2s with the british language setting?

SET LANGUAGE BRITISH

GO

DECLARE @datevar datetime2 = '2008-12-13'; -- no...

I do, but it has been "by accident" in...