• This does not sound like a good idea, as the other posters say, you should import the data into development from your production system using SSIS or a bulk method.

    But to answer the question better, we need a bit of background information;

    What are the triggers you want to test? What do they do?

    Why do you want to get the data into development?

    -----------------------------------------------
    SQL Server posts at my blog, Grapefruitmoon.Net[/url]