Redirecting Browser Requests to Another Folder or Web Site

Comments Off

To redirect browser requests to another folder or Web site:

  1. Start IIS Manager.
  2. Click to expand * server name, where server name is the name of the server.
  3. Right-click either the Web site or the folder that you want to redirect, and then click Properties.
  4. Click one of the following tabs that is appropriate to your situation:
    • Home Directory
    • Virtual Directory
    • Directory
  5. Under When connecting to this resource, the content should come from, click A redirection to a URL.
  6. Type the URL of the destination folder or Web site in the Redirect to box.
  7. And that’s it.

sp_rename

Comments Off

Changes the name of a user-created object (i.e. table, column, or user-defined data type) in the current database.

Rename a table
This example renames the customers table to custs.

EXEC sp_rename 'customers', 'custs'

Rename a column
This example renames the contact title column in the customers table to title.

EXEC sp_rename 'customers.[contact title]', 'title', 'COLUMN'