Home Forums SQL Server 2008 T-SQL (SS2K8) Using xp_readmail to read mail from outer environment RE: Using xp_readmail to read mail from outer environment

  • January 3, 2013 at 8:28 am

    #1573357

    opc.three (1/3/2013)

    Thanks, Lowell. SQLCLR is a powerful tool, to be sure. You know where I stand on the topic already but I am curious now, can the assembly you created be run as SAFE or does it need EXTERNAL_ACCESS or UNSAFE?

    it required UNSAFE mode , i believe due to the use of System.Net.Sockets and System.Runtime.InteropServices;

    because it piqued my interest, i'm also now fiddling around with adding a CLR that does IMAP also, since that would allow you to find unread items, read specific Folders for new items, etc vs the whole inbox that POP3 limits me to.

    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!