web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Suggested Answer

Capture Logins

(0) ShareShare
ReportReport
Posted on by 40
I am moving from a SQL2019 to a SQL2022 and the capture login script only catches "THE COMMAND HAS COMPLETED"  is there a newer capture logins script
Categories:
I have the same question (0)
  • Suggested answer
    Lisa at AonC.com Profile Picture
    1,025 Super User 2026 Season 1 on at
    If you aren't receiving an error, you are probably on a valid script.

    It sounds like you may need to switch your SSMS results tab.  Saving the results to a file is documented here:

    https://learn.microsoft.com/en-us/troubleshoot/dynamics/gp/transfer-gp-installation-new-server#transfer-instructions

    There is a blog post here about some older SQL version issues:

    Capture Logins Script from KB 878449 generates Invalid object name error | Microsoft Learn

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 705 Super User 2026 Season 1

#2
Abhilash Warrier Profile Picture

Abhilash Warrier 370 Super User 2026 Season 1

#3
Giorgio Bonacorsi Profile Picture

Giorgio Bonacorsi 328

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans