The content type availability is stored in a table called:
The column is:
The SQL snippet below has this table joined to course_main and
content_handlers so you can see some meaningful information on the course
ID's and content types.
cch.crsmain_pk1 = cm.pk1
and cch.content_handlers_pk1 = ch.pk1
and cm.course_id like '2007%'
>>We seem to have magically turned off the availability of
>>certain content types in random courses during rollover :-(
This random content type turning-off on course copy is a feature intended to
improve the moral fibre of Bb system administrators who would otherwise
spend their Summer's on frivolous pursuits like holidays.
University of York
Email: [log in to unmask]
Tel: +44 (0)1904 32 1140
From: Blackboard/Courseinfo userslist
[mailto:[log in to unmask]] On Behalf Of Trish Murray
Sent: 15 August 2007 14:03
To: [log in to unmask]
Subject: SQL to examine availability of content types
Does anyone know the SQL to examine content type availability in
Blackboard? We seem to have magically turned off the availability of
certain content types in random courses during rollover :-(