{"id":303,"date":"2013-06-10T22:01:00","date_gmt":"2013-06-10T22:01:00","guid":{"rendered":"http:\/\/14@jodohost.com\/\/blog\/"},"modified":"2013-06-10T22:01:00","modified_gmt":"2013-06-10T22:01:00","slug":"how-to-create-the-special-sql-view-for-a-mssql-database","status":"publish","type":"post","link":"http:\/\/www.jodohost.com\/blog\/index.php\/2013\/06\/10\/how-to-create-the-special-sql-view-for-a-mssql-database\/","title":{"rendered":"How to create the special SQL view for a MSSQL database"},"content":{"rendered":"<p>Steps to create the special SQL view for the MSSQL database:<\/p>\n<p>1)\u00a0 Login to the SQL Server for the database for which the SQL view is to be created.<\/p>\n<p>2)\u00a0 Open the SQL Server Management Studio there.<\/p>\n<p>3)\u00a0 Expand the Security tab and select the option Login and right click on it to create the New Login.<\/p>\n<p>4)\u00a0 Fill the &#8220;Login name&#8221; field for creating the SQL view user and also set a complex password in the SQL Server Authentication option in the New Login window that appears.<br \/>\u00a0<br \/>5)\u00a0 Make sure the password is complex and properly generated by KeePass.<\/p>\n<p>6)\u00a0 Also only check the option &#8220;Enforced Password policy&#8221; while the rest of the options must be unchecked and then click OK.<\/p>\n<p>7)\u00a0 Now go to the particular database for which the SQL view is being created.<\/p>\n<p>8)\u00a0 Right click on the DB and go to its properties.<\/p>\n<p>9)\u00a0 On the new window that appears, select the option File.<\/p>\n<p>10) Write the created SQL View in the &#8220;Owner&#8221; field and click OK.<\/p>\n<p> ]]><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Steps to create the special SQL view for the MSSQL database: 1)\u00a0 Login to the SQL Server for the database for which the SQL view is to be created. 2)\u00a0 Open the SQL Server Management Studio there. 3)\u00a0 Expand the Security tab and select the option Login and right click on it to create the [&hellip;]<\/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\/303"}],"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=303"}],"version-history":[{"count":0,"href":"http:\/\/www.jodohost.com\/blog\/index.php\/wp-json\/wp\/v2\/posts\/303\/revisions"}],"wp:attachment":[{"href":"http:\/\/www.jodohost.com\/blog\/index.php\/wp-json\/wp\/v2\/media?parent=303"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.jodohost.com\/blog\/index.php\/wp-json\/wp\/v2\/categories?post=303"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.jodohost.com\/blog\/index.php\/wp-json\/wp\/v2\/tags?post=303"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}