Sunday, January 12, 2025

MS-SQL Server - I am Keen to Know 'BIP'

BIP

which is nothing but Bulk Insert Permissions 


Refer below article

https://learn.microsoft.com/en-us/answers/questions/293852/sql-server-bulk-insert-permisisons



Thanks with Regards



T. Amit Vaid S.

1 comment:

अमित विजय श्याम वैद (रजवाड़ा हिन्दू) {हक़ से आजादी मिला आराम} Blog said...

Show Old Tables

SELECT
t.name AS TableName,
o.create_date AS CreationDateTime
FROM
sys.tables t
INNER JOIN
sys.objects o ON t.object_id = o.object_id
WHERE
o.type = 'U'
ORDER BY
o.create_date DESC

https://learn.microsoft.com/en-us/answers/questions/1193110/how-to-identify-tables-which-are-changing-very-oft