Re: Mailing to users

Laslo Orto ( )
Thu, 14 May 1998 21:37:29 -0400

At 08:28 PM 5/14/98 -0500, you wrote:
> I would like to create a script that parses all sub accounts by region so
>that I can mass e-mail those users information that might impact their
>situation. I have tried network status pages, phone mail call directors,
>mass e-mail to all users and feel a targeted approach would be the easiest
>method. I could organize the users by region into a mailing list on the
>fly, yet I have problems getting them out of the database for some reason.
> Since the tables are not indexed, the query will take some time, I do not
>mind the wait, yet I am getting various messages. The one that happens
>almost everytime now is attached.
>Select ma.Region, sa.Login
> From MasterAccounts ma, SubAccounts sa
> Where ma.Region = 'xxxxxx'

AND ma.customerid=sa.customerid

> Order by sa.Login, ma.Region
>Msg 1105, Level 17, State 1
>Can't allocate space for object '-1250' in database 'tempdb' because the
>'system' segment is full. If you ran out of space in Syslogs, dump the
>transaction log. Otherwise, use ALTER DATABASE or sp_extendsegment to
>increase the size of the segment.
>Msg 1510, Level 17, State 2
>Sort failed: Out of space or locks in database 'tempdb'
>Michael J. Whisenant
>Vice-President, Operations
>AIRnet Internet Services, Inc.
>ph: (256) 704-4692 fax: (256) 704-2329
> ----------------------------------------------------------
> Emerald Mailing List

Laslo Orto Computer Pages / Better.Net
Systems Administrator 253 Sheppard Ave. West / Toronto, Canada M2N 1N2 / Ph: +1 416 225 3030
Fax: +1 416 225 6737