Tim Mitchell (blogger/author on this site) is involved in a Fort Worth group, I believe. I'd contact him.

If you don't know what you're doing, the maintenance plans work great. However please read the documentation a little before posting.

If you understand them, as Francis mentioned, there are better...

This is a huge subject and there isn't necessarily an easy book that covers all this. I know that there are a few good SSAS books from WROX (beginning and...

You need to look at the maint plan log. It's usually a text file in the /log folder. It has more details. If you don't log from the maint plan,...

Why not store the data in a table and change it there? Access can do this easily as a front end for business people. Then you can more easily manipulate...

You really need to read up on replication and how it works. It's not that complicated, but it's not something we can necessarily give you a quick answer to.

A publication...

We're still sending it to you. Likely there was some filter update at your company.

read about UPDATE in books online.

I don't think you can do this with the bcp command. You aren't running T-SQL here, you'd shelling out to a command prompt and then running a utility to pull...

for the change to take effect, the service must be restarted. Just like you need to log off for someone else to log on and use the same files on...

Check for triggers, get the execution plan, trace what happens. Post come code.

It can't be done, and you are not understanding what an NDF is. It's a file, and not necessarily consisting of one object.

You have to export/import the data from one...

Replication is by table. You can drop that article for the table and reinitialize just that table and article with a snapshot.

The export/import duplicates replication functionality. If you are...

Can you share any more details about how the argument went? I think it could help some others get XLS use reduced for some things.

Are you sure you can connecting with the same credentials?

Can you connect to other SQL 2000 servers with this machine and EM and see dbs?