Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.
CREATE PROC spm_create_stand_alone(@cases_id varchar(50)) AS SET NOCOUNT ON /* -- TESTING ONLY use dbname Declare @cases_id varchar(50) SELECT @cases_id = '15322 FOO-3' */ Declare @bail_message varchar(100) -- Make sure the case was pushed IF NOT EXISTS (SELECT cases_id FROM CLOG_CASE_LOG WHERE cases_id=@cases_id) begin SELECT @bail_message = 'Case ' + @cases_id + 'has not been extracted.' goto bail end DELETE FROM MY_TABLE INSERT INTO MY_TABLE (CASES_ID) VALUES (@cases_id) -- Run the DTS package that writes to the Access database exec master.dbo.xp_cmdshell 'dtsrun /Sserver /Utheuser /Pthepassword /Nthedtspackage, no_output SELECT '1' as RETURN_VALUE goto ex -- This code processes if the deletion was unsuccessful based on any of the above criteria. bail: begin SELECT @bail_message as RETURN_VALUE goto ex end ex: GO
|What is rowversion in SQL Server ? How it is different from MERGE ?||5||24|
|Concatenating multiple comments into one row||16||42|
|SharePoint Installation Error - WDSRV.MSI file not found||3||20|
|Split Data in 1 column into 2 columns||8||15|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
13 Experts available now in Live!