Home Forums SQL Server 2005 T-SQL (SS2K5) Creating Database Objects from a Trigger-invoked stored procedure.... RE: Creating Database Objects from a Trigger-invoked stored procedure....

  • I may have found a way, from another blog....

    If I put my CREATE VIEW and CREATE PROCEDURE statements into a .sql file, then I may be able to call them from my procedure with:

    exec master..xp_cmdshell 'osql -E -ix:\path\filename.sql'

    I will let you know if it works.

    Thanks.