SQL Server Performance Forum – Threads Archive

trigger that creates folder

Does anyone know if it is possible (and if yes, how) to create a trigger that creates a folder for every inserted record?
In a specific root folder, I want a subfolder for every record in the table. How does the trigger have to look like to make the folder automatically with every insert of a new record??? thanks!!

You really shouldn’t do this. <img src=’/community/emoticons/emotion-1.gif’ alt=’

‘ /> If you are going to though, this code should give you a start. You will need to add logic to INSERT all the rows from the "inserted" table of the trigger. You will then need to get the EXEC master..xp_cmdshell ‘dir c: /A<img src=’/community/emoticons/emotion-2.gif’ alt=’

‘ />’ for whatever directory you are looking at. You can then compare the results and use a loop to create/delete necessary directories. This code should get you started. It ONLY creates one directory, so you still have quite a bit of work to do. Give it a shot though, and let us know if you need help. <pre id="code"> EXEC master..xp_cmdshell ‘dir c: est' GO CREATE TABLE test_trigger1( test VARCHAR(50)) GO CREATE TRIGGER ins_test_trigger1 ON test_trigger1 FOR INSERT AS CREATE TABLE #test(shell VARCHAR(255)) INSERT #test(shell) EXEC master..xp_cmdshell ‘dir c: est' IF (SELECT shell FROM #test WHERE shell = ‘ Directory of c: est’) IS NULL BEGIN EXEC master..xp_cmdshell ‘md c: est' END GO INSERT test_trigger1(test) SELECT ‘test' EXEC master..xp_cmdshell ‘dir c: est' –EXEC master..xp_cmdshell ‘rd c: est' GO DROP TABLE test_trigger1 GO </pre id="code"> MeanOldDBA [email protected] When life gives you a lemon, fire the DBA.

]]>