What are you looking to monitor? There's a whole range of things here.

sqlSentry has a good performance monitoring tool.

Quest has some tools, can be expensive

Idera has a variety of tools...

I like Diff backups if you can do them because they speed and simplify restores. I have run them every 2-6 hours at times to ensure that I don't have...

I agree with Robert. Portability doesn't mean writing the lowest common denominator. The code shouldn't be lifted from one platform and dropped on another. It should be slightly altered to...

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: