question

sakuraime avatar image
0 Votes"
sakuraime asked NavtejSaini-MSFT commented

Azure sql database sys.sysprocesses loginname

I found there are some name in loginname column from sys.sysprocesses
is like the following

guid@guid

how to decode it as a user name of the database ?

azure-sql-database
· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Note that sys.sysprocesses is a deprecated backwards compatibility view. Use sys.dm_exec_sessions instead.

0 Votes 0 ·

@sakuraime Please let us know if you need any further help.

0 Votes 0 ·

1 Answer

NandanHegde-7720 avatar image
0 Votes"
NandanHegde-7720 answered

Hey,
There are App registrations in Azure AD.
So usually it is clientid@tenantid

verify whether the id after @ is the tenantid in which Azure SQL database is present

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.