Regularly Scheduled Events

Error: Database 'LibPublic' cannot be opened due to inaccessible files or insufficient memory or disk space. See the SQL Server errorlog for details.
Query: SELECT categoryID,categoryName FROM LibPublic.dbo.enm_categories WHERE categoryEvents=1 ORDER BY categoryNameError: Database 'LibPublic' cannot be opened due to inaccessible files or insufficient memory or disk space. See the SQL Server errorlog for details.
Query: USE LibPublic; SELECT TOP 2000 e.EventID AS eventID,e.Title AS eventTitle,e.Description AS eventDescription,e.OngoingDescrip AS eventOngoingDescription,ed.EventDateID AS eventOccurrenceID,ed.Categories,ed.LocationID,CONVERT(VARCHAR(10),ed.TheDate,120) AS startDate,ed.StartHour,ed.StartMin,ed.EndHour,ed.EndMin,ed.AdditionalDescription AS eoDescription,ed.EventRoom AS eoEventRoom,ed.CommunityLocation AS eoCommunityLocation,ed.RegInfo AS eoRegReq,ed.NewsID AS newsID,l.LocationShortName FROM event_date ed LEFT JOIN event e ON e.EventID=ed.EventID LEFT JOIN Location l ON l.LocationID=ed.LocationID WHERE (ed.LocationID LIKE '11') AND CONVERT(VARCHAR(10),ed.TheDate,120)>=CONVERT(VARCHAR(10),GETDATE(),120) AND e.Ongoing=1 ORDER BY Title ASC

Upcoming Events

Error: Database 'LibPublic' cannot be opened due to inaccessible files or insufficient memory or disk space. See the SQL Server errorlog for details.
Query: SELECT categoryID,categoryName FROM LibPublic.dbo.enm_categories WHERE categoryEvents=1 ORDER BY categoryNameError: Database 'LibPublic' cannot be opened due to inaccessible files or insufficient memory or disk space. See the SQL Server errorlog for details.
Query: USE LibPublic; SELECT TOP 8 e.EventID AS eventID,e.Title AS eventTitle,e.Description AS eventDescription,e.OngoingDescrip AS eventOngoingDescription,ed.EventDateID AS eventOccurrenceID,ed.Categories,ed.LocationID,CONVERT(VARCHAR(10),ed.TheDate,120) AS startDate,ed.StartHour,ed.StartMin,ed.EndHour,ed.EndMin,ed.AdditionalDescription AS eoDescription,ed.EventRoom AS eoEventRoom,ed.CommunityLocation AS eoCommunityLocation,ed.RegInfo AS eoRegReq,ed.NewsID AS newsID,l.LocationShortName FROM event_date ed LEFT JOIN event e ON e.EventID=ed.EventID LEFT JOIN Location l ON l.LocationID=ed.LocationID WHERE (ed.LocationID LIKE '11') AND CONVERT(VARCHAR(10),ed.TheDate,120)>=CONVERT(VARCHAR(10),GETDATE(),120) ORDER BY TheDate ASC

Error: Database 'LibPublic' cannot be opened due to inaccessible files or insufficient memory or disk space. See the SQL Server errorlog for details.
Query: USE LibPublic; SELECT newsID FROM enm_news n INNER JOIN enm_newsType t ON t.newsTypeID=n.newsTypeID_fk LEFT JOIN (enm_news_location nl LEFT JOIN location l ON nl.nl_locationID_fk=l.LocationID) ON nl.nl_newsID_fk=newsID LEFT JOIN (enm_news_categories nc LEFT JOIN enm_categories c ON c.categoryID=nc_categoryID_fk) ON nc.nc_newsID_fk=newsID LEFT JOIN enm_newsImages ni ON ni.ni_newsID_fk=n.newsID LEFT JOIN (enm_users iu LEFT JOIN LibStaff.dbo.userProfiles ip ON ip.profileID=iu.userProfileID_fk) ON iu.userID=n.newsInsertUserID_fk LEFT JOIN (enm_users iu2 LEFT JOIN LibStaff.dbo.userProfiles ip2 ON ip2.profileID=iu2.userProfileID_fk) ON iu2.userID=n.newsUpdateUserID_fk WHERE (CONVERT(VARCHAR(10),newsReleaseDate,120)<=CONVERT(VARCHAR(10),GETDATE(),120) OR newsReleaseDate IS NULL) AND (CONVERT(VARCHAR(10),newsExpirationDate,120)+' 23:59:59'>=GETDATE() OR newsExpirationDate IS NULL) AND newsApproved=1 AND nl.nl_locationID_fk IN ('11') AND c.categoryPublicDisplay=1 ORDER BY newsReleaseDate desc

• View More Library News