advlgx
asked on
Incorrect Syntax with xp_delete_file
What's wrong with this command? I get Incorrect Syntax near 'txt'. The odd part is that this was generated my the maintenance plan wizard....
EXECUTE master.dbo.xp_delete_file 1,N'''',N''txt'',N''2008-0 1-12T04:01 :38''
EXECUTE master.dbo.xp_delete_file 1,N'''',N''txt'',N''2008-0
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Got it, the second parameter was not filled in for some reason. Added C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG
ASKER
EXECUTE master.dbo.xp_delete_file 1,N'',N'txt',N'2008-01-12T
and get an Invalid Parameter error