In my opinion, One of the most complex part in deploying SQL CLR stored procedure is when you need to enable it for “External_Access” or “Unsafe”. The third option is “Safe” , this is pretty straight forward and I am...

This post describes an interesting scenario that I came across when working with on Visual Studio Project based issue. In this situation, customer was unable to debug stored procedures on a remote SQL Server using Visual Studio. The SQL Server was...

I am from Microsoft SQL Developer Support team, we support many data access technologies. Recently I had a chance to work with SQL DBA, who was facing issue to confirm to his developers whether XA transactions were configured correctly or not. After...

I recently had an issue where after the installation of a Third party Client side tools, we were not able view the drivers listed in the ODBC Data Source Administrator (odbcad32.exe). In order to create a DSN to use this third party driver, we had...