Tag Archives : linked servers

A Fairy Tale

Once upon a time there was a developer who was concerned about the security of his application’s data.  So he decided to change the password for his application’s SQL login.  So he logged into the database and used sp_password to change his password and he was happy. On the other end of the hall lived […]

Call me Ishmael

This week I’ve been chasing my own white whale.  Another developer came to me with this little problem.  A query he was trying to run over a linked server to an Oracle database was returning unexpected results.  Here’s his original query: select count(order_num) from openquery(PROD, ‘select t2.order_num from myschema.mytable t2 where open_date < to_date(”01-JAN-2011”, ”DD-MON-YYYY”) […]