Can't you confirm if updated data is flowing by updating a record on Server A and querying for the same record in Server B.

If the value stands updated that clarifies...

Are you sure the reinitialization is complete? It's not waiting for response from the server? Do we have Undistributed commands ??

You can start by researching for these and getting back...

Deleting file from filesystem using a BATCH file won't have any issues in your restore process / MSDB.

The only thing in my view you should be concerned about is ensuring...

I'd also like to confirm that Mike's solution worked perfectly.

Untill I reached this thread I was trying out all sort of things but my replication wasn't working.

As soon as I...

Hi Michael,

When I tried with a test data on SQL Server 2008 inserts were successful.

Perhaps, I'd like to try with your table definition & some test data if you can...

Hi Guys,

I'm so sorry I couldn't pitch in before.

@Wayne:...

Thanks Wayne,

Your solution fits the bill till ZZZZ. I think for the time being does solve my problem.

But as you suggested a possible better solution may be forthcoming. I'm surely...

Thanks Stewart,

Your solution worked like a charm. But if I'm not bothering much can you guide me where I was wrong in my trials. 🙂

Ankur: Thanks to you too. Your...

Thanks vstitte

I had already tried your second suggestion but didn't wanted to change SP that way.

Your suggestion to explicitly put NULL seems to have worked. With this suggestion...

Hi Nagaraj,

MSSQL internally gives a different name for each temp table which it can uniquely identify. I'm very sure of this that same name #tbl shouldn't affect.

Still I tried it...

Though I was very sure that I'm pointing to correct SP on correct server I have once again checked and it's correctly pointed.

This whole thing was working perfectly well in...

Perhaps the same issue can be regenerated using the following commands

CREATE PROCEDURE sp_testing as

CREATE TABLE #test (testcol1 int,testcol2 int)

INSERT INTO #test VALUES (1,NULL)

SELECT * FROM #test

---------------------------------------------------

DECLARE @ReturnValue INT EXEC...

As desired,

Complete procedure attached.

I hope it helps.

Ankit

Do the procs always get called like this or is there some place where just the inner one is called?

Can you post the code (or demo code with the same...

If it can work 1 level deep why not 2 level. Not even by any workaround????

I was looking for some innovative work around if possible.

But as you suggested I think...