Anyone have a sqldmo installer?

Hi;
Does anyone have a .msi program that correctly installs sqldmo, and does
nothing if it is already installed?
I was going to do this but there are a bunch of details that must be exactly
right and I am not an expert with the Visual Studio installer.
thanks - dave
David Thielen wrote:
> Hi;
> Does anyone have a .msi program that correctly installs sqldmo, and
> does nothing if it is already installed?
> I was going to do this but there are a bunch of details that must be
> exactly right and I am not an expert with the Visual Studio installer.
It's not likely the VS Installer would work for you in this case.
There's not a lot of customization support in the tool.
What problems are you running into?
David Gugick
Imceda Software
www.imceda.com

any way to prevent SSAS memory from paging?

This morning msmdsrv.exe looked like the following in Task Manager:

Memory Usage: 600,000 K

VM Size: 2,500,000 K

If I understand correctly, that means that a good deal of SSAS memory has been swapped to disk by the OS. Is there any way to prevent this? (I have read about using the Lock Pages In Memory privilege at http://msdn2.microsoft.com/en-us/library/ms179301.aspx which lets SQL prevent the OS from paging sqlservr.exe memory. I don't suppose there's an equivalent SSAS setting.)

In particular, the symptom I'm seeing is that after we finish processing, all that paged memory has to be loaded back into memory before the transaction can be committed. Committing the transaction is usually very quick. But when most of the SSAS process memory is pages, it takes quite a while, during which I can see the Memory Usage number in Task Manager growing. (I don't think it's a blocked transaction commit.)

Looks like maybe there is a way to do this in SP2. Can anyone explain the PreAllocate setting further?

http://www.sdsqlug.org/presentations/November2006/November_2006_64-bit_SQL_Server.pdf (page 36)

Any news on different browsers?

I'm using the ReportViewer web control and RS 2005 and notice that
reports don't come close to rendering correctly in FireFox.
I had read posts concerning RS2000 and was thinking that maybe the new
release would be compatible with browsers other than IE.
Does anybody know of (1) any techniques to make the viewer work; or
(2) any news about
an upcoming release that would work?
Also, out of curiosity, has anybody tried this Report Viewer with IE7?
JimWe just upgraded to Reporting Services 2005 and I'm noticing the same thing:
serious rendering problems with reports in Firefox. Specifically:
1. Rendering sometimes ignores hard width values (in inches).
2. Some columns nearly disappear, data in them is not visible.
3. Report height is much less than specified (again, in inches).
I could live with work-arounds, but the fact that no one has even replied to
two separate queries on this subject makes me wonder if there are any.
On a more positive note, the toolbar now works in Firefox!
--
Software Engineer
Educational & Community Supports
University of Oregon
Eugene, OR 97403-1235
"jhcorey@.yahoo.com" wrote:
> I'm using the ReportViewer web control and RS 2005 and notice that
> reports don't come close to rendering correctly in FireFox.
> I had read posts concerning RS2000 and was thinking that maybe the new
> release would be compatible with browsers other than IE.
> Does anybody know of (1) any techniques to make the viewer work; or
> (2) any news about
> an upcoming release that would work?
> Also, out of curiosity, has anybody tried this Report Viewer with IE7?
> Jim
>