'Microsoft OLEDB provider for Oracle' is not supported on 64-bit platforms. The Oracle driver should work fine though. The fact that you are getting "0 rows found"...

Making your user a member of db_datareader will grant the user read access to the entire database.

I think you want to remove any role memberships and grant select access just...

You should definitely read that article, it is very good but the solution presented there only works for integers.

I think something like this will get you close:

WHEN ISNUMERIC(Value) = 1...

IsNumeric indicates if the data can be converted to ANY numeric data type, not just Decimal(19,6).

For instance, IsNumeric returns a 1 for "2E7", as it could be considered exponential notation....

The problem with your approach is it doesn't account for the day rolling over to tomorrow when converting to UTC time (the hour goes past midnight).

I would approach the problem...

It appears to be adjusting for time zone.

I'm in Eastern Standard Time (during daylight saving), and the @Start and @End datetime being generated are offset by 4 hours.

Specifying...

Yet another reason. What a horrible design decision. :blink:

crussell-931424 (8/8/2013)

---

Interesting. I didn't realize that nullif is really a case statement and that any function would then get executed multiple times. Of course in this case the function is...

Excellent question.

I'm definitely going to remember this in the future.

As far as I know both are taken into account, with denies taking priority over grants.

I had this happen accidentally once when I was testing the effects of removing the...

Whoo, I learned from the last TDE question and got this one right! 😀

OCTom (7/12/2013)

---

I must be missing something. I'm sure someone can put me straight. This link says that you need to restore both the DEK and the certificate http://msdn.microsoft.com/en-us/library/bb934049.aspx. I chose...

and an order by in the select statement. 😉

Nice question Hugo!

Unfortunately I fell for the trap in the title.

Evidentally I have more studying to do of the RCS isolation level. :ermm:

Lokesh Vij (6/9/2013)

---

+1

Same here, I also marked the...