we can find out the login names having sysadmin rights from below query EXEC sp_helpsrvrolemember ‘sysadmin’
Continue readingList all access permission or provisioned to a SQL user or Windows user/group directly
SELECT [UserType] = CASE princ.[type]
Continue readingSQL Server Roles & Database Level Role in SQL Server?
What are SQL Roles ? Predefined collection of objects and permissions? Roles allow the dba to manage permissions more
Continue readingCreate a SQL Login in SQL Server
USE [master] GO CREATE LOGIN [Pintos] WITH PASSWORD=N’password123′ –password does not meet complexity (use upper ‘P’) MUST_CHANGE, DEFAULT_DATABASE=[master], CHECK_EXPIRATION=ON,
Continue readingChoosing Authentication Mode for SQL Server
During the installation of SQL Server, an option for security is asked for, that is, the type of authentication
Continue readingHow 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 reading