David the same thing is going with us. SO if anyone has a response please sent it to the list.
-----Original Message-----
From: David Khoury [SMTP:dave@flex.com.au]
Sent: Thursday, April 10, 1997 4:06 AM
To: emerald@emerald.iea.com
Subject: Re: CallsOnline and tempdb
>Typically, this will half your calls table. I posted a message
>earlier about having an appropriately sized tempdb database to
>handle the consolidation. Something around 5-15mb should be fine.
>I might add an option to the charges consolidation to allow stepping
>of it, rather than having to do all of it as it currently does.
Great Dale!!! Just what we need. Could you email to the list when the
stepping colsolidation is finished? Thanks.
Just on the tempdb thing, I went to our SQL server today to try and up the
size of the tempdb database. First went to expand the master device ... and
found that it's maximum size was a negative number!! And the listed size of
the device was the same as the maximum size. Of course, this makes it
slightly hard to expand the master device. The funny thing was that this
was the same on all the devices except for the EmeraldDev device.
Maybey the SQL server wants all the devices as contingeuous files on the
disk !?!?
If anyone has seen this before, I'd appreciate a hint on how to resolve it.
Thanks.
P.S If you do reply, could you email a response directly to me?? I've
subscribed in digest form (because of the amount of e-mails I get on this
list), and I get the digest just after work finishes.
--------------------------------------#------------------------------------
David Khoury | "Where's the KABOOM ??
Technical Manager & Comms Engineer | There was supposed to be an
dave@flex.com.au | earth shattering KABOOM!!"
http://www.flex.com.au/~dave | Marvin the Martian
--------------------------------------#------------------------------------
----------------------------------------------------------
Emerald Mailing List listserver@emerald.iea.com
------ =_NextPart_000_01BC458A.E61E2570
Content-Type: application/ms-tnef
Content-Transfer-Encoding: base64
eJ8+IjQMAQaQCAAEAAAAAAABAAEAAQeQBgAIAAAA5AQAAAAAAADoAAEIgAcAGAAAAElQTS5NaWNy
b3NvZnQgTWFpbC5Ob3RlADEIAQ2ABAACAAAAAgACAAEEkAYAwAEAAAEAAAAQAAAAAwAAMAIAAAAL
AA8OAAAAAAIB/w8BAAAATQAAAAAAAACBKx+kvqMQGZ1uAN0BD1QCAAAAAGVtZXJhbGRAZW1lcmFs
ZC5pZWEuY29tAFNNVFAAZW1lcmFsZEBlbWVyYWxkLmllYS5jb20AAAAAHgACMAEAAAAFAAAAU01U
UAAAAAAeAAMwAQAAABgAAABlbWVyYWxkQGVtZXJhbGQuaWVhLmNvbQADABUMAQAAAAMA/g8GAAAA
HgABMAEAAAAaAAAAJ2VtZXJhbGRAZW1lcmFsZC5pZWEuY29tJwAAAAIBCzABAAAAHQAAAFNNVFA6
RU1FUkFMREBFTUVSQUxELklFQS5DT00AAAAAAwAAOQAAAAALAEA6AQAAAB4A9l8BAAAAGAAAAGVt
ZXJhbGRAZW1lcmFsZC5pZWEuY29tAAIB918BAAAATQAAAAAAAACBKx+kvqMQGZ1uAN0BD1QCAAAA
AGVtZXJhbGRAZW1lcmFsZC5pZWEuY29tAFNNVFAAZW1lcmFsZEBlbWVyYWxkLmllYS5jb20AAAAA
AwD9XwEAAAADAP9fAAAAAAIB9g8BAAAABAAAAAAAAALpXwEEgAEAGwAAAFJFOiBDYWxsc09ubGlu
ZSBhbmQgdGVtcGRiADQJAQWAAwAOAAAAzQcEAAoACAAoADMABABJAQEggAMADgAAAM0HBAAKAAgA
JwAhAAQANgEBCYABACEAAAA4M0MwQTQ0RTIyQjFEMDExQkYzQzAwQTBDOTA2MkUyRgAZBwEDkAYA
EAkAACEAAAALAAIAAQAAAAsAIwAAAAAAAwAmAAAAAAALACkAAAAAAAMALgAAAAAAAwA2AAAAAABA
ADkAwNU+bKxFvAEeAHAAAQAAABsAAABSRTogQ2FsbHNPbmxpbmUgYW5kIHRlbXBkYgAAAgFxAAEA
AAAWAAAAAbxFrGtVTqTAhLEiEdC/PACgyQYuLwAAHgAeDAEAAAAFAAAAU01UUAAAAAAeAB8MAQAA
ABAAAABlbWlsbGVyQGRlbC5uZXQAAwAGEDV4FusDAAcQTQYAAB4ACBABAAAAZQAAAERBVklEVEhF
U0FNRVRISU5HSVNHT0lOR1dJVEhVU1NPSUZBTllPTkVIQVNBUkVTUE9OU0VQTEVBU0VTRU5USVRU
T1RIRUxJU1QtLS0tLU9SSUdJTkFMTUVTU0FHRS0tLS0tRlIAAAAAAgEJEAEAAAD3BQAA8wUAAGMK
AABMWkZ1M5jARncACgEDAfcgAqQD4wIAY4JoCsBzZXQwIAcThwKDAFAO9nBycTIP9iZ9CoAIyCA7
CW8yNWY1AoAKgXVjAFALA2MDAEELYG5nMTAzMwELpiBEYXZpZCDAdGhlIHNhB4AWsYkLgGcgBAAg
Z28XcoMD8BbAIHVzLiAGANJPF6BmIABweQIgFuCTD4AEIGEgCXBzcAIg9Q+wIAtQZRnAFuEJ8AVA
KxhQFrBvFrNsBAB0Lp8KogqECoQLMBwAMzYBQKcVEAFAEUBvdAWQdBCEUDE2IC0fEk8FEGefC4AH
QAXQB5AXAGdlHxMfHFYeJB3xCxMeJmktMYw0NAFAHAAxODABQKMM0CKzYiBGA2E6DIMSYhZGS2gI
YXkgW0BTTVRQOmQWcGUkQGYasHguBaBtLvhhdV0cVSPgBmACMCRHlFRoCHBzJgB5LA/wDxFAAxEV
kCjwMTk5N5AgNDowHvBBTScXVFRvJEdlB4ByB0BkakArtS4IkGEmkicYdQxiah5RJEdSZTogwkMH
QGxzT24cABmB5wBwFqErsHBkDDAgzyHZBx10C7YcaT5UeXBp/mMvASjhF1EEIAPwLxAZoe5sGSAZ
YAhwIDQCBCABkesasBixSRqQbxwgCYAZ4e8HgSAiM1UawHIcAASQGTB9BuB1BUAPgBaAF4EDkWF2
cB4RKSFhHkA0MBbwafZ6NvEv9CAmAAGRGtIbkP8zVQ+AL8AasBazBaAAgAbw+xaQOiBpAiAYsgNw
D8AXY9cKwAhgL8E1IqA1BtAW8PMlQSwAIGIW4CKAGYAcRSo+NpBtH4BoBUBhZP83AQOgOeA9shuG
D3IgQAQg9z0rG4IvAW8H4DbRObAXcf0zVW8ZIBhQKPAr4BbBBcDvFsADkTkFG5FkRENB4EXC9xkw
BCAbYWMIcAlwAjA6Ue9HgAeQHEsYwEcJcDogFlFtGrAhSyAYwEoYkAVAd/8PgEuhFuAZgAmAGLEI
UT/h/zVhK6ELcAMgG5lLsQnwFrL/HFRExj0RLyBDmBexQEEEALkW0GQ/GMAocABwa0mO/0tzQjIW
0TrlF1Mo8DaQTBBHGzEbkTVyU1FMGwFyfyYgRnEEcCjQG4MlcS+ydX5wTrk6kUfiU3k7VhixRv5p
D6BL8lTUJnAKsC/CFtFfAMA20QXAAQAWgGMW4C5/XEAvohxUAhA+8kaRG0InywQgAMB4B3B1bTpz
GDD7GcMZgGc9oSYgTDBeYEAQ+nJLMkFa9RwCNvFX9RxUfxbCW9Ve4hbHYvVeGhixT7cZIAWgKJFl
NFUAwGsHkf8YUE71HABBQTpRD4EWoVqf/1unGLEocEAhPvAZUBdFYuT/SrE0chxUYutCMUeyYjgE
IL8mcFwQBTECEEZyFuBFK8TuRFvgaRZJrE0o0EAQajL/FuBVeV7gAjAZ0Wz9GcE9IfM9sBVwZXUI
YFDSGrAEIAtTRBxUZAQAayAhP/t2AEmsSRkrD7BOkxexQBDzblFlkUknNwE5sQWQOhL/GeEXYVMj
JUAH4BuRGhEG8D9foRhQSZ1RqwrjSkJQLv8F8HcSTRJHgQlwC1Ao4WVBf0zrGfl1sHmRSRIbkQeA
P/9RcXkgJiBO9S3ABPJAEBag3wuAgRFDEW4zXnAoQBA0AP8YkFgnFxA+4VMhGSAgUE1ivwQgNpAg
QFMla2YcAiko8K8vsoakYjOD1GpLgmEBgP9yAgWwdeBQ9X0NHxOMP41O/iONT49vIJYYwCTbke+S
VNJ8GMAiV0ZRZV3hFsKAS0FCT09NIIIA+3w3BZBoAwA0AXDBH7AgQKUFwCZMoW1tBCBFFXD/L3E4
cZNSaaIJcF7TguA5sP82wDqyG6BAEQBwSgYmDpJf/5M0GMA4IRhhP6A6IFuRF3L7lGRLICJKBhUD
P9AZoAJAoHA6Ly93n8AuJln8L34mAh3DP9AP4Jvrm1j/cNBV0IORFsKjET2wmYaPn/+ln44fp7+Q
O0mrqD+rf6yP35A8btVwwQMQF3JMTjKbWV8cAlW0LC8caRIBALMgAAMAEBAAAAAAAwAREAAAAAAD
AIAQ/////0AABzCwsC4+rEW8AUAACDCwsC4+rEW8AQsAAIAIIAYAAAAAAMAAAAAAAABGAAAAAAOF
AAAAAAAAAwACgAggBgAAAAAAwAAAAAAAAEYAAAAAEIUAAAAAAAADAAWACCAGAAAAAADAAAAAAAAA
RgAAAABShQAAtw0AAB4AJYAIIAYAAAAAAMAAAAAAAABGAAAAAFSFAAABAAAABAAAADguMAADACaA
CCAGAAAAAADAAAAAAAAARgAAAAABhQAAAAAAAAsAL4AIIAYAAAAAAMAAAAAAAABGAAAAAA6FAAAA
AAAAAwAwgAggBgAAAAAAwAAAAAAAAEYAAAAAEYUAAAAAAAADADKACCAGAAAAAADAAAAAAAAARgAA
AAAYhQAAAAAAAB4AQYAIIAYAAAAAAMAAAAAAAABGAAAAADaFAAABAAAAAQAAAAAAAAAeAEKACCAG
AAAAAADAAAAAAAAARgAAAAA3hQAAAQAAAAEAAAAAAAAAHgBDgAggBgAAAAAAwAAAAAAAAEYAAAAA
OIUAAAEAAAABAAAAAAAAAB4APQABAAAABQAAAFJFOiAAAAAAAwANNP03AAApeg==
------ =_NextPart_000_01BC458A.E61E2570--