In the Object Explorer, connect to an instance of the [!INCLUDE ssDEnoversion] and then expand that instance. Right-click SQL Server Agent, and then click Properties. In the SQL Server Agent ...

To perform its functions, SQL Server Agent must be configured to use the credentials of an account that is a member of the sysadmin fixed server role in SQL Server. The account must have the following ...

As a heavy user of other RDBMS data platforms, I have long appreciated the extra effort that Microsoft put into their data management and administration tool, the SQL Server Management Studio (SSMS).

Here are a few of my favourite secrets to make life easier in SSMS for SQL Server 2012. Multiplicity The Object Explorer Details pane doesn’t show up by default, but you’ll definitely want to ...