During the installation of SQL Server, an option for security is asked for, that is, the type of authentication
Continue readingCategory: SQL Server -DBA
SQL Server -DBA, SQL Server Services, who dropped or altered tables,procedures or databases in SQL Server, What in SQL Server
How to Create a Windows Login in SQL Server
–Creating a Windows Login for SQL Server –Create a SQL Login of Windows user account to access the SQL Server
Continue readingGrant access to the profile to all msdb database users &send a test email in SQL Server
Grant access to the profile to all msdb database users EXECUTE msdb.dbo.sysmail_add_principalprofile_sp @profile_name = ‘Default Public Profile’, @principal_name = ‘public’,
Continue readingview information about mail in msdb database using the following scripts:
view information about mail in msdb database using the following scripts: use msdb go SELECT * FROM
Continue readingCreate a Database Mail profile & Add the account to the profile
Create a Database Mail profile EXECUTE msdb.dbo.sysmail_add_profile_sp @profile_name = ‘Default Public Profile’, @description = ‘Default public profile for all users’;
Continue readingCreate a Database Mail account in SQL SERVER
Create a Database Mail account through below query EXECUTE msdb.dbo.sysmail_add_account_sp @account_name = ‘SQL’, @description = ‘Account used by all mail
Continue readingHow to Enable Database Mail in SQL SERVER
Enable Database Mail for instance EXECUTE sp_configure ‘show advanced’, 1; RECONFIGURE; EXECUTE sp_configure ‘Database Mail XPs’,1; RECONFIGURE; GO
Continue readingDBCC CHECKDB
WHAT IS THE PURPOSE OF DBCC CHECKDB:- The primary purpose is to check both the logical and the physical integrity
Continue readingWhat is the SQL Server Agent?
SQL Server Agent:- • SQL Server Agent uses SQL Server to store job information • A job is a specified
Continue readingShrinking Database In SQL SERVER
Database Shrinking Commands • DBCC SHRINKDATABASE (ShrinkDB, 10) • DBCC SHRINKFILE (ShrinkDB, 10) Note:- Imapact of shrinking database:- 1.
Continue reading