No, it should be there. Haven't seen this at all. What's the build on SQL Server? select @@version

I haven't managed AX, but I did admin a Dynamics site about 5 years ago. Some of this may or may not apply.

We removed "sa" from Dynamics even though MS...

Changes occur immediately if you save them. It is possible to add them and not save them.

msdb is basically the database for SQLAgent. It has history, information about SSIS package and jobs. It may or may not contain SSIS packages (they can run from the filesystem),...

Not sure about moving the diagrams. You should be able to see them as sa without issue. Maybe check the rights inside the db to see if something is weird.

You...

SSMS also shows this.

You should not need to do this after a full backup. You either have a misconception about what is happening or are not administering the system properly.

The log does not...

Is the maintenance plan set up in SSMS? Is the logging checked? It should write a text file. not sure about spotlight.

What else is checked in the maintenance plan?...

No one wants their boss to do something?

Peter, no first class travel? Extra night on the road?

Will, no dedicated time to experiment with mouse speeds/sensitivity?

Matt, no "road breaks" to...

Here's the thing. Grant has good advice, but I'd calculate the row sizes, guess at how many rows will get inserted in a year, then double that, add 50%...

temp tables aren't necessarily better. Even local (to the connection) ones. The reason is tempdb can be a source of contention and you are guaranteeing disk access. If you send...

Include adds data to the index so that a bookmark lookup is not needed (now a clustered index seek) to go back to the table for the data. Good for...

Never had much of a preference on mice, but let us know how it goes, Will.

Matt, what's an oodle? Is that a measure for 10TB 🙂

There should be no problems, although tinyint can store more values (2, 3, 4), so you possibly could have other data in there that your application doesn't deal with. So...

I pinged some people to see if there are any other solutions. I know I didn't renew our Lumigent maintenance at JD Edwards because we never used it. This is...