I taught we couldn't have on cascade delete on when the reference is on the same table!!!

Finish the logic, we'll kock it out for you ;).

No offense, but that's just the way it felt to me... and we get that all the time here.

Next time you might want to check the Books Online (BOL for...

Michael Earl (9/11/2008)

---

Ninja's - the answer is no.

That is clearly an example of multiplexing - which is explicitly addresed in the licensing and is not allowed. Each client connecting...

I love this site :D.

So that 15.00$ / month... 180$ / year for the web license???

I'm guessing here that I'd either use replication or linked server to keep all that...

I just have to ask...

Can I jsut create a single asp_net user for all the clients / suppliers and have them use that to login on the server... and obviously...

Well the extranet is still only in a nice to have project phase, absolutly not essential to our business. If this feature costs us 10K extra just to save...

I still don't see any code to replace the city name to cityid in the base table, nor indexing, nor foreign keys strategies in place...

You guys still have much work...

Blocking, locks, contention on ressources, data out of cache, too much stuff going on, other programs fighting for ressource, slow network... just from the top of my head... Really...

Cool, do that then we'll be able to help you.

Give us the DDL statments along with the DDL statements to load the tables.... we'll show you how to do it.

Search parameter sniffing on this site.

Also you might want to test if using a temp table instead of table variable helps here.

Seems like a homework question.

What have you tried so far?

Anybody got 2008 installed to test the new merge command and do a case study to see what

solution(s) seem to be the best?

My first instinct tells me that doing...

Good points, I've always be the only DBA in the environement... with the rule don't touch the freaking DB.

The only exceptions is that 2 power users can create views to...