Hi Group, I wanted to ignore / accept notifications from SQL Server Analysis Service 2005. This needs to be done without shutting down SQL...
Anytime!!! [<img src='/community/emoticons/emotion-1.gif' alt=':)' />]<br /><br />Cheers,<br />Amit
Hi Larry, We also faced a similar situation like yours. We are following the same procedure mentioned above. Surely there might be some slight...
Larry, I don't think this would work. However you may try this, if this works do let me know. Cheers, Amit
Hi Larry, I don't think running the job immediately would solve your problem. You must have some time lag between Trigger execution and Job...
Hi Chetan, You may use the following Select Statement for the desired output. SELECT (SELECT DT FROM OPENXML(@HDOC,'/ROOT/COMPUTER/GENERATED')...
Hi Larry,<br /><br />You may note down the follwoing code and may use it in the Trigger<br /><br />Decide a unique name for your job say 'JOB' +...
Hi Larry, The ASP Page won't load until it completes the execution of the Strod Procedure. To shorten the time taken for page loading you may...
Hi, I found another component which can be used for sending mails from SQL Serevr. The details can be found athttp://www.sqldev.net/xp/xpsmtp.htm...
Hi, Microsoft has released the HotFix for the above bug. Details can be found @http://support.microsoft.com/default.aspx?kbid=899761 --Amit
Separate names with a comma.