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: DB_ID()
SQL Server Does Not Truncate the Transaction Log After Log Backup and Can Not Shrink the Transaction Log
If you regularly backup your sql server transaction log of your database that uses full recovery model, it truncate the Transaction Log file after each …
Read More »