{"id":279,"date":"2013-06-17T20:48:00","date_gmt":"2013-06-17T20:48:00","guid":{"rendered":"http:\/\/53@jodohost.com\/\/blog\/"},"modified":"2013-06-17T20:48:00","modified_gmt":"2013-06-17T20:48:00","slug":"how-to-change-database-schema-to-dbo","status":"publish","type":"post","link":"http:\/\/www.jodohost.com\/blog\/index.php\/2013\/06\/17\/how-to-change-database-schema-to-dbo\/","title":{"rendered":"How to change database schema to DBO"},"content":{"rendered":"

SELECT ‘EXEC(”sp_changeobjectowner @objname = ””’+
ltrim(u.name) + ‘.’ + ltrim(s.name) + ”””
+ ‘, @newowner = dbo”)’
FROM sysobjects s,
sysusers u
WHERE s.uid = u.uid
AND u.name ‘dbo’
AND xtype in (‘V’, ‘P’, ‘U’)
AND u.name not like ‘INFORMATION%’
order by s.name<\/p>\n

]]><\/p>\n","protected":false},"excerpt":{"rendered":"

SELECT ‘EXEC(”sp_changeobjectowner @objname = ””’+ ltrim(u.name) + ‘.’ + ltrim(s.name) + ””” + ‘, @newowner = dbo”)’ FROM sysobjects s, sysusers u WHERE s.uid = u.uid AND u.name ‘dbo’ AND xtype in (‘V’, ‘P’, ‘U’) AND u.name not like ‘INFORMATION%’ order by s.name ]]><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[2],"tags":[],"_links":{"self":[{"href":"http:\/\/www.jodohost.com\/blog\/index.php\/wp-json\/wp\/v2\/posts\/279"}],"collection":[{"href":"http:\/\/www.jodohost.com\/blog\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.jodohost.com\/blog\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.jodohost.com\/blog\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.jodohost.com\/blog\/index.php\/wp-json\/wp\/v2\/comments?post=279"}],"version-history":[{"count":0,"href":"http:\/\/www.jodohost.com\/blog\/index.php\/wp-json\/wp\/v2\/posts\/279\/revisions"}],"wp:attachment":[{"href":"http:\/\/www.jodohost.com\/blog\/index.php\/wp-json\/wp\/v2\/media?parent=279"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.jodohost.com\/blog\/index.php\/wp-json\/wp\/v2\/categories?post=279"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.jodohost.com\/blog\/index.php\/wp-json\/wp\/v2\/tags?post=279"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}