I think you mean W2K3 Enterprise and SQL2K5 standard

http://msdn2.microsoft.com/en-us/library/ms171001.aspx

You'd need self joins to join each table based on the date.

so

select a.model

, b.modeldate '3 weeks'

, c.modeldate ' 2 weeks'

...

from modelhistory a

...

backup the database, restore it, then for each table you need to decide what "first" is. There's no order by default in SQL Server.

ms_foreachtable is a stored procedure that...

Please give us a clue here.

Worst case, set up a Windows Scheduled Task if you can't get SQLAgent to work.

Run isql -E -Q"backup database xxx to disk='c:\mybackup.bak' with init"

Feel...

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...