Data migration of large Sybase tables may cause TEMPDB errors

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. If you ran out of space in syslogs, dump the transaction log. Otherwise, use ALTER DATABASE to…

0

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

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 reproduce the problem: After migrating an Oracle sequence to SQL Server 2008R2, where the SQL Server target…

2

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

Troubleshooting “Cannot create an instance of OLE DB provider”

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, but everything explained in this blog holds good for any linked…

9

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

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 situation we can verify ourselves, which support…

1

Calling SSIS Execute Process task from a remote batch file.

This post describes an interesting scenario that I came across when working with a SSIS package developer. The main issue was that we were unable to run the SSIS package that contains a execute process task calling a batch file stored on a remote server machine (without being prompted by a warning window). The following…

4

SSMA 5.0 for Access and the DAO requirement

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, Sybase, MySQL and Access to SQL Server. Today I am going…

2