[lnkForumImage]
TotalShareware - Download Free Software
Confronta i prezzi di migliaia di prodotti.
Asp Forum
 Home | Login | Register | Search 


 

Forums >

microsoft.public.sqlserver.programming

Problem with executing procedure on 2005(SP1) with connection to 2000 (SP4)!!!

mladjo

3/22/2007 8:53:00 AM

Hi.

We have this situation:
1. A procedure on SQL 2005 (SP1) run against SQL 2000 (SP3) ---> it
works fine
2. We installed SP4 on SQL 2000 and there is following problem:
procedure continue working for unlimited amount of time and when I try to
stop execution I wait some amount of time and recieve some errors; execution
of stored procedure on SQL 2005 against SQL 2000 (SP4) is not possible now
3. If I try to execute code inside of procedure it works fine, but if I
execute that procedure it doesn't work
4. We solve the problem with creating a file with T-SQL code from
procedure and we execute code with EXEC xp_cmdshell 'myprocedure.sql', it
works fine but this is a temprorarly solution

Does anybody ever met this problem and is there any solution of this
problem?? I suppose that the main reason for not executing my procedure is
SP4 installed later on SQL 2000.




Mladen.


2 Answers

masri999

3/22/2007 9:07:00 AM

0

On Mar 22, 1:53 pm, "mladjo" <mladjoce...@yahoo.com> wrote:
> Hi.
>
> We have this situation:
> 1. A procedure on SQL 2005 (SP1) run against SQL 2000 (SP3) ---> it
> works fine
> 2. We installed SP4 on SQL 2000 and there is following problem:
> procedure continue working for unlimited amount of time and when I try to
> stop execution I wait some amount of time and recieve some errors; execution
> of stored procedure on SQL 2005 against SQL 2000 (SP4) is not possible now
> 3. If I try to execute code inside of procedure it works fine, but if I
> execute that procedure it doesn't work
> 4. We solve the problem with creating a file with T-SQL code from
> procedure and we execute code with EXEC xp_cmdshell 'myprocedure.sql', it
> works fine but this is a temprorarly solution
>
> Does anybody ever met this problem and is there any solution of this
> problem?? I suppose that the main reason for not executing my procedure is
> SP4 installed later on SQL 2000.
>
> Mladen.

If this is a link server Check Dynamic properties and nested queries
in the provider options . Make sure RPC selected and also use remote
collation deselected ( I assume you are on the same collation)

What error you are encountering is not posted

mladjo

3/22/2007 9:33:00 AM

0

We have linked server with these options:
- collation compatible FALSE
- rpc FALSE
- use remote collation TRUE
- collation name (empty)

We have different collations on these servers!!





"M A Srinivas" <masri999@gmail.com> wrote in message
news:1174554447.816683.183970@l77g2000hsb.googlegroups.com...
> On Mar 22, 1:53 pm, "mladjo" <mladjoce...@yahoo.com> wrote:
>> Hi.
>>
>> We have this situation:
>> 1. A procedure on SQL 2005 (SP1) run against SQL 2000 (SP3) ---> it
>> works fine
>> 2. We installed SP4 on SQL 2000 and there is following problem:
>> procedure continue working for unlimited amount of time and when I try to
>> stop execution I wait some amount of time and recieve some errors;
>> execution
>> of stored procedure on SQL 2005 against SQL 2000 (SP4) is not possible
>> now
>> 3. If I try to execute code inside of procedure it works fine, but if
>> I
>> execute that procedure it doesn't work
>> 4. We solve the problem with creating a file with T-SQL code from
>> procedure and we execute code with EXEC xp_cmdshell 'myprocedure.sql', it
>> works fine but this is a temprorarly solution
>>
>> Does anybody ever met this problem and is there any solution of this
>> problem?? I suppose that the main reason for not executing my procedure
>> is
>> SP4 installed later on SQL 2000.
>>
>> Mladen.
>
> If this is a link server Check Dynamic properties and nested queries
> in the provider options . Make sure RPC selected and also use remote
> collation deselected ( I assume you are on the same collation)
>
> What error you are encountering is not posted
>