If you try it out, let us know whether it worked!
HTH
Server\CurrentVersion\QueryLogConnectionString.Quote:> Could be possible. The Quey Log connection string is in
> HKLM\SOFTWARE\Microsoft\OLAP
> If you try it out, let us know whether it worked!
> HTH
> > Hi,
> > The msmdqlog.mdb on our production server hit 980 MB this morning. I
> > copied it to my PC and used Access to compact it down to 3 MB. Has
anyone
> > encountered this issue before? I was thinking of creating a DTS package
> > using VBScript to compact the database at regular intervals if this can
be
> > done without needing to install Access itself.
> > Is it possible to have analysis services use SQL server instead of
> > msmdqlog.mdb to log queries? Has anyone tried it?
> --
> George Spofford
> Microsoft MVP
> Chief Architect / OLAP Solution Provider
> DSS Lab
> ISVs & IT organizations: Find out how DSS Lab can speed your development!
Server\CurrentVersion\QueryLogConnectionString.Quote:> Could be possible. The Quey Log connection string is in
> HKLM\SOFTWARE\Microsoft\OLAP
> If you try it out, let us know whether it worked!
> HTH
> > Hi,
> > The msmdqlog.mdb on our production server hit 980 MB this morning. I
> > copied it to my PC and used Access to compact it down to 3 MB. Has
anyone
> > encountered this issue before? I was thinking of creating a DTS package
> > using VBScript to compact the database at regular intervals if this can
be
> > done without needing to install Access itself.
> > Is it possible to have analysis services use SQL server instead of
> > msmdqlog.mdb to log queries? Has anyone tried it?
> --
> George Spofford
> Microsoft MVP
> Chief Architect / OLAP Solution Provider
> DSS Lab
> ISVs & IT organizations: Find out how DSS Lab can speed your development!
Server\CurrentVersion\QueryLogConnectionString.Quote:> Could be possible. The Quey Log connection string is in
> HKLM\SOFTWARE\Microsoft\OLAP
> If you try it out, let us know whether it worked!
> HTH
> > Hi,
> > The msmdqlog.mdb on our production server hit 980 MB this morning. I
> > copied it to my PC and used Access to compact it down to 3 MB. Has
anyone
> > encountered this issue before? I was thinking of creating a DTS package
> > using VBScript to compact the database at regular intervals if this can
be
> > done without needing to install Access itself.
> > Is it possible to have analysis services use SQL server instead of
> > msmdqlog.mdb to log queries? Has anyone tried it?
> --
> George Spofford
> Microsoft MVP
> Chief Architect / OLAP Solution Provider
> DSS Lab
> ISVs & IT organizations: Find out how DSS Lab can speed your development!
1. Query Log msmdqlog.mdb very large and broken
The query log Access database msmdqlog.mdb has grown to a
very large size of 600 MB on an AS2000 server.
Attempting to clear it produces an error "Run-Time
error '3704' Operation is not allowed when object is
closed.".
What can we do to repair this and reduce the size of the
query log?
2. Are Table-type recordsets "self-refreshing"?
3. MSMDQLOG.MDB - Strange logging behavior!
4. VSAM / SQL
5. msmdqlog.mdb bug - "dataset" field only 64 chars
6. Simple Question About adding data
7. moving msmdqlog to SQL server
9. Adp slower than mdb connecting to mdb on server
10. Replication from SQL to Access MDB to MDB
11. subscribing mdb renames to xx_old.mdb...why???
13. Concatinate .mdb files into single .mdb file