AFAIK you need to reset replication. The...

MiguelSQL (5/16/2013)

---

The title of article is misleading. I though someone figured out a way to rename the actual instance, which right now it is not possible (in a nice supported...

Eric M Russell (5/16/2013)

---

...

There could also be honeypot tables. For example, the DBA could create tables with enticing names like [Employee_Salary] or [Customer_CreditCard] and then place an audit event with...

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