Create Link Server Stored procedure to pass parama

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

Create Link Server Stored procedure to pass parama

Author

Topic

ismailc
Constraint Violating Yak Guru

290 Posts

Posted - 2010-02-24 : 13:46:32

Good day, I need help.

I normally create stored procedure directly on Linked server for SSRS to use.

But i got the error: Case expressions may only be nested to level 10.
select case ... from FC_LIVE.Flow.dbo.fcEventVal

but when i'm directly on the server where DB resides and execute, then it works
select case ... from dbo.fcEventVal

Now I have to create on my linked server for SSRS report, the administrator will allow me to create a stored procedure to call another stored procedure.

My stored procedure has a parameter that receive from the SSRS which comes through the Link stored proc.

So i need to create the Linked Stored Proc to execute the other stored proc on another server & DB with the Linked Proc parameter.

I think something like:

CREATE PROCEDURE [dbo].[FC0_RP_Track]
@process int
AS BEGIN SET NOCOUNT ON;

exec OtherServerdbProc @process

End

Or is there a way in Linked server to bypass the erro as i don't get the error on other server & DB where table resides

Please help & provide code

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources