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 MoreBelow 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 MoreFollowing stored procedure can be used find out whether particular Windows user or group account is mapped to a current SQL instance . If given Windows user or group account exists in the SQL server it will returns the account...
Read Morexp_cmdshell extended stored procedure allows to issue operating system commands directly to the Windows command shell via T-SQL code. By default xp_cmdshell extended stored procedure is disabled on new installations and can be enabled by using code shown...
Read MoreFollowing stored procedure can be used to search any string in the definition of any stored procedure in all the user databases in a given SQL server...
Read MoreBelow user-defined stored procedures can be used to get the List of Object Dependencies for a given object. Method 1 [crayon-6622c4e86b4db193867871/] Method...
Read MoreSometimes SQL developers want to put some logic into their T-Sql code to check whether SQL Server running is in single-user mode . The SERVERPROPERTY() built in metadata system function can be used to identify the single-user mode. SERVERPROPERTY() function ...
Read MoreSometimes you need to get to know the status of particular SQL Server Agent job on a given date. Below Stored Procedure can be used to check whether supplied SQL Agent Job has completed successfully on the given...
Read MoreIn-Memory OLTP is a memory-optimized database engine integrated into the SQL Server engine. The SERVERPROPERTY() built in metadata system function with IsXTPSupported Property can be used to identify whether Server supports In-Memory...
Read More