Post reply

Policy Management question

  • July 1, 2011 at 9:00 am

    #238961

    I have created a policy that checks to see if tables that are on a specific schema, are on a specific file group. I can run this on demand, and get the list of tables that are not on the file group, but I want to do this as an on prevent kind of thing. I could set up a scheduled job or an event notification, but the table is already created, and then I have to fool with moving it. Is it possible to do this with the on prevent?

    Thanks,

    Leonard

  • July 1, 2011 at 10:39 am

    #1347167

    You could probably do it with a DDL trigger. This link should get you started.


    Colleen M. Morrow
    Cleveland DBA

  • July 1, 2011 at 10:56 am

    #1347192

    thanks for that. I considered it, but thought there might be a way to do it through policy. I haven't used them before, so thought this might be a good place to start.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply