Monthly Archives: December 2013

SQL – How to find where a table column is used

If you ever get in the situation that you need to find out from which stored procedure/ function is a table column updated, this is a useful script: SELECT DISTINCT OBJECT_NAME(id) FROM syscommentsWHERE TEXT LIKE ‘%lookup_field%’ORDER BY OBJECT_NAME(id)

Posted in SQL | Tagged | Leave a comment

Run WcfTestClient on a server that doesn’t have Visual Studio installed

It was so easy to test the old fashion .asmx web services from the production servers, since you could just grab the link, put it in a browser and a full fledged test you could run on it. With the … Continue reading

Posted in WCF | Tagged , | Leave a comment