1. Create a file named sendmail.vbs and save on c:\winnt.
2. Put this code:
Set objEmail = CreateObject(“CDO.Message”)
objEmail.From = “yourmail@yourserver.com”
objEmail.to = WScript.Arguments(1)
objEmail.Subject = WScript.Arguments(2)
objEmail.Textbody = WScript.Arguments(3)
objEmail.Configuration.Fields.Item (“http://schemas.microsoft.com/cdo/configuration/sendusing”) = 2
objEmail.Configuration.Fields.Item (“http://schemas.microsoft.com/cdo/configuration/smtpserver”) = “your_SMTP_server_IP_or_name”
objEmail.Configuration.Fields.Item (“http://schemas.microsoft.com/cdo/configuration/smtpserverport”) = 25
objEmail.Configuration.Fields.Update
objEmail.Send
set objEmail = Nothing
3. And now, complete creating a stored procedure:
USE MASTER
GO
CREATE PROCEDURE sp_sendmail @mail varchar(150), @subject varchar(150), @textbody varchar(800) AS
DECLARE @MSG_SENT VARCHAR(1200)
SELECT @MSG_SENT = ‘cscript c:\winnt\sendmail.vbs /p “‘ + @mail + ‘” “‘ + @subject + ‘” “‘ + @textbody + ‘”‘
exec master.dbo.xp_cmdshell @MSG_SENT, NO_OUTPUT
SELECT ‘Mail sent!’
GO
******************************************************************
Ok, allright!
Send a mail to test:
EXEC master.dbo.sp_sendmail ‘yourto@yourserver.com’, ‘subject’, ‘message’
| Article ID |
: |
925083 |
| Last Review |
: |
March 5, 2008 |
| Revision |
: |
4.0 |
SYMPTOMS
When you try to upload a large file to a document library on a Microsoft Windows SharePoint Services 3.0 site, you receive the following error message:
Request timed out.
This problem occurs if the following conditions are true:
| • |
You configured the Microsoft Windows SharePoint Services 3.0 site to support large files by following the steps on the following Microsoft Web site:
|
| • |
The file is larger than 50 megabytes (MB). |
Back to the top
RESOLUTION
To resolve this issue, use one or more of the following methods:
| • |
Increase the maximum upload size for the virtual server settings in Microsoft Internet Information Services (IIS). |
| • |
Increase the connection time-out setting in IIS. |
| • |
Add the executionTimeout value in the Web.config file. |
Back to the top
Increase the maximum upload size
| 1. |
Click Start, point to All Programs, point to Administrative Tools, and then click SharePoint Central Administration. |
| 2. |
Under Virtual Server Configuration, click Configure virtual server settings. On the Virtual Server List page, click the virtual server that you want to change. |
| 3. |
On the Virtual Server Settings page, under Virtual Server Management, click Virtual server general settings. |
| 4. |
Under Maximum upload size, type the maximum file size in megabytes that you want, and then click OK. You can specify a maximum file size up to 2,047 megabytes. |
Back to the top
Increase the connection time-out setting
By default, the IIS connection time-out setting is 120 seconds. To increase the connection time-out setting, follow these steps:
| 1. |
Click Start, point to All Programs, point to Administrative Tools, and then click Internet Information Services (IIS) Manager. |
| 2. |
Right-click the virtual server that you want to configure, and then click Properties. |
| 3. |
Click the Web Site tab. Under Connections, type the number of seconds that you want in the Connection time-out box, and then click OK. |
Back to the top
Add the executionTimeout value
| 1. |
Use Notepad to open the Web.config file.
By default, this file is in the following location:
Program Files\Common Files\Microsoft Shared\Web server extensions\12\TEMPLATE\LAYOUTS
|
| 2. |
Add the executionTimeout value that you want. For example, replace the value as follows.
Existing code
<location path="upload.aspx">
<system.web>
<httpRuntime maxRequestLength="2097151" />
</system.web>
</location>
Replacement code
<location path="upload.aspx">
<system.web>
<httpRuntime executionTimeout="999999" maxRequestLength="2097151" />
</system.web>
</location>
|
| 3. |
After you change the file, click Save on the File menu. |
| 4. |
Use Notepad to open the Web application Web.config file. By default, this file is in the following folder:
Inetpub\wwwroot\wss\VirtualDirectories\VirtualDirectoryFolder
|
| 5. |
Change the following line in the file.
Existing line
<httpRuntime maxRequestLength="51200" />
Replacement line
<httpRuntime executionTimeout="999999" maxRequestLength="51200" />
|
| 6. |
After you change the file, click Save on the File menu. |
| 7. |
Exit Notepad. |
#############
### CODE #####
############
<style>.ms-navframe{ display:none; }</style>
#############
### CODE #####
############
SYMPTOMS
