SQL Server Agent Fixed Database Roles

https://learn.microsoft.com/en-us/sql/ssms/agent/sql-server-agent-fixed-database-roles?view=sql-server-ver16 SQL Server has the following msdb database fixed database roles, which give administrators finer control over access to SQL Server Agent. The roles listed from least to most privileged access are: SQLAgentUserRole SQLAgentReaderRole SQLAgentOperatorRole SQLAgentUserRole Permissions SQLAgentUserRole is the least privileged of the SQL Server Agent fixed database roles. It has permissions on only operators, local jobs,... » read more

Deploy SSIS Package to SQL Server from .dtsx package file

Open up SSMS -> Connect Integration Services… (Administration mode) Expand the “Stored Packages” folder -> MSDB folder -> right click and select “Import Package” Package location: File System Package path: C:\Deployment\MyPackage.dtsx Package name: MyPackage Protection level: Keep protection level of the original package Note: If package already exist in the MSDB, will get a prompt... » read more

An installation package for the product Microsoft OLE DB Driver for SQL server cannot be found: msoledbsql.msi

Error: Error Description: An installation package for the product Microsoft OLE DB Driver for SQL server cannot be found, Try installing again using a valid copy of the installation package ‘msoledbsql.msi’ Fix: Uninstall all OLE and ODBC drivers and re run the setup. References: https://stackoverflow.com/questions/71857345/error-when-installing-microsoft-sql-server-2019-cannot-find-the-microsoft-ole-d

Brent Ozar Training

Homepage | Brent Ozar Unlimited Brent Ozar Unlimited Level 2 Bundle | Brent Ozar Unlimited The BrentOzar.com Annual Black Friday Sale – Brent Ozar Unlimited® You’ve used sp_Blitz and the First Responder Kit to learn a lot about your databases. You read the blog regularly, subscribed to the free newsletter, watched some of my YouTube videos, maybe... » read more

Changing Database Column Order

Issue: Changing the order of database table columns. Resolution: Have to re-create the table in order to change the order of the database column. Right click on table -> Designers -> Re-arrange table column -> Save Note: Make sure the “Prevent saving changes that require table re-creation” is unchecked. Change this my going to SQL... » read more