do you mean install SQL Server 2008 R2 and use a SQL Server 2012 license for legal purposes? AFAIK, that is allowed under volume licensing rights

https://www.google.com/url?sa=t&rct=j&q=&esrc=s&source=web&cd=1&cad=rja&ved=0CC4QFjAA&url=http%3A%2F%2Fsocial.msdn.microsoft.com%2FForums%2Fsqlserver%2Fen-US%2Fa9a8c9fc-e9b6-42fd-a7c2-be46722ee9cb&ei=AkPUUb3uAaXUygHro4GgCg&usg=AFQjCNFvytL176AWvlh8AmHdn9hHpVi9LQ&bvm=bv.48705608,d.aWc

I don't know what happens...

this doesn't make sense

I'm not sure what you mean....

I don't think there's a better way to do this in general. T-SQL isn't great at string manipulation.

In SQL Server, you have an instance that contains control information, scheduling, logins, etc. and then you can have multiple databases inside the instance. The instance is at a higher...

AFAIK, Gail is correct. If the columns in the NC index are not changed with an update, that index is not touched. No reason to, as there's nothing to update.

How will you run it?

You could schedule it with SQL Agent, but the Agent would need to be able to access the folder.

It doesn't matter how you write a SQL...

We did something similar in a financial system by putting in data and fields that marked as "as of" a certain date. This allowed us to join tables together based...

In addition to Eugene's notes, you can use a CASE statement to change things around.

case

When x = 5 then 1

when x = 4 then 2

end

You can't use ms_foreachdb to insert a parameter into a query that's directly executed. You need to submit a query as a parameter.

Luis has shown you how this would work.

crussell-931424 (7/3/2013)

---

What I worry about is the data getting degraded, "accidentally" changed or whatever, as it moves from one location to another. For example, in your editorial I noticed a...

Whether you agree/believe with/in religion, GWaK does raise a good point that many people that go are very giving. They feel it to be a part of their religion. Is...

Eric M Russell (6/28/2013)

---

LOL! I do recall once, in the aftermath of a delete script gone wrong, querying the transaction log for a clue about what stop date/time to use...

Hope things are well.

I didn't write this because of religion or government.

I have spoken on this before, and I do think it's important. Being a part of some sort of non-profit or...

jasona.work (7/1/2013)

---

You know, reading the end result of this topic: http://www.sqlservercentral.com/Forums/Topic1468850-2799-1.aspx, I'm wondering why MS doesn't provide a pair of radio buttons in several different places...

Radio button 1 -> MB

Radio...