![]() Therefore, Database Mail may not be able to attach files from a network share in cases where the command is run from a computer other than the computer that SQL Server runs on. Windows does not allow SQL Server to provide credentials from a remote computer to another remote computer. By default, Database Mail limits file attachments to 1 MB per file. The attachments list is of type nvarchar(max). Files in the list must be specified as absolute paths. 'file_attachments' Is a semicolon-delimited list of file names to attach to the e-mail message. Set = '\\Testfiles\Test1.csv \\Testfiles\Test2.csv'ĮXEC = 'Test = DECLARE varchar(max)ĭECLARE VARCHAR(MAX) = '\\Testfiles\Test1.csv'ĭECLARE VARCHAR(MAX) = ' \\Testfiles\Test2.csv'ĭECLARE VARCHAR(MAX) = ' \\Testfiles\Test3.csv'ĮXEC = 'Test = from MS document. Please try below T-SQL Declare varchar(max)
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |