sp_configure "Allow updates" , 1
go
update sysdatabases
set status = status & ~ 256
where (name = 'database name')
go
sp_configure "Allow updates" , 0
go
Was this article helpful?
Views: 7167
Cambridge Data Centre
Still need help?
Talk to a UK engineer — we'll help with hosting, servers, billing or migrations with no sales pressure.