Following 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 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-6628f5da0f850678160434/] 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 MoreThe most commonly used server configuration options are available through SQL Server Management Studio. But all the server configuration options including advanced configuration options are accessible only through sp_configure system stored procedure...
Read MoreBasic emails can be sent using below user-defined stored procedure. Before you use this stored procedure you have to create a profile and account using the Configure Database Mail Wizard which can be accessed from the Configure Database Mail menu...
Read MoreDBCC SHRINKDATABASE command shrink all data and log files for a specific database. The TRUNCATEONLY option doesn't do any compacting and just releases any free portion of the file to the OS. It doesn't do the compacting because that's what...
Read More