Post it in the SSIS fourm to get better response.

http://qa.sqlservercentral.com/Forums/Forum148-1.aspx

Declare @date Datetime

Set @date=getdate()--Or give any date u want

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 dest

Where dateadd(day, datediff(day, 0, deqs.last_execution_time), 0)=dateadd(day, datediff(day, 0,...

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 dest

ORDER BY deqs.last_execution_time DESC

You need not use a cursor for inserting multiple rows at...

I think you have not checked the code I posted. I had removed the variable assignment.

Again why do you use a temporory table and a cursor for a simple...

It will work...

declare @code_1 varchar(4000)

declare @code_2 varchar(4000)

declare @code_3 varchar(100)

select @code_1 = replicate('A',4000)

select @code_2 = replicate('B',4000)

Select @code_3='Select '

Exec (@code_3+ ''''+ @code_1 + '''' + ''''+ @code_2 +...

/*

You cannot assign Values to a variable like @featureoperationmapid=FeatureUserTypeMapping.FK_FeatureOperationMapID,@userid=Users.PK_UserID in an Insert Statement.

*/

CReate Proc YourProcName(@emailid varchar(50)) as

BEGIN

DECLARE @userid int

DECLARE @usertypeid int

DECLARE @userpermissionmap varchar(100)

DECLARE @featureoperationmapid int

--Query to get...

SQL Server Supports two types of Authentication one is SQL server Authentication and another is windows integrated authentication. The Blank columns in NT User name means those are the sessions...

I meant to say

ALTER TABLE [dbo].[tblProgFundingYearCategory] DROP CONSTRAINT [FK_tblProgFundingYearCategory_tblProgFundingCategory]

Yes. The DTS is built in tool with SQL server Database and you need not install anything more. But in the Dropdown list, you may not see any proper Provider...

You are going to truncate the Table tblProgFundingCategory. So you need to drop the foreign keys of some other tables those are having references on the Primary key of your...

CREATE TRIGGER delUsers ON db_users AFTER DELETE

AS

BEGIN

SET NOCOUNT ON

Declare

@User_name varchar(100),

@body varchar(100)

Select @User_name=usrname from deleted

Set @body='User ' +@User_name+ ' Deleted'

EXEC msdb.dbo.sp_send_dbmail

@profile_name = 'Mail Profile...