SQL Server 2012 sp1 Latest

cumulative-update-8-for-sql-server-2012-sp1.aspx

Make SQL Server User Login

1. Open SQL Server Management Studio --> Choose Security Option

2. Select Security --> Logins --> New Login

3.  New Login Dialog Box --> General

                 

  4. Login New Dialog --> Server Roles

     5.  Login New Dialog --> User Mapping

Rename View

Rename View

Syntax

        Sp_rename ‘present name’, ‘new name’;

Example-

    

  Present Name or old name of view is mac2 but now I want to provide newview name to view so I am executing above given query.

Old Name (mac2)

                                             

                                                     Figure: Image before executing query

New Name (NewView)

                                                 

                                       

                                                     Figure: Image after executing query