In SQL Server 2000, SQL Server Agent can write logs to the file system for jobs that are owned by members of the sysadmin fixed server role. If the job owner is not a member of the sysadmin role and if the proxy account is enabled, SQL Server Agent can write logs to the file system by using the credentials of the proxy account. After you upgrade, jobs that are owned by users who are not members of the sysadmin fixed server role can no longer write logs to the file system. Instead, these users can select the option to write their logs to a table in the msdb database. Members of the sysadmin role can still write log files to the file system.
In previous versions of Analysis Services, you could specify dimension security so that a user saw a top level different ...
In remote mode, the Report Viewer control requires session state be enabled or Report Server connection information specified ...
In Reporting Services, report data sources can use Windows integrated security to connect to external data sources. Using ...
In SQL Server 2000 or earlier, logins that come from remote instances of SQL Server can be marked as trusted by using the ...
In SQL Server 2000, SQL Server Agent can write logs to the file system for jobs that are owned by members of the sysadmin ...
In SQL Server 2000, when SERVERPROPERTY('LCID') is run on binary collation servers, the function always returns a value of ...
In SQL Server 2005 or later versions, sysperfinfo returns a bigint value for the cntr_value column. Modify applications that ...
In SQL Server 2005 or later, data definition language (DDL) statements, such as CREATE INDEX, cannot be performed on the ...
In SQL Server 2005, any subscription rules that generate notifications must insert the notifications into the notification ...