Results 1 to 2 of 2

Thread: Server: Msg 1101, Level 17, State 10, Line 8

  1. #1
    Byron Guest

    Server: Msg 1101, Level 17, State 10, Line 8

    If we run the query below with the values of 'rml' and 'ra' it runs but if we use 'cca' and 'cc' we get this error:

    Server: Msg 1101, Level 17, State 10, Line 8
    Could not allocate new page for database 'TEMPDB'. There are no more pages available in filegroup DEFAULT. Space can be created by dropping objects, adding additional files, or allowing file growth.

    Here is the query

    Declare @Level_1 varchar(3),
    @Level_2 varchar(2)

    Select @Level_1 = 'cca'
    Select @Level_2 = 'cc'

    select distinct tblAsset.State, tblAsset.County, tblAsset.Plant, tblAsset.Account,
    tblAsset.Acq_Yr, tblAsset.Acq_Pd, tblAsset_Book.Cost_Original,
    tblCounty_Names.County_Name, CER..tblLocation.Location,
    tblGL_Account.Account_Desc

    from tblAsset, tblAsset_Book, tblCounty_Names, CER..tblLocation, tblGL_Account
    where tblAsset_Book.Level_1 = @Level_1
    and tblAsset.Level_1 = tblAsset_Book.Level_1
    and tblAsset_Book.Level_2 = @Level_2
    and tblAsset.Level_2 = tblAsset_Book.Level_2
    and tblGL_Account.Company = tblAsset.Level_2
    and CER..tblLocation.SBU = tblGL_Account.Company
    and tblCounty_Names.County = tblAsset.County
    and CER..tblLocation.County = tblCounty_Names.County
    and CER..tblLocation.Code = tblAsset.Plant
    and tblGL_Account.Account = tblAsset.Account
    and tblAsset_Book.Book_Number = '1'
    order by tblAsset.State

  2. #2
    Paul Guest

    Server: Msg 1101, Level 17, State 10, Line 8 (reply)

    Sounds to me like tempdb is full check the size of the data file associated with tempdb it is contained in the mssql7data directory. If this is SQL Server 7.0. Use the directory that corresponds to the version you are on. IT may be that RML and RA ruturn a smaller result set that does not fill tempdb that the other values.
    If tempdb is hold alot of space try creating an additional file on a seperate drive to increase the available space for writing to tempdb. Also look at you hard disk and see how much space is available this may be part of the problem. Even if tempdb is set to auto expand you may not have the harddisk available for it to expand.

    Thanks,

    PA


    ------------
    Byron at 1/25/2002 4:51:45 PM

    If we run the query below with the values of 'rml' and 'ra' it runs but if we use 'cca' and 'cc' we get this error:

    Server: Msg 1101, Level 17, State 10, Line 8
    Could not allocate new page for database 'TEMPDB'. There are no more pages available in filegroup DEFAULT. Space can be created by dropping objects, adding additional files, or allowing file growth.

    Here is the query

    Declare @Level_1 varchar(3),
    @Level_2 varchar(2)

    Select @Level_1 = 'cca'
    Select @Level_2 = 'cc'

    select distinct tblAsset.State, tblAsset.County, tblAsset.Plant, tblAsset.Account,
    tblAsset.Acq_Yr, tblAsset.Acq_Pd, tblAsset_Book.Cost_Original,
    tblCounty_Names.County_Name, CER..tblLocation.Location,
    tblGL_Account.Account_Desc

    from tblAsset, tblAsset_Book, tblCounty_Names, CER..tblLocation, tblGL_Account
    where tblAsset_Book.Level_1 = @Level_1
    and tblAsset.Level_1 = tblAsset_Book.Level_1
    and tblAsset_Book.Level_2 = @Level_2
    and tblAsset.Level_2 = tblAsset_Book.Level_2
    and tblGL_Account.Company = tblAsset.Level_2
    and CER..tblLocation.SBU = tblGL_Account.Company
    and tblCounty_Names.County = tblAsset.County
    and CER..tblLocation.County = tblCounty_Names.County
    and CER..tblLocation.Code = tblAsset.Plant
    and tblGL_Account.Account = tblAsset.Account
    and tblAsset_Book.Book_Number = '1'
    order by tblAsset.State

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •