Sometime you might want to get row counts for all the tables in the entire SQL server. It might help you to identify large tables and tables have no records. Following script will help you to Get row count of...
Read MoreSometime you might want to get row counts for all the tables in the entire SQL server. It might help you to identify large tables and tables have no records. Following script will help you to Get row count of...
Read MoreBelow simple T-SQL codes can be used to take a SQL Database online or offline. This also can be done by SQL Server Management...
Read MoreBelow script will help you to extract a list of all the SQL Server Logins and a comma-separated list of the Server Roles they belong...
Read MoreFollowing script can be used to get list of Database Roles and Members for all the databases in current SQL server instance. This information can be pulled using SQL Server Management Studio , but if you have lots of databases it might...
Read MoreBelow script can be used to get a list of databases and their owner details for a current SQL Server instance. The quickest and east way to get those details is use sys.databases systems view with SUSER_SNAME () inbuilt security...
Read MoreThere are several methods to get the details of linked servers in SQL Server instance. Following simple script can be used to get list of linked servers in current SQL Server instance. This information also can be pulled using SQL...
Read MoreSQL Server instance information can be retrieved in number of different ways. Following T-SQL statement retrieves information such as Hostname, instance name, Server Edition (32 bit or 64 bit), ServicePack and cluster configuration from current SQL Server...
Read MoreIf log shipping is set up on your databases, it would be handy to have an overview report highlighting which database is being log shipped and checked whether they configured as a primary or a secondary server.
Below script can be used to check if the databases are configured for Database Mirroring for a given SQL Server instance. This information can be pulled using SQL Server Management Studio (See below the steps), but if you have lots...
Read MoreFollowing simple script can be used to check if there is any database in the current SQL instance is a part of the replication. This information can be pulled using SQL Server Management Studio, but if you have lots of...
Read More