MSSQL View grants for specific user

USE [database];

 SELECT
    class_desc
  , CASE WHEN class = 0 THEN DB_NAME()
               WHEN class = 1 THEN OBJECT_NAME(major_id)
               WHEN class = 3 THEN SCHEMA_NAME(major_id) END [Securable]

  , USER_NAME(grantee_principal_id) [User]
 , permission_name
 , state_desc
FROM sys.database_permissions
where USER_NAME(grantee_principal_id) = 'USER_NAME'
and state_desc = 'GRANT'
Till Next Time

MSSQL Connect to a database from a TSQL script

Step 1:

Switch to SQLCMD mode from the query menu in Management Studio:

Step 2:

Add the connection info using:

:Connect server_name[\instance_name] [-l timeout] [-U user_name [-P password]]
Till Next Time

MSSQL Check if Function or Procedure has changed

I use this query to check if a procedure or function has changed in the past 5 days:
[code]

SELECT * from ods.information_schema.routines i where routine_type in ('PROCEDURE' ,'FUNCTION') AND LAST_ALTERED > getdate() - 5

[/code]

Till Next Time