Home Forums SQL Server 2005 SQL Server 2005 General Discussion Create BAT File and execute the same in Trigger RE: Create BAT File and execute the same in Trigger

  • May 9, 2013 at 5:58 am

    #1613742

    I would not do file operations in a trigger, but what you have looks like it will basically work.

    I think the issue might be no permissions for SQL server to get to the sharename \\10.0.0.35\Project\Folder

    what results does this return?

    DECLARE @Results table(

    ID int identity(1,1) NOT NULL,

    TheOutput varchar(1000))

    insert into @Results (TheOutput)

    exec master..xp_cmdshell 'whoami' --nt authority\system for example

    insert into @Results (TheOutput)

    exec master..xp_cmdshell 'cd %userprofile%' --NULL because nt authority\system is not a user...command fails.

    insert into @Results (TheOutput)

    exec master..xp_cmdshell 'dir \\10.0.0.35\Project\Folder' --can this user see the share?\\10.0.0.35\Project\Folder

    SELECT * FROM @Results

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!