Yes, I thought the same...

READUNCOMMITTED

It should resolve my problem. 'll try....

a solution may be:

variable or temp tables?

I forgot to write the that there is also a cursor that read what table must be processed on dbB procB:

I mean:

create procA

as

sqlcode

exec procB

sqlcode

go

--end of procA

procB is:

create procB

as

begin tran

declare...

Thank for your suggestion

Because some store proc have to open a connection with linked server and because they run on servers that I do not manage (and I do not where they are).....to have...

Thank for your suggestion...

I'll try the steve solution....very interesting..

I mean:

using t-sql,  how can I verify if another process like a store proc (named usp_myproc) is running or not (without using enterprise manager, sql profiler and so on...)?

thank ......

Thank to everybody.......

Thank to everybody,

added local server and stop/restart server .......OK

Thank a lot,

I'll try your suggestion

My config are:

SQL Server properties (configure) local (tab: security):

 - SQL server authentication

Start service account: Start and run SQL server in the following account:

 - system account.

Registered SQL Server Properties:

Use SQL server...

Hi,

I used - T arguments, but:

if the bcp is run directly on the windows command prompt, it works.

if the bcp is run from sql : EXEC @RetError = master..xp_cmdshell @RunCmd ...

Thank

Thank to everybody...for your suggestion.

I thought that someone asked "What a strange question !"

There is a reason but it is too long explain ....just some words.....

I'm building a long procedure...

check also - S is the right server e. g. localhost