|
| PORTAIL | ANNUAIRE | ARTICLES | COMPARATEUR HÉBERGEURS | DEVIS | FORUMS | RÉDUCTEUR D'URL |
|
27/03/2008, 14h00
|
#1 (permalink) |
Messages: n/a
Hébergeur: |
Change maintenance plan owner
/*Here's how to change the owner of a maintenance plan to dbo in SQL Server
2005*/ --to find the name and owner of the maintenance plan --select * from msdb.dbo.sysdtspackages90 --to find the sid you want to use for the new owner --select * from sysusers UPDATE [msdb].[dbo].[sysdtspackages90] SET [ownersid] = 0x01 WHERE [name] = 'MaintenancePlan' |
|
 |
| Outils de la discussion | |
|
|
