How to read the error message #Error.

Hi,
My custom code i have written try catch end try block and in the catch
section just i returned the err.description. But locally it was working fine.
Once deployed it was not working fine. just showing #error. Any help would
be appreciated.
Regards,
Sri.On Jun 25, 2:36 pm, Sriman <Sri...@.discussions.microsoft.com> wrote:
> Hi,
> My custom code i have written try catch end try block and in the catch
> section just i returned the err.description. But locally it was working fine.
> Once deployed it was not working fine. just showing #error. Any help would
> be appreciated.
> Regards,
> Sri.
This is a long shot, but you could try checking the Event Viewer:
Application Errors log -or- you could try adjusting the Custom Errors
section of the Reports or ReportServer virtual directories (via: Right-
click -> Properties -> Custom Errors tab) -or- add custom code to the
report (via: Layout view -> Report drop-down -> Report Properties... -
> Code). Sorry that I could not be of greater assistance.
Regards,
Enrique Martinez
Sr. Software Consultant

How To Query A Linked Server

Hey all. I'm having a slight problem and was hoping I could use
linked servers to solve it. Basically I've developed a web app
locally using SQL 2005 Express and need to import the data to a web
hosting facility SQL 2005 server. I can see the production server in
management studio and have set up a linked server. However I'm not
sure how to query the database and then ultimately select from my
local db and insert it into the new db tables.
First problem is the linked server address. It's the following:
sqlXXXX.mssqlservers.com
When I query the linked server I get this.
The object name 'sqlXXXX.mssqlservers.com.MyDB.dbo.MyTable' contains
more than the maximum number of prefixes. The maximum is 3.
Is the linked server route the best way for me to import this data? I
need to get the data in ASAP for this client.
Thanks.Hi,
Use: '[sqlXXXX.mssqlservers.com].MyDB.dbo.MyTable'
--
Thank you,
Daniel Jameson
SQL Server DBA
Children's Oncology Group
www.childrensoncologygroup.org
<rh1200la@.gmail.com> wrote in message
news:1190655841.782199.125430@.19g2000hsx.googlegroups.com...
> Hey all. I'm having a slight problem and was hoping I could use
> linked servers to solve it. Basically I've developed a web app
> locally using SQL 2005 Express and need to import the data to a web
> hosting facility SQL 2005 server. I can see the production server in
> management studio and have set up a linked server. However I'm not
> sure how to query the database and then ultimately select from my
> local db and insert it into the new db tables.
> First problem is the linked server address. It's the following:
> sqlXXXX.mssqlservers.com
> When I query the linked server I get this.
> The object name 'sqlXXXX.mssqlservers.com.MyDB.dbo.MyTable' contains
> more than the maximum number of prefixes. The maximum is 3.
> Is the linked server route the best way for me to import this data? I
> need to get the data in ASAP for this client.
> Thanks.
>