<div>
<div class="content wysiwyg-content">
I am calling sp which is in sybase using linked server in sql server 2005. This SP ( In Sybase ) inserting records in Table.<br />
There is no space in sybase n the message I am getting in calling sp ( In sql server having Try Catch ) is<br />
&quot;Could not execute statement on remote server 'SYBASE_SPHERE'.&quot;<br />
<br />
Whereas the exact exception is &quot;Can't allocate space for object 'table1' in database 'LinkedServer' because 'default' segment is full/has no free extents. If you ran out of space in syslogs, dump the transaction log. Otherwise, use ALTER DATABASE to increase the size of the segment.&quot; which I am not getting as error description in Catch Block of sql server.<br />
<br />
I have implemented proper error handling machenism in Sql server i.e. using Try Catch etc.<br />
<br />
Is there any way to get the exact error info in sql server from sybase. Pls suggest<br />
<br />
Hopefully looking forwrad to hearing from you.
</div>
</div>


I am calling sp which is in sybase using linked server in sql server 2005. This SP ( In Sybase ) inserting records in Table.
There is no space in sybase n the message I am getting in calling sp ( In sql server having Try Catch ) is
"Could not execute statement on remote server 'SYBASE_SPHERE'."

Whereas the exact exception is "Can't allocate space for object 'table1' in database 'LinkedServer' because 'default' segment is full/has no free extents. If you ran out of space in syslogs, dump the transaction log. Otherwise, use ALTER DATABASE to increase the size of the segment." which I am not getting as error description in Catch Block of sql server.

I have implemented proper error handling machenism in Sql server i.e. using Try Catch etc.

Is there any way to get the exact error info in sql server from sybase. Pls suggest

Hopefully looking forwrad to hearing from you.

Unable to get exact error from Sybase Sp to Sql Server 2005

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.

Microsoft SQL Server 2005

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Sybase, a subsidiary of SAP, builds a client/server relational database management system. Products include Adaptive Server Enterprise (ASE), Adaptive Server Anywhere (ASA), Sybase Unwired Platform (SUP) for mobile applications, Afaria for enterprise mobile device management and IQ for data warehouse and big data applications.