Dear Green,

found the fix it need to be disable at under server Audit specification  folder then it can be done

Dear Green ,

Its in disable state in both server level and in the database base level also even getting error --You may have disabled the audit, but you haven't disabled...

Dear SSC Guru ,

we found the cause as the user level permission were having earlier so that user login can have execute permission on stored procedures

later it was revoked so...

Dear Ant-green

Yes it is a 2019 rtm version

DatabaseMail process is shutting down is getting in the log , attached dbmail log as well please suggest i need to fix it...

Dear Ant-Green

Use basic authentication and give it the email address and password needed to login to that mailbox you wish to send mail as. -- it already there but still...

If I answer the questions, what does the job pay and when do I start?---> I Just need a second opinion to make my self much better while answering ,...

Dear 'Jeffrey Williams

I have gone through all these what ever you have explained in detail

Me-- actually this is a question in one of the interview where he asked same scenario...

Dear Ssc guru

this might be same as your post but it is not a duplicate

Brandie Tarvin

Iin my case one same scenario in always on

AG group is in synronus- automatic with...

@SSC Guru

start at the basics: can we narrow it down to see if it could have been a DBA process or a Business process? in application they said no abnormalities...

Hi I have to configure Always on DB standard edition

i have installed 2019 standard edition sqlserver basic installation , now for always on what additional services i need to add...

HI Ant-Green , can you provide any document where i can have prerequisites for always on can be configured in  different subnets (IP"S)

with standard 2019 sqlserver edition because i need...

HI Ant-Green , can you provide any document where i can have prerequisites for always on can be configured in  different subnets (IP"S)

because i need to submit to client before...

sql server drives have enough space and also we are trying to resolve tempdb issues to make sure disk wont increase due to tempdb growth.

C2 level audit level trace is enabled , due to which .trc files is generating huge on daily basis

it is reaching more than 80 gb , so we concluded to...

Need modification in this script with these columns ,is_disabled,User Type, User category

DECLARE @DB_USers TABLE

(DBName sysname, UserName sysname, LoginType sysname, AssociatedRole varchar(max),create_date datetime,modify_date datetime)

INSERT @DB_USers

EXEC sp_MSforeachdb

'

use [?]

SELECT ''?'' AS DB_Name,

case prin.name...

• This reply was modified 4 months, 1 week ago by  naga.rohitkumar.