It's possible you are getting an error on the pathing that you don't see. The command will require that the account running SQL Server (service account) has rights to the...

This is very hard. There is no magic way for SQL Server to understand how any tables are related without constraints in place to enforce DRI. If the application developers...

I don't see it in the query, but as Eugene suggested, the error implies you had members.memberid_ in the query somewhere.

I'd double check that.

Patrick,

I'm not saying you should change or not complain. There are valid reasons to complain. I'm saying the complaints are overblown, and I'm not sure how many of them are...

j.a.c (5/15/2013)

---

We are currently evaluating NuoDb for a couple of possible uses.

So far the platform seems sound enough but we have only just started.

I can't wait to see...

So my thought was, as near as I can remember:

I do think the idea of having a separate OS view tablets makes sense. However Microsoft's insistence on trying to make...

Stefan Krzywicki (5/15/2013)

---

Steve Jones - SSC Editor (5/15/2013)

I don't think Stardock ate Microsoft's lunch. MS made a decision, and in hindsight, it seems not only to be a poor one,...

SQLRNNR (5/15/2013)

---

Stefan Krzywicki (5/15/2013)

---

Steve Jones - SSC Editor (5/15/2013)

I don't think Stardock ate Microsoft's lunch. MS made a decision, and in hindsight, it seems not only to be a poor...

garrett.moffitt (5/15/2013)

---

I have a table, Customer, with the CustomerID as an identity. I run this query:

select

customerID, count(city) as 'City'

into CustomerCities

from Customer

group by CustomerID

Does the CustomerCities table...

L' Eomot Inversé (5/15/2013)

---

I've seen a lot of ranting about how the different UI in Windows 8 makes it very difficult for someone used to older versions of Windows to...

AFAIK, the service account can log into Windows with a console, if you allow it, and map permanent drives that are retained.

This doesn't require the user connected to the instance...

Win 7 is a great upgrade. I'm not sure Win 8 is compelling from 7. From XP, either one.

For the most part, the only thing that I had to change...

We'll talk about it.

The hard part is categorizing and finding this info. We do include a number of these items in Database Weekly each week, with links to content that...

patrickmcginnis59 10839 (5/14/2013)

---

Lol I despise windows 8 / server 2012. Microsoft has also changed direction with their application programming tools to a stupid degree. Azure itself will probably have a...

Are you asking if there could be a place where people submit links to content on other sites that could be helpful?