logo
Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error

Options
Go to last post Go to first unread
phaag  
#1 Posted : Monday, May 14, 2018 4:07:50 PM(UTC)
phaag

Rank: Administration

Groups: Administrators, Registered
Joined: 1/2/2018(UTC)
Posts: 9
United States

If you're using Doc Attach in Dynamics GP, large files can pretty quickly grow the size of your database. The SQL script below will help you find the biggest ones (change the number after the top keyword to get a longer or shorter list).

Code:

select top 50
	r.[Attachment_ID]
	,SizeInMB=datalength([BinaryBlob])/1024
	,[fileName],
	r.*
from
	[coAttachmentItems] s
	inner join CO00102 r on r.Attachment_ID=s.Attachment_ID
order by
	datalength([BinaryBlob]) desc
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.