Viewing 4 posts - 1 through 4 (of 4 total)
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...
July 25, 2002 at 9:17 am
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...
July 18, 2002 at 9:32 am
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...
June 19, 2002 at 11:48 am
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).
June 18, 2002 at 3:17 pm
Viewing 4 posts - 1 through 4 (of 4 total)