Managing Session Timeouts in .NET

If you are using ASP.NET 2.0, use have to check in the IIS. Open the IIS, click on the Application Pools, Select the Application pool for your application. Right Click on that, Select Properties. In the Performance tab, Set the idle timeout as your desired minutes for "shutdown worker processes after being idle for ..... minutes". Apart from this you have to set the timeout in web.config as said by the other friends.

import/export BLOB

http://blog.rptea.com/post/Simple-scripts-to-insert-File-to-BLOB-field-and-export-BLOB-to-File-system.aspx

CREATE TABLE [dbo].[TmpBin](
     [MyId] [int] IDENTITY(1,1) NOT NULL
   , [MyDesc] [varchar](50) NULL
   , [MyBin] [varbinary](max) NULL ) 
ON [PRIMARY] 

INSERT INTO (MyDesc, MyBin) 
Select 'MyDesc01' 
   , BulkColumn from Openrowset( Bulk 'C:\temp\image1.jpg', Single_Blob) as tt 

Insert TmpBin(MyDesc, MyBin) 
Select 'MyDesc02' 
, BulkColumn from Openrowset( Bulk 'C:\temp\image2.jpg', Single_Blob) as tt

INSERT INTO TmpBin(MyDesc, MyBin) 
SELECT 'MyDesc03' 
     , BulkColumn 
FROM Openrowset( Bulk 'C:\temp\image3.jpg', Single_Blob) as tt