I had someone recommend Teo Lachev's book ( Applied Microsoft Analysis Services 2005: And Microsoft Business Intelligence Platform), but I haven't read it.

Nope, you're right, perhaps the coffee is spiked this morning.

There should be two answer marked as correct.

Yep, install personal edition on thier machine. send them a copy, let them change it, send it back, you deploy.

Seriously, people shouldn't update production packages on the server, it's like...

If the publisher is down, there should be no queuing. It has to do the queuing when the subscribers are down.

If should pick back up automatically. Are these pull or...

I think the best practice is KISS. Especially the second S because you never know who's coming behind you.

If you had a good way to manage the load and track...

What doesn't work?

Can you create the table and then insert?

create table #sss

insert #sss exec ()

I'd also be sure that job continues to run and if it does work, disable the jobs. That way if things fail back you're ok.

You'd have to script something. Mirroring tackles databases, not anything on the instance.

You could try a connection to the principal server and enable them if it doesn't work.

Use charindex/patindex to find the hyphen, then substring can be used to grab the stuff before where you need the space and after and combine them

substring (x,1,y) + '-' +...

Hans,

If I remember right, the sysindexes can get out of date in 2000 and only gets fixed if you reindex things. I'm not sure I'd depend on this to...

Instead of sending the email, you could log the failure in a table, then have another job that comes around every 5 minutes or so, checks the table, then sends...

DO NOT SHRINK your databases as part of a maintenance plan. This can cause fragmentation and ruin your reindex work.

Remove this as part of your maintenance plan.

The database is structured the same in both cases, but in different modes, it behaves fairly closely to that version in terms of code, keywords, etc. I believe that a...

Let us know. I'd missed the Resource database, which is new.

The KB article I found shows doing just what you do, which should work.

I would never append backups to a file. As the size grows, you increase the chance of bad blocks or corruption and you could invalidate mutliple backups this way.

I also...