Time, date & user stamping a modified record?

Home Forums Other Microsoft Servers and SaaS SQL Server 2005 / 2008 / 2008 R2 / 2012 / 2016 Time, date & user stamping a modified record?

Viewing 1 post (of 1 total)
  • Author
    Posts

  • QuattroDave
    Member
    #163002

    Hi all,

    I’m rather new to SQL so please excuse my knowledge & terminology, I’m trying to learn by creating myself a database using SQL 2008 R2…

    I’ve managed to create 2 fields that auto populate:
    TS_CREATED with datatype datetime2(3) default binding (sysdatetime())
    &
    USR_CREATED with datatype varchar(15) default binding (suser_sname())

    These both work as I hoped, logging the username, time and date of when a record was created. I’m really stuck on how to create the same thing but for when a record is modified…. Is it even possible?

    Thanks

    Dave

Viewing 1 post (of 1 total)

You must be logged in to reply to this topic.

External Sharing and Guest User Access in Microsoft 365 and Teams

This eBook will dive into policy considerations you need to make when creating and managing guest user access to your Teams network, as well as the different layers of guest access and the common challenges that accompany a more complicated Microsoft 365 infrastructure.

You will learn:

  • Who should be allowed to be invited as a guest?
  • What type of guests should be able to access files in SharePoint and OneDrive?
  • How should guests be offboarded?
  • How should you determine who has access to sensitive information in your environment?

Sponsored by:

 
Office 365 Coexistence for Mergers & Acquisitions: Don’t Panic! Make it SimpleLive Webinar on Tuesday, November 16, 2021 @ 1 pm ET

In this session, Microsoft MVPs Steve Goodman and Mike Weaver, and tenant migration expert Rich Dean, will cover the four most common steps toward Office 365 coexistence and explain the simplest route to project success.

  • Directory Sync/GAL Sync – How to prepare for access and awareness
  • Calendar Sharing – How to retrieve a user’s shared calendar, or a room’s free time
  • Email Routing – How to guarantee email is routed to the active mailbox before and after migration
  • Domain Sharing – How to accommodate both original and new SMTP domains at every stage

Aimed at IT Admins, Infrastructure Engineers and Project Managers, this session outlines both technical and project management considerations – giving you a great head start when faced with a tenant migration.the different layers of guest access and the common challenges that accompany a more complicated Microsoft 365 infrastructure.

Sponsored by: