If you want to get a list of SQL Server databases and their basic configuration details on your current SQL server instance, you could manually open database property windows on each and every database through SSMS and note down the...
Read MoreIf you want to get a list of SQL Server databases and their basic configuration details on your current SQL server instance, you could manually open database property windows on each and every database through SSMS and note down the...
Read MoreSometime you might want to get a list of SQL Server Agent Jobs and their schedules on your current SQL server instance. You could manually open each and every Agent job through SSMS and note down the details you required,...
Read MoreSometimes SQL Database administrators want to check whether given SQL Server instance is in clustered environment. The SERVERPROPERTY() built in metadata system function can be used to identify the clustered mode. SERVERPROPERTY() function with IsClustered Property will return “0” for...
Read MoreFollowing simple script will help you to find out how long has your SQL Server been running since last startup. Please make note of that this script use tempdb information to calculate the server running time and tempdb system database is...
Read MoreBelow SQL Script will help you to find current location of Data and Log File of the Database. It shows the file location of every database on a SQL Server...
Read MoreYou might need to know the IP Address and the TCP Port of the currently connected SQL Server; this simple SQL Script will help you to find the Server IP Address. This script only works for connections that are using...
Read MoreDatabase Mail feature can be used to send e-mail messages from the SQL Server Database Engine. Database Mail use SMTP server to send emails. Assume you want to get a list of SMPT server used by Database Mail due to...
Read MorePresume there are several older versions of SQL Server databases exist in your current SQL Server instance and you want to change all of those Databases Compatibility level to higher version at once. Below script might be helpfully you to...
Read MoreSometimes there can be certain older versions of SQL Server databases exist in your current SQL Server instance. If you want to check the compatibility level of all the databases in your current SQL Server instance following script might be...
Read More
Earlier today I was experiencing issues with my PC and the GUI for SQL Agent jobs wasn't appearing on screen. I really needed to stop a job that had become stuck over the weekend, so I turned to T-SQL and...
Read More