Hi All,

I have been able to resolve the issue after executing the following command on server A:

EXEC sp_serveroption @server = 'ServerB',@optname = 'remote proc transaction promotion', @optvalue =...

Hi,

If someone has added a foreign key constraint, why would he write a query like this.

So, I have a small query that does having foreign key constraint improves the...

Instead of

SELECT * INTO ##TEMP

FROM

T_SP_UPDATE_ITEM_DETAILS '139',30,'TB'

write

SELECT * INTO ##TEMP

EXEC T_SP_UPDATE_ITEM_DETAILS '139',30,'TB'

If you expect to select only one value for each column, I would recommed you to use OUT variables.

However, if there can be multiple values, then the above solution is...