Welcome to Sign in | Help

Re: cum pot afla daca sql server agent ruleaza ?

  •  05-14-2008, 7:14 PM

    Re: cum pot afla daca sql server agent ruleaza ?

    Daca lucrezi cu SQL 2000, atunci e OK sfatul lui Bogdan.

    Pe 2005, poti folosi un "compatibility view" - sys.sysprocesses. Dar, dupa cum spune BOL:

    "This SQL Server 2000 system table is included as a view for backward compatibility. We recommend that you use the current SQL Server system views instead" - in cazul tau sys.dm_exec_sessions.

    Gasesti "corespondenta" intre "system tables" si aceste "views" in BOL ---> Mapping SQL Server 2000 System Tables to SQL Server 2005 System Views.

     

View Complete Thread
Powered by Community Server (Commercial Edition), by Telligent Systems