I will tell you below metadata functions in this article. APP_NAME COL_LENGTH DATABASEPROPERTYEX SERVERPROPERTY DB_ID DB_NAME OBJECT_ID OBJECT_NAME SCHEMA_ID SCHEMA_NAME STATS_DATE APP_NAME Function: This function …
Read More »Tag Archives: SERVERPROPERTY
@@VERSION, SERVERPROPERTY and @@MAX_CONNECTIONS Functions in SQL Server(TSQL)
The maximum number of connections that an instance can accept varies by version. With the @@MAX_CONNECTIONS function, we can query the number of default maximum …
Read More »