Msg 7395: Unable to start a nested transaction

Happy new year, SQL peeps! I hope everyone had a wonderful holiday. Last week was very quiet at work, but I did have a developer email me with a problem she was having. (I do believe she may have been the only one actually working, can you imagine??) But that’s ok, I love using this [...]

January 5, 2012  Tags: , , ,   Posted in: T-SQL, Troubleshooting  2 Comments

SQL Server A to Z – OPENQUERY

Good morning SQL people! It’s time for another installment of SQL Server A to Z.В  We’re up to the letter O, which immediately brings to mind the song from Sesame Street, “Would you like to buy an O?”В  (Circular and sweet. “O” looks just like a donut. Really good enough to eat…) You’re welcome. OPENQUERY [...]

September 29, 2011  Tags: , ,   Posted in: T-SQL  No Comments

A Fairy Tale – Epilogue

When the cheers subsided and the parade was over (oh yes, there was a parade;В  complete with floats and bagpipes), the DBA found herself dissatisfied.В  There was a minor detail that was nagging at her.В  What about those linked servers that used an alias?В  With her original query, the remote server would be the alias [...]

March 31, 2011  Tags: , ,   Posted in: General, T-SQL  No Comments

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

March 28, 2011  Tags: ,   Posted in: General, T-SQL  No Comments

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”) [...]

February 25, 2011  Tags: , , , , ,   Posted in: Troubleshooting  No Comments