-
Information about SQL Server Agent job schedules
This below table is used to schedule SQL Server Agent job Column name Data type Description schedule_id int ID of the SQL Server Agent job schedule. schedule_uid uniqueidentifier Unique identifier of the job schedule. This value is used to identify a schedule for distributed jobs. originating_server_id int ID of the master server from which the…
-
Recover SQL statements
Recover MS SQL statements which get deleted/closed accidentally OR Returns query with time.
-
Add Linked Servers using query
exec sp_linkedservers exec sp_addlinkedserver @server=’SERVERNAME’ exec sp_addlinkedsrvlogin ‘SERVERNAME’, ‘false’, null, ‘USERNAME’, ‘PASSWORD‘