Deploying SQL CLR assembly using Asymmetric key

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 not going to cover that in this blog. External_Access privilege allows the assembly to access…

5

Unable to do SQL Stored Procedure debugging remotely from VS2010

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 running on a Virtual Machine that was in a different domain than the domain…

0

How a DBA can confirm if Microsoft JDBC XA transactions are set

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 resolving his problem thought it would be easier for everyone if I blog…

0

ODBC drivers not visible in the ODBC Data Source Administrator (odbcad32.exe)

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 to take a backup/export of the registry key of an…

8