create a central database and then get each SQL server to insert data into the central database

otherwise as Gail mentioned, get a 3rd party product which already has done this...

One way, and others may add their own but the way I would do it is to set a poll up on sys.dm_os_performance_counters for the TempDB space used metric (Free...

Look at the STOPAT clause of the restore command.

So restore the full backup with NORECOVERY, then restore the log with STOPAT and RECOVERY

RESTORE DATABASE ...... FROM DISK = '...............' WITH...

All databases have a log, the recovery model tells SQL how to handle the log.

Simple recovery, the log is marked as re-useable by a checkpoint which occurs at regular intervals

Bulk-Logged...

Douglasjbell (9/19/2012)

Thanks for the replys.

As the application has already been designed from the ground up for use with the Access database I would rather stick with this as the backend...

supercalifragilisticexpialidocious

Is there a reason this is being done in the report and not the SQL statement?

But could you not build a calculated field in the data set based on the...

Thanks for that, I was thinking it was a user invoked error message as I couldnt find an article on it after a Google.

One for some reading up on I...

Basic formula is

((Cache Hit Ratio / Cache Hit Ratio Base) * 100)

Can compact edition act as a publisher in replication? I know Express and Web edition are subscriber only, but not done much with compact.

Nothing directly underneath that line, which looks something like

Error: ####, Serverity: ##, State: ##.

Usually they span two lines

Login failed for user 'someuser'. Reason: Failed to open the explicitly specified...

http://technet.microsoft.com/en-us/library/ms187743.aspx

For per-second counters, this value is cumulative. The rate value must be calculated by sampling the value at discrete time intervals. The difference between any two successive sample values is...

how are you calculating that number of 10630, is that how it is when you do the select or have you done a comparision between the value at two different...

what is the error number, state and severity from the error log?

Most of the original code base for Dynamics Nav & AX (and maybe the other) products was written by a mixture of different vendors, Nav was a collaboration from Navision...