Browse by Tags

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

SQL Server Support Content

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 ...read more

on 27 Oct 2011
Blog Post: ODBC drivers not visible in the ODBC Data Source Administrator (odbcad32.exe)

SQL Server Support Content

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 ...read more

on 18 Oct 2011
Blog Post: Deploying SQL CLR assembly using Asymmetric key

SQL Server Support Content

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 ...read more

on 28 Oct 2011
Blog Post: Unable to do SQL Stored Procedure debugging remotely from VS2010

SQL Server Support Content

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 ...read more

on 27 Oct 2011
Blog Post: SSMA 5.0 for Access and the DAO requirement

SQL Server Support Content

My name is Angshuman Nayak and I am a part of SQL Developer support in Microsoft and work mostly around connectivity and data access technologies. As one of my activities I am helping customers and partners to move from various data bases like Oracle ...read more

on 5 Aug 2011
Blog Post: Data migration of large Sybase tables may cause TEMPDB errors

SQL Server Support Content

Problem: During data migration of a large Sybase table using SSMA 5.x for Sybase ASE, the following error may occur: "Can't allocate space for object 'temp worktable' in database 'tempdb' because 'system' segment is full/has no free extents. ...read more

on 17 Nov 2011
Blog Post: Troubleshooting “Cannot create an instance of OLE DB provider”

SQL Server Support Content

Today I am going to blog about a frequent issue that we come across while creating linked server-: Cannot create an instance of OLE DB provider "MSDADASQL" for linked server "MyDB2" In this scenario I was creating a linked server to a DB2 server ...read more

on 28 Sep 2011
Blog Post: ‘Login Failed’ ERRORLOG message from SSMA 5.1 for Oracle’s sequence emulator

SQL Server Support Content

Problem: Sporadically, the SSMA 5.1 Oracle sequence emulator causes login failure (Error: 18456, Severity: 14, State: 8) error messages to be written to the SQL Server ERRORLOG when used from an application using SQL authentication. Steps to ...read more

on 17 Nov 2011
Blog Post: How to verify if the issue is due to linked server or provider

SQL Server Support Content

When we create a linked server to a database Other than SQL server, like Sybase , Oracle , DB2 etc ,we see some errors and we are not sure whom to contact for support. Should we contact Microsoft support or the third party support. In such an ambiguous ...read more

on 19 Aug 2011

Products

Resources

Solutions

Updates

Trials

Related Sites

Training

Certifications

Other resources

Support options

More support

Not an IT pro?

SQL Server KBs and Blogs

Browse by Tags

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

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

Blog Post: Deploying SQL CLR assembly using Asymmetric key

Blog Post: Unable to do SQL Stored Procedure debugging remotely from VS2010

Blog Post: SSMA 5.0 for Access and the DAO requirement

Blog Post: Data migration of large Sybase tables may cause TEMPDB errors

Blog Post: Troubleshooting “Cannot create an instance of OLE DB provider”

Blog Post: ‘Login Failed’ ERRORLOG message from SSMA 5.1 for Oracle’s sequence emulator

Blog Post: How to verify if the issue is due to linked server or provider