bret.lowery (8/8/2008)

---

Just as a side note FYI, there is legal precedence existing that excludes customer-added indexes from the legal definition of "source code" and thus protected assets under licensing law....

You should contact the Publisher.

Thanks for the feedback, John.

Thanks for the clarification guys.

Yes, that's why it is there. However, I believe that this is only used when rebuilding the...

My oldest son is a Bass Guitarist. I met Jack...

I checked the 2008 doc and apparently, they are all supposed to be precedence 3: http://technet.microsoft.com/en-us/library/ms190276(SQL.100).aspx.

Yeah, I tested a bunch of them, and the simplest answer is that ( ^, |, and & ) are really precedence 3 and ( +, - ) are really...

Iggy (8/7/2008)

---

@a^@a is a bitwise XOR, not an exponent operation. Any value XOR'd with itself is always 0. Subtracting 17 makes it -17, which is a negative number, and an...

tim_brimelow (8/7/2008)

---

And after experimenting with the power function I have found that Power(15,15) comes up with the wrong answer - I get 437893890380859392 and the correct answer is 437893890380859375. ...

To change the current query window:

Right-click in your SSMS Query window, select "Query Options..."

Select "Results..Grid". Then check "Include Column Headers...".

Use "Tools..Options.." from the main menu...

tim_brimelow (8/7/2008)

---

So two things crop up here,

1) how do you raise a number to a power in SQL server?

and

2) was the misspelling of enigma deliberate ( the author has used...

SQL Profiler can tell you this.

Well, you could just have them create objects in their own Schemas. That is after all what Schemas are for.

The only way that I can see to do this...

What have you already given them that allows them to Create PROC's in DBO?