So far there is no direct support for modifying a column of a replicated table in SQL2K, rumored for Yukon.

Andy

Sorry - I have an article posted here that explains a work around.

Andy

You'd have to weigh the extra overhead of XML to get it back to the client vs the ease of working with it. If the shaped provider will work (and...

I'd go with transactional. Easy enough to send over a new snapshot at any time if you run into problems. Less work than DTS. I've used replication for a while,...

I'd vote replication,though I think Im in the minority.

Andy

For 10g I think one mdf will be fine. I'd say start there and if you have performance issues, then consider filegroups as one of many possible solutions. My reasons...

Im not sure if Nicole monitors the forum. I'd recommend that for any job posted you just email the person directly. But do let us know if you ended up...

Using 'Not in' will usually result in a slower query plan, avoid it when you can. I find it to be faster to just tag the records as deleted rather...

Always try to write it as well as you know how the first time - odds are no one will ever look at your code until it breaks.

Good code is...

It's just a newer version.

Andy

Shouldnt be a problem - the MSDE db is on one machine, correct? If that is the case you can run a backup there by using either TSQL or DMO,...

Maybe the column type is different in the other db? Could you post the change script plus DDL for the db where it fails?

Andy

Hardware will probably end up being a more critical decision that which version of SQL. All depends on the number of concurrent users and how complex your transactions are. You...

Hey Jamie, got a couple already:

1) No support for including images? Deal breaker for me, being able to see a screenshot or series of screenshots is tremendously helpful when trying...

I'll be taking a look at in the next week or so, probably have some questions then.

Andy