We can use xp_msver stored procedure which returns more details than just the version. exec xp_msver Executing procedure will display following output. It is truncated and formatted. Index Name Internal_Value Character_Value —– ————– ————– ————— 1 ...

The tempdb system database is a global resource that is available to all users connected to the instance of SQL Server and is used to hold the following: Temporary user objects that are explicitly created, such as: global or local temporary tables, tem...