What concerns me most about this thread is that there appears to be a lack of understanding about maintaining a SQL Server and its files.

With the right backup strategy and...

We did some of this about 4 years ago under .Net 1.1 and c#.

While you get great intellisense out of your objects, we found that we struggled with the...

Being a design problem, there might be a few other things that we would need to know to be of help to you.

Is the inner procedure dependant on the outer...

Found this in BOL (SQL 2005)

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/repref9/html/d0637fc4-27cc-4046-98ea-dc86b7a3bd75.htm

Might be helpful in explaining how the restore of a subscription database will work.

OK, I did a little review by commenting each query and this is what I came up with

-- based on the pk supplied, get the new date modified

It might seem a little obvious, but check the indexing you have on the table against the joins for your filters.

We experienced similar symptoms to this in SQL 2000 a...

this works the way John described it

create table #temp_india

(

word varchar(20) )

go

insert

#temp_india (word

You may need to broaden the scope of your question.

Which replication mechanism are you referring to?

For a brief summary

Snapshot - the whole subscriber gets overwritten manually/automatically (scheduled), no updates...

Well, that was certainly an interesting read. Who needs Coronation Street!

So, what have I learnt today?

1. If I have a database that allows NULL values in some fields, I am now better...

I think the key question you have asked is "how to build this architecture into your environment".

Slowly. If you already have many established applications running, but not really working...

I agree with Tatsu and Webrunner.

I always thought XML was just a way to transport data in a formatted fashion, mimicking or simplifying the relational structure from the storage engine -...

If they are temporary tables, why are you trying to drop them? They should go out of scope whenever the stored proc is completed.

My guess is that you tested the...

I have done this before with c#. So it shouldn't be too difficult to get it done in VB.Net.

Here is a link that might be helpful

http://aspalliance.com/1081_CLR_Integration_in_SQL_Server_2005

I haven't tried this...

I presume that the columns names in the temp table match the column names being returned from the stored procedure?

Could it be something as bizarre as having to declare the...

Simple and to the point Jack. I agree.

Those that were honest enough to point out the mistake get the reward. Those who were devious have to pay.

Amazon comes out...