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)

---

Hi

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

You will need to create an alias as already stated above by Thomas.

Other than that create a new server named SPORT and install a default instance.

Note the alias will need...

GilaMonster (9/18/2012)

---

And the question of how many columns in a table depends on a couple things, it's not a fixed number. Maybe they were wanting to see if you knew...

Maybe they are trying to see if you know the limits and basics of SQL, they are all valid questions.