In SQL Server 2005 or later, data definition language (DDL) statements, such as CREATE INDEX, cannot be performed on the inserted and deleted tables inside DML triggers. Some DDL statements on the inserted and deleted tables are permitted in earlier versions of SQL Server.
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 ...
In SQL Server 2005, Notification Services applications cannot have two distributors with the same system name. For each application ...
In SQL Server 2005, syslockinfo and sp_lock may return unexpected values, and may return multiple rows where previous versions ...
In SQL Server 2005, with some exceptions, table hints are supported in the FROM clause of a query only when the hints are ...