GilaMonster,

That works well.

I don't understand it but it works. If you or someone else could explain to me how this works that would be great.

Thanks.

Ok Thanks.

Ok. According to the link, It looks like I have to uninstall SQL 2000 Personal Edition and install SQL 2000 Developer Edition right?

Thanks sergiy. I knew there was some way to do it without a temp table.

Thanks Farrell.

Its not slow! I just wanted to return 1 value(column) as opposed to 5 values (5 columns). I think it can be done with IF and ELSE IF. I'm trying...

Thanks Phil. I feel so dumb right now!

Try sp_addserver. Have a look at BOL for the syntax.

Not sure whats going on but I got around it by doing the following and from teh .Net Application, I'm passing the StartDate & EndDate as strings.

CREATE PROC USP_CalculateMeetingNoDays @StartDate...

There is no doubt that Replication maybe a better solution. WHich Replication model to choose is another question!

Merge would work howvere, Merge Replication is complex and most likely an overkill...

Your problem is the Distribution Server settings!

One of the properties of the Distribution Server is how long SQL Server will wait until it inactivates Subscriptions due to the frequency of...

Welcome back PW! Where have you been?

Script the original Database including Stored Procedures, Views etc. Then Create a new Database and run the Script on it.

Sorry folks. I spoke to soon!

I have done some further testing and the problem is actually coming from the UI. It has nothing to do with the "CASCADE UPDATE RELATED...