New answers tagged

2 votes
Accepted

Prevent users from sending an email attachment in sql server

I couldn't find a way to prevent it, but I created a trigger to send an email when someone sends attachment. It works fine for me. CREATE OR ALTER TRIGGER trg_attachment_notification ON msdb.....
Farid Zahidov's user avatar
0 votes

Prevent users from sending an email attachment in sql server

you cannot prevent, specially sysadmins to use the sp_send_dbmail procedure with or without attachments but you can see who did what and when, and if there were attachments or not. check this out ...
Marcello Miorelli's user avatar
0 votes
Accepted

sql bigger parameter then specyfied - no error - just taking substring? why?

Declare @i varchar(5)='ppppppppppp' Select @i --- output ppppp (without any error) Declare @t table(col varchar(5)) insert into @t values('pppppppppp') Select * from @t --Error message "string ...
KumarHarsh's user avatar
  • 1,628
0 votes

Execution timeout exception in ASP.NET core

Another way to troubleshoot this problem is by using Query Store. After enabling Query Store on the database your problem query will most likely appear on the "Regressed Queries" report. ...
Frank DeWysockie's user avatar

Top 50 recent answers are included