--Permission Capture

SET NOCOUNT ON

SELECT

[-- SQL Statements --]--,[ScriptOrder]

FROM

(

SELECT

'-- [ DB CONTEXT ] --' + Char(13) AS [-- SQL Statements --] ,10 as [ScriptOrder]

UNION

SELECT

'USE' + SPACE(1) + QUOTENAME(DB_Name()) + char(13), 20 [ScriptOrder]

--'USE'...

To work around this issue, create a transaction log backup on the primary replica or Primary Database, restore the log backup on the secondary replica with no recovery, and then...

I added the SQL Service Account into local admin group on windows.
before it gave me permission error like this:- 
FCB::Open failed: Could not open file D:\tempdb.mdf for file...

//** Use this query and you will all set**//txtPost_CommentEmoticon(':-)');

USE Master

GO

ALTER LOGIN SQL_Account WITH PASSWORD = ‘currentpassword(SamePassword)’

GO

ALTER LOGIN SQL_Account WITH

CHECK_POLICY = OFF,

...