If you are using sql server 2000 you should consider moving it to SP4. Check out the documentation first to make sure this is ok for you. Probably won't make...

Are you using the same user to log in with frmo yur code as you do from EM?

What does the connection string look like?

You need one trigger for each table.

As there are about 300 of them, you probably want to work out what the trigger should look like for one table and then...

If you are coming frm a web page as I suggested, you are probably processing the rows one at a time.

Pass each row to a stored procedure to insert into...

Must have missed this article when it came out last year but I have been using this technique (with capitalised KEYWORDS) for many years now.

I try hard to instill...

The only reason I put my suggestion up was that it appeared you were coming from a web page where it would be nearly impossible to get a single oinsert...

One approach would be to load the data into a working table and then insert it as a batch from that table.

If there are any error sin the insert, all...

I think what Phil was tryong to express here is that you can simply do a multiple UNION ALL query to accomplish hat you need without a cursor.

If you focus...

Personally I've never had a problem with it on XP. We have a mixture of XP and Win 2K3 and we haven't noticed any differences. Perhaps we don't push it...

If you look at the properties of the publication through SQL Enterprise Manager, go to the articles tab and click the (...) button for one of the tables selected.

Then go...

I'm not sure why you can't see the databases via EM, but you should be able to do all the maintenance you need from within QA.

After, aren't all the tasks...

How do you legislate and enforce it?

If I was a provider of porn, would I bother to use a domain that I know is going to limit my exposure

I think your observations about leaders being facilitators rather than gate-keepers is very accurate. I've been through a few different industries myself and couldn't agree more.

Facilitation is the most effective...

I'll be looking for my free sample in the mail

I think the subtle difference in understanding lies in the whether NULL represents 'no value entered' or 'unknown'.

Obviously, SQL is behaving as though the value is 'unknown', therefore it excludes...