for base library if you don't want to go for pre-assigned - following options would be work for you use SASApp as Assigned selected server on extended attributes tab : fieldname: Assign Mode Value: 2 description: Metaout=data this behavior make it possible to add, modify, and delete table within the library...for the clients i guess... you would not go for SASMeta as a selected server as you want makes Base libraries available clients... ... View more

thanks Chris ... View more

i think we can use different server definition under "server manager" under SASApp for different ODBC conenctions and then create different ODBC library for different ODBC conenction. lets say if you have SQLA, SQLB and SQLC ODBC data source name - OF COURCE we can create group definition in "user manager" (if we have same userid for all three ODBC data source conenciton but different psw we can mentioned seperately under "account" tab in one group definition as mentioned below). e.g; user manager: group: ABC accounts:      auth domain: SQLA_auth                          SQLB_auth                          SQLC_auth      userid: same for all 3 - if you have same otherwise you can create different definition for all 3 ODBC data source      psw: dif. for all 3 server manager:      you have to create 3 different definition for dw, vw, pw library manager:      it will be 3 differnet odbc library, you can create same as dw, vw, and pw i think this way we can manage the thing. good lk! ... View more

Thanks Afarzam... ... View more

Have a question -  i don't find storeprocessserver.bat file to put in command option line for adding/creating new "stored process server". Will i get this after finishing of SDW for "stored process server"? or if i add "stored process server" directly by right click on SASApp - how can i get that? Thanks. ... View more

Thanks for your information Mark and Paul -  this would helps... ... View more