You need to call Microsoft for this. Catalog errors can have serious effects on your database.

We have this on our list, not sure if this is something we want to do, or how well it would be used.

All topics have icons to mark about if...

You'd have to check on the various publications and amount of changes.

I've seen 100MB databases have 1GB worth of changes a month. Replication moves all changes, so if someone does...

I'd recommend backup/restore OR make sure you have a copy of the files before attaching. The upgrade is a one way process, so you cannot go back to SQL 7.

At...

Is this in reporting services? Please post to the appropriate forum. I've moved it there, so post if it needs to be moved back.

If you want to pull data for...

I'd keep gaining experience and I'd keep re-evaluating how I feel about this. It can be lonely being the only one working on a project, and if it really bothers...

If you don't need permissions off the server, meaning no communications (mail, copy backup, agent, etc.), then use Local Service, not Localsystem. Local System is an admin level account.

If you...

The surface area configuration wizard just runs sp_configure with parameters to change the various features. It's nothing more than a dressed up SSMS wizard.

If someone has access to your instance,...

Nothing comes into play except current size and growth. getting the sizes doesn't give you a clue. You would be better off tracking backup size growth for a few months...

Glad you enjoyed it and I should have said actors.

Hope you had a great holiday!

It's always a judgement, and I think it has to be a debate between sales/marketing and development. I certainly don't want someone in Marketing taking a guess based on their...

I think the simulation path is the way to move. I know lots of people were tripped up on the 70-431 sims of SSMS.

However, I know there was at least...

I've got an MCTS and MCITPro, but mostly because I worked on some 2005 exam books and needed to be sure the books fit the exams, so I took them.

I...

Most of the very talented DBAs I know, including most of the MVPs, have certifications.

It's a selling point. It doesn't prove you are a great DBA, but it does...

and know how it's queried. If the queries use dates, index on the dates, but you have to know how the queries, or at least the common ones, are structured...