Autonomous Transaction in oracle An autonomous transaction is an independent transaction started by another transaction called as main transaction. It let you allow to execute various DML statements, commit and rollback without commiting or rolling back...
Backup's =========== full:: backup database dbname to disk='path' Differential:: backup database dbname to disk='path'with differential log:: backup log dbname to disk='path' mirror:: backup database dbname to disk='path' mirror backup database dbname...
Frequently you want to know how fast your database has been growing. Based on the backup history we can get a rough outline of the growth of a database, over time, from the msdb..backupset table. This query will give the size of the backup, every time...
If you see Agent XPs disabled from SQL Server Management Studio (as per below picture), you will be unable to start SQL Server Agent from Management Studio directly. Option 1: Start SQL Server Agent from SQL Server Configuration Manager. Agent XPs will...
SQL Server provides a dedicated administrator connection (DAC). The DAC lets an administrator access a running server to execute diagnostic functions or Transact-SQL statements, or to troubleshoot problems on the server, even when the server is locked...
What are the differences in the SQL Server Agent roles? SQLAgentUserRole Ability to manage Jobs that they own SQLAgentReaderRole All of the SQLAgentUserRole rights The ability to review multiserver jobs, their configurations and histor SQLAgentOperatorRole...
Moving the master Database To move the master database, follow these steps. From the Start menu, point to All Programs, point to Microsoft SQL Server, point to Configuration Tools, and then click SQL Server Configuration Manager. In the SQL Server Services...
what permissions to require to create a job in sql server To configure a user to create or execute Microsoft SQL Server Agent jobs, you must first add an existing SQL Server login or msdb role to one of the following SQL Server Agent fixed database roles...
Windows Authentication and Mixed mode Windows Authentication mode connects to an instance of SQL Server through a Windows NT 4.0 or Windows 2000 user account. Mixed mode (Windows Authentication and SQL Server Authentication) connect to an instance of...
SQL Server Database Security :--- ------------------------------------------------ Database roles (also referred to as database-level roles) are security roles that exist on a database level, as opposed to the server level. If you are familiar with any...
