Hi, I only know some basics about permissions on SQL 2005, I watched the
video on setting up FTCs (thanks for the link). On my server (Express Adv.
Ed. SP2 with everything installed) I created a login with dbcreator and
public permissions. The login can create and access the database (dbowner
permissions) however when the login attempts to create a FTC, the following
error occurs;
'User does not have permission to perform this action.'
ML - 12 Jun 2007 11:49 GMT
To create FTCs the user needs to be a member of the db_owner or the
db_ddladmin fixed database roles.
ML
---
http://milambda.blogspot.com/