Assembly Trust Issues and Set Trustworthy ON in SQL Server 2008

Simply use below query:

USE <dbname>;
EXEC sp_configure 'clr enabled' ,1
GO

RECONFIGURE 
GO 
EXEC sp_configure 'clr enabled'   -- make sure it took 
GO 

USE <dbname>
GO 

EXEC sp_changedbowner 'sa' 
USE <dbname>
GO 

ALTER DATABASE <dbname> SET TRUSTWORTHY ON;

Get Monday Date of the Current Week in SQL Server 2008

Simply copy the query below:

SELECT DATEADD(wk, DATEDIFF(wk,0,GETDATE()), 0)

Current Week:

• Monday Date - SELECT DATEADD(wk, DATEDIFF(wk,0,GETDATE()), 0)
• Tuesday Date - SELECT DATEADD(wk, DATEDIFF(wk,0,GETDATE()), 0) + 1
• Sunday Date - SELECT DATEADD(wk, DATEDIFF(wk,0,GETDATE()), 0) + 6

In getting the Monday Date from the previous week, use SELECT DATEADD(wk, DATEDIFF(wk,0,GETDATE()), 0) - 7