Run a SQL Server Job on Conditions of Different Job Hi Friends yesterday i got a mail from my project manager, regarding a job. Which is scheduled for 6:00 PM on daily basis. But he want to implement some conditions for it. Scenario: Actually I have configured a job in SQL Server which is executed
How to Extract Only Date from Getdate in SQL Server Hi friends, in this post we will learn How to Extract Only Date from Getdate in SQL Server or you can say that How to return the date part only from a SQL Server datetime. Sometime we have requirement of only date part from our datetime datatype or
Executing the query “ALTER INDEX [cndx_PrimaryKey_WorkflowLog] ON [dbo]…” failed with the following error: “The index “cndx_PrimaryKey_WorkflowLog” (partition 1) on table “WorkflowLogBase” cannot be reorganized because page level locking is disabled. Summary: Recently one of my server index reorganize job start failing. I checked the index name and then enable the page level locks on that
In this post we will learn how to store hashtable in session. By storing values in hashtable & then transfer them to a new page with session is easiest way. ASP.NET session state lets you associate a server-side string containing state data with a particular HTTP client session.Session is defined as a series of requests
10 Greatest Tricks for iPhone In this post I will tell you some of greatest tips, tricks, hacks and secrets of using iPhone. I am using iPhone since iPhone 4 and now upgraded to iPhone 6. In these years i have learnt a lot of useful and handy tips & tricks of using iPhone. 1.