Recently Executed Query

SELECT deqs.last_execution_time AS [Time], dest.TEXT AS [Query]

FROM sys.dm_exec_query_stats AS deqs CROSS APPLY sys.dm_exec_sql_text(deqs.sql_handle)

AS destORDER BY deqs.last_execution_time DESC







 More Information:SqlAuthority

Database Read Only In SqlServer

ALTER DATABASE dnName SET READ_ONLY
ALTER DATABASE dbName SET READ_WRITE

Error:HttpWebRequest WebExcepton: The remote server returned an error: (407) Proxy Authentication Required

<system.net>
    <defaultProxy
     useDefaultCredentials="true">
      <proxy autoDetect="True"/>
    defaultProxy>
  system.net>

Custom User in ASP.NET

GenericIdentity identity = new GenericIdentity("engin"); 
GenericPrincipal user = new GenericPrincipal(identity, new[] { "admin" }); 

context.User = user;

AutoStart Windows Service

public ProjectInstaller()
{
    InitializeComponent();
    this.Committed += ProjectInstaller_Committed;
}
void ProjectInstaller_Committed(object sender, InstallEventArgs e)
{
    var controller = new ServiceController("WinServiceName");
    controller.Start();
}

Forbidden Asp.net Pages in MVC 3

 <httpHandlers>
      <add path="*.aspx" verb="*" type="System.Web.HttpForbiddenHandler" validate="true" />
    httpHandlers>

WF Custom Activity

class MyActivity:Activity
    {
        protected override ActivityExecutionStatus Execute(ActivityExecutionContext executionContext)
        {
            Console.WriteLine(Name);
            return ActivityExecutionStatus.Closed;
        }
 
        public string Name
        {
            get;
            set;
        }
    }