MS SQL Query
Wednesday, 26 March 2025
Change all Database owners at a time
USE [master]
GO
select 'ALTER AUTHORIZATION ON DATABASE::' + name + ' TO sa' from sys.databases
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
To Shrink Tempdb
To check progress of SQL Server Backup or Restore process
SELECT r.session_id , r.command , CONVERT(NUMERIC(6,2), r.percent_complete) AS [Percent Complete] , CONVERT(VARCHAR(20), DATEADD(ms,r....
To find all databases data files size and free space
IF OBJECT_ID('tempdb..#DBFiles') IS NOT NULL DROP TABLE #DBFiles CREATE TABLE #DBFiles ( [id] INT IDENTITY(1,1), [DBNam...
No comments:
Post a Comment