Aby zmienić scheme tabel na dbo w danej bazie danych MSSQL Server nalezy wykonac poniższe zapytanie:
DECLARE tabcurs CURSORFOR SELECT 'AKTUALNESCHEME.' + [name] FROM sysobjects WHERE xtype = 'u'OPEN tabcursDECLARE @tname NVARCHAR(517)FETCH NEXT FROM tabcurs INTO @tnameWHILE @@fetch_status = 0BEGIN EXEC sp_changeobjectowner @tname, 'dbo' FETCH NEXT FROM tabcurs INTO @tnameENDCLOSE tabcursDEALLOCATE tabcurs
