MSSQL and TSQL Programming and TSQL Examples
Hello to everyone, In this article, I will try to give information about seeing object-based privileges in SQL Server. In SQL Server, in some cases, you may want to see object-based privileges. You can easily do this using the code below. SELECT permission_name, s.name, o.name, dpr.name, o.type_desc FROM sys.database_permissions AS...
Hello everyone, In this article, I will provide information about Recovery Pending error in SQL Server. The reason for Recovery Pending error in SQL Server may be due to power outages, insufficient resources of the database server, or overloading because you did not disconnect the database connections on your software....
Hello everyone, In this article, I will try to give information about detecting unused tables in SQL Server. In SQL Server, you may want to detect unused tables in some cases. You can easily do this using the code below. SELECT tablolar.name AS TabloAdi, bolumler.rows AS KayitSayisi FROM sys.tables tablolar...
Hello everyone, In this article, I will try to give information about seeing which tables were processed last in SQL Server. In SQL Server, in some cases, you may want to see which tables were processed last. You can easily do this using the code below. SELECT DB_NAME(ius.[database_id]) AS [Database],...
