How to change SQL Server collation
After installation of SQL Server If you need to change collation, you can do using the below commands. This code may harmful for your environment Please test on separate environment.
After installation of SQL Server If you need to change collation, you can do using the below commands. This code may harmful for your environment Please test on separate environment.
A SQL Server Agent proxy account defines a security context in which a job step can run. Each proxy corresponds to a security credential. To set permissions for a particular job step, create a proxy that has the required permissions for a SQL Server Agent subsystem, and then assign that proxy to the job step. …
SQL Server performance problem this script is important to check what query is running on the servers.
https://docs.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-server-services-transact-sql?view=sql-server-ver15 Other related Commands
Value of error log file you want to read: 0 = current, 1 = Archive #1, 2 = Archive #2, etc… Logfile type: 1 or NULL = error log, 2 = SQL Agent log Search string 1: String one you want to search for Search string 2: String two you want to search for to …
Generating scripts using T-SQL statements This script may returned to 8192 the maximum character. Generating script for Role and memberships Generating script for permission
It’s Important to check you are not blocking all users to connect to the server You can check how trigger use on the server Other References:
There are some tables in MSDB database which we can use for generating scripts msdb.dbo.sysmail_profilemsdb.dbo.sysmail_profileaccountmsdb.dbo.sysmail_accountmsdb.dbo.sysmail_server
This topic describes how to view the Microsoft SQL Server Agent job history log using SQL Server Management Studio, Transact-SQL, or SQL Server Management Objects. To view the job history log In Object Explorer, connect to an instance of the SQL Server Database Engine, and then expand that instance. Expand SQL Server Agent, and then …
There are a few ways to kick out the user from the database. I believe it works with most of SQL Server versions and editions. Complete your task…… Some time need to wait for rallback existing transactions