No

You may use this query to shrink data file.

declare @src bigint,@sql varchar(250),@filename varchar(25),@shrink bigint
set @filename='BEL_CDR'--change your data file name
select @shrink = size/128.0 from sysfiles(nolock) where name...

when I restore the next T-Log file it starts restoring rest of the files. It happens every day on different timings 🙁

Size of T-logs that was skipped was not more than 250 MB.

Is it possible to do it in SQL audit

Thanks a lot

Finally used sys.server_sql_modules to get the script of the triggers created.

Am using the below query to get the script of that trigger. But am unable to get the script of the trigger.

SELECT M.Definition as CreateScript

FROM sys.sql_modules as M INNER...

Thanks a lot Lowell... We found the name of the trigger with the view given by Lowell...

if am adding a new login am getting the below error:

"ad hoc updates to system catalogs are not allowed"

We have already created linked server now we cannot re-create the linked server. Is there any other possibilities to restrict linked server access for particular login alone.

is it possible with some triggers

That particular user should not fetch any data through linked server.