I'm not sure about the removing features, but there are quite a few little things that would make life easier, and they're not usually important enough for someone to write...

I'll move this to the strategies forum.

The way I'd do this is in stages. First I'd get mail working. Look up Database Mail, get that setup and tested.

Next, I'd create...

Hey, I'm starting to resemble that remark. :w00t:

Likely the issue is the Dynamics user doesn't have rights to create the user. You are having database issues.

What you might want to do if you sort out rights is...

Jerry has some good ideas. I'd dig into and see if the procedures that you are looking at have additional parameters. Some do which might help in cases. This one...

Please don't use polls to ask questions.

No matter how you load it, if you go with one large transaction, then you have log issues (and potential rollback issues). SSIS is essentially a C# application written to...

It will take time and you'll need disk space to house the index. It will require resources, so you might want to pick a low activity period to do it...

sp_help_job is what I'd use as well.

First, lots of companies won't do this because production data should not be disclosed to QA. Financial stuff, identity, etc. You're asking for issues. Lots of companies I know of...

Blandry, I think it depends on what you're trying to achieve. I have development experience, but I'd be a low, intermediate developer at best in terms of coding skill and...

But we can remove the old ones! :w00t:

If you must use one physical server, I'd do one instance. Two instances can be tricky and it sounds like you don't really know how this works. In that case...

With 2005 and 2008, they aren't necessarily required for auditing. Actually you could argue that Profiler/trace means they weren't needed previously either. They do many auditing easier in many cases,...

dbcc shrinkfile.

Only shrink it to the size you need for peak size between log backups. Not what's used now.