Tim

Can you add a section into the OLH for where you need to be on the left hand pane treeview to execute certain types of sql?

To get a list of the text filters I first tried "select * from information.textfilters" with the database selected but had to move up to the session and use "select * from textfilters"

Maybe its just me not knowing what to preface what with?

Roy Lambert

Roy,

<< Can you add a section into the OLH for where you need to be on the left
hand pane treeview to execute certain types of sql?

To get a list of the text filters I first tried "select * from
information.textfilters" with the database selected but had to move up to
the session and use "select * from textfilters"

Maybe its just me not knowing what to preface what with? >>

Look at the bottom status pane to see what the current database is.  You
need to be using the Configuration database as the current database in order
to execute queries against it, and the Configuration database is only
current when you're at the session level and not in a specific database.

--
Tim Young
Elevate Software
www.elevatesoft.com