NT-machines... hmm... which servicepack and which sql server version?

Do the tables have a primary key?

Both servers have MSDTC service running?

Have you rebooted the machines?

=0 is false

<>0 is true

Is one of the servers OS windows 2003?

http://support.microsoft.com/default.aspx/kb/839279?

sequence:

shopping cart : adding things that are in promotion and minimum profit 5 $

insert into shopping_cart

from promotion

inner join articles on articles.promotionid=promotion.id and promotion.discount>5$

->before adding it filters all promotions that has...

my select was still bugyy

Thanks for the solution!

In the second query you can replace

WHERE  A.Application_Key In (Select Application_Key From peoplefirst_datawarehouse.dbo.application    

Where valid_application_flag = 'Y')

WHERE  EXISTS (Select Application_Key From peoplefirst_datawarehouse.dbo.application    

Where valid_application_flag...

What is the patch level of the sql server?

http://www.fogcreek.com/FogBugz/KB/dbsetup/FullTextSearch.html

discusses how to setup FTS

1) Have you installed the oracle client on the server?

2) Have you rebooted the server afterwards?

3) Can you connect to the linked server by using the Oracle Tools on the...

Can you use the sql profiler to trace your stored procedure?

If I use this:

"select max(id) from ... where max(id) < @parameter" - for the previous row &

"select min(id) from ... where min(id) > @parameter" - for the next row

I think...

In access you can relink your linked tables dynamically using VBA.

http://www.mvps.org/access/tables/tbl0012.htm

You could read in the connection setting using a startup parameter, configuration file ...)

What servicepack are your sql servers running at? SP3 or SP4?

At which keyword have you seen that implicit transaction is linked to

ANSI_NULL_DEFAULT ?

SQL options control ANSI compliance options.

ANSI_NULL_DEFAULT

Allows the user to control the database default nullability. When NULL...

Any dynamic sql breaks the ownership chain.

Perhaps you could make a view which is an union of the history tables, and have your stored procedure select on the view.

Then you...

since you expect name as output parameter

CREATE PROCEDURE STUDENT (@CARD varchar(27), @CODE int, @YEAR int, @SEMESTER char(10), @CLASS varchar(50) output, @NAME varchar(20) OUTPUT) (output was missing)

Sure semester is char(10) and...