Forum Replies Created

Viewing 4 posts - 1 through 4 (of 4 total)

  • RE: Indexing Views

    Seems you CAN create indexes on views using SQL Server Standard edition. Check out the following:

    USE Northwind

    GO

    --Set the options to support indexed views.

    SET NUMERIC_ROUNDABORT OFF

    GO

    SET ANSI_PADDING,ANSI_WARNINGS,CONCAT_NULL_YIELDS_NULL,ARITHABORT,QUOTED_IDENTIFIER,ANSI_NULLS ON

    GO

    --Create view.

    CREATE...

  • RE: Indexing Views

    I previously checked out that BOL topic and found the following:

    Note: You can create indexed views only if you install Microsoft SQL Server 2000 Enterprise Edition or Microsoft SQL...

  • RE: Backup Error-Login Failed...

    SQL Agent is running under the ‘Administrator’ account. I modified this account (via Control Panel/Admin Tools/Computer Mgmt/Local Users & Groups) to add the 'Backup Operators' group, ran the Database Maintenance...

  • RE: Backup Error-Login Failed...

    I did, same error. All Tasks/Backup Database works fine for manual backups but I need to set up a schedule (especially for the transaction logs).

Viewing 4 posts - 1 through 4 (of 4 total)