Discontinued or Deprecated Features in SQL Server 2005

FEATURES DEPRECIATED IN SQL SERVER 2005

Deprecated features include features that will not be supported in the next version of SQL Server and features that will not be supported in a future version of SQL Server.

 
    Old                           SQL 2005
    ------------------------      -----------------------------------------------------------
    sp_attach_db                  CREATE DATABASE statement with the FOR ATTACH option; 
                                  to rebuild multiple log files, when one or more have a new 
                                  location, use the FOR ATTACH_REBUILD_LOG option

    sp_renamedb                   MODIFY NAME option of ALTER DATABASE
                                  
    xp_addextendedproc            None. Use CLR instead
    xp_dropextendedproc
    xp_helpextendedproc
     
    dbcc dbreindex                REBUILD option of ALTER INDEX
    dbcc indexdefrag              REORGANIZE option of ALTER INDEX

    dbcc showcontig               sys.dm_db_index_physical_stats  (dynamic management view)

    syscacheobjects               sys.dm_exec_cached_plans        (dynamic management view)
                                  sys.dm_exec_plan_attributes     (dynamic management view)
                                  sys.dm_exec_sql_text            (dynamic management view)
                                  
    sysprocesses                  sys.dm_exec_connections         (dynamic management view)
                                  sys.dm_exec_sessions            (dynamic management view)
                                  sys.dm_exec_requests            (dynamic management view)
                                  
    syslockinfo                   sys.dm_tran_locks               (dynamic management view)
    sp_lock          

    sysdatabases                  sys.databases               (catalog view)
    syslogins                     sys.server_principals       (catalog view)
    sysobjects                    sys.objects                 (catalog view)

    sysindexes                    sys.indexes                 (catalog view)
                                  sys.partitions              (catalog view)
                                  sys.allocation_units        (catalog view)
                                  sys.dm_db_partition_stats   (dynamic management view)

    setuser                       EXECUTE AS
    fn_get_sql                    sys.dm_exec_sql_text

FEATURES DISCONTINUED SQL SERVER 2005

    Old                           SQL 2005
    -------------------------     -----------------------------------------------------------
    isql utility                  sqlcmd
    osql                          Supported, but depreciated  

    'allow updates' option        Option is present but direct updates to system tables are 
    of sp_configure.              not supported

    DBCC PINTABLE,                None
    DBCC UNPINTABLE               

    syslocks                      sys.dm_tran_locks

    *= and =* outer join          Use the JOIN syntax of the FROM clause

    Multiple table hints          Must be specified in paranthesis using the WITH keyword 

                                  Correct:  
                                  SELECT * FROM employee WITH (NOLOCK, INDEX(IX_Key))

                                  Single hints still work without WITH keyword
                                  SELECT * FROM employee (NOLOCK)

    Rebuildm.exe                  Use the REBUILDDATABASE option in Setup.exe                               

See also

THIS POST IS PROVIDED "AS-IS" WITH NO WARRANTIES AND CONFERS NO RIGHTS. Build time: Sun 03/30/2008 . ©2007 Dalun Software. All rights reserved. Back to Article List