1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22
| SELECT dtb.name AS [Name] FROM master.dbo.sysdatabases AS dtb ORDER BY [Name] ASC
2011-01-25 09:46:05.293 81468 SELECT TOP 100 PersP.Nom,PersP.Prenom,S.DateDerniereVisiteMedicale,S.SurveillanceMedicale FROM dbo.SALARIE as S,dbo.PERSONNE_PHYSIQUE PersP WHERE S.Id=PersP.Id AND S.Id IN (SELECT DISTINCT(SAL.Id) FROM dbo.SALARIE as SAL, dbo.PERSONNE P,dbo.CONTRAT_TRAVAIL CT WHERE SAL.SurveillanceMedicale IS NOT NULL AND P.Utilisation = 1 AND SAL.GererRappelVisiteMedicale = 1 AND SAL.Id=P.Id AND SAL.Id=CT.Salarie AND (CT.DateFin IS NULL OR CONVERT(CHAR(10),CT.DateFin,121)>'2011-01-25') AND (SAL.DomaineGestion is null OR (SELECT COUNT(*) from dbo.R_DOMAINEGESTION_USERS WHERE UserId='DFDE0727-6ECA-468F-B6B7-9C3F011EFB36') =0 OR SAL.DomaineGestion IN (SELECT DomaineGestion FROM dbo.R_DOMAINEGESTION_USERS WHERE UserId='DFDE0727-6ECA-468F-B6B7-9C3F011EFB36'))) ORDER BY S.DateDerniereVisiteMedicale ASC, PersP.Nom ASC;
2011-01-25 09:46:04.500 327780 SELECT TOP 100 PersP.Nom, PersP.Prenom, S.DernierEntretienAnnuel FROM dbo.SALARIE as S,dbo.PERSONNE_PHYSIQUE PersP WHERE S.Id=PersP.Id AND S.Id IN (SELECT DISTINCT(SAL.Id) FROM dbo.SALARIE as SAL,dbo.PERSONNE P,dbo.CONTRAT_TRAVAIL CT WHERE (SAL.DernierEntretienAnnuel IS NULL OR CONVERT(CHAR(10),SAL.DernierEntretienAnnuel,121) <'2011-02-25') AND P.Utilisation = 1 AND SAL.Id=P.Id AND SAL.Id=CT.Salarie AND (CT.DateFin IS NULL OR CONVERT(CHAR(10),CT.DateFin,121)>'2011-01-25') AND (SAL.DomaineGestion is null OR (SELECT COUNT(*) from dbo.R_DOMAINEGESTION_USERS WHERE UserId='DFDE0727-6ECA-468F-B6B7-9C3F011EFB36') =0 OR SAL.DomaineGestion IN (SELECT DomaineGestion FROM dbo.R_DOMAINEGESTION_USERS WHERE UserId='DFDE0727-6ECA-468F-B6B7-9C3F011EFB36'))) ORDER BY S.DernierEntretienAnnuel ASC, PersP.Nom ASC;
2011-01-25 09:46:02.967 313 SELECT * FROM dbo.CODIFICATION T1, dbo.CODE_FONCTION T2 LEFT JOIN dbo.CODIFICATION_DADSU T3 ON T2.Id=T3.Id LEFT JOIN dbo.CODIFICATION_DDT T4 ON T2.Id=T4.Id WHERE T1.Id='588CCAB7-7551-4A01-B5B0-9CC500F34866' AND T1.Id=T2.Id;
2011-01-25 09:46:00.937 399480 SELECT T2.*,T1.* FROM dbo.HEURE_PLANIFIEE T1,dbo.HEURE T2 LEFT JOIN dbo.SALARIE T3 on T2.Salarie=T3.Id LEFT JOIN dbo.USAGER T4 on T2.Usager=T4.Id WHERE T1.Id=T2.Id AND ((CONVERT(CHAR(19),T1.DateFinAvecTrajet,121) >='2011-01-24 00:00:00' AND CONVERT(CHAR(19),T1.DateDebutAvecTrajet,121) <='2011-01-30 23:59:59' AND T1.RecurrenceInfo IS NULL ) OR (CONVERT(CHAR(10),T1.DateFinAvecTrajet,121) >='2011-01-24' AND CONVERT(CHAR(10),T1.DateDebutAvecTrajet,121) <='2011-01-30' AND T1.RecurrenceInfo IS NOT NULL )) AND T2.Salarie= '6DED75DA-1A4D-4695-80FD-99900133819F' AND ((T3.DomaineGestion IS NULL OR (SELECT COUNT(*) FROM dbo.R_DOMAINEGESTION_USERS WHERE UserId='74558278-87CB-46B2-B90A-9B1100E1CE62') = 0 OR T3.DomaineGestion IN (SELECT DomaineGestion FROM dbo.R_DOMAINEGESTION_USERS WHERE UserId='74558278-87CB-46B2-B90A-9B1100E1CE62')) OR (T4.DomaineGestion IS NULL OR (SELECT COUNT(*) FROM dbo.R_DOMAINEGESTION_USERS WHERE UserId='74558278-87CB-46B2-B90A-9B1100E1CE62') = 0 OR T4.DomaineGestion IN (SELECT DomaineGestion FROM dbo.R_DOMAINEGESTION_USERS WHERE UserId='74558278-87CB-46B2-B90A-9B1100E1CE62')));
2011-01-25 09:45:59.810 676 SELECT T1.* FROM dbo.ABSENCE T1, dbo.SALARIE T2 WHERE T1.Salarie=T2.Id AND CONVERT(CHAR(19),T1.DateFin,121) >='2011-01-24 00:00:00' AND CONVERT(CHAR(19),T1.DateDebut,121) <='2011-01-30 23:59:59' AND T1.Salarie= '6DED75DA-1A4D-4695-80FD-99900133819F' AND T1.AFFICHERDANSPLANNING=1 AND (T2.DomaineGestion IS NULL OR (SELECT COUNT(*) FROM dbo.R_DOMAINEGESTION_USERS WHERE UserId='74558278-87CB-46B2-B90A-9B1100E1CE62') = 0 OR T2.DomaineGestion IN (SELECT DomaineGestion FROM dbo.R_DOMAINEGESTION_USERS WHERE UserId='74558278-87CB-46B2-B90A-9B1100E1CE62')) ORDER BY T1.DateDebut DESC;
2011-01-25 09:45:55.530 198324 SELECT TOP 99999 T1.*,T2.*,T3.* FROM dbo.PERSONNE T1, dbo.PERSONNE_PHYSIQUE T2, dbo.SALARIE T3 WHERE T1.Id=T2.Id and T2.Id=T3.Id AND T1.Utilisation = 1 AND (T3.DomaineGestion IS NULL OR (SELECT COUNT(*) FROM dbo.R_DOMAINEGESTION_USERS WHERE UserId='74558278-87CB-46B2-B90A-9B1100E1CE62' ) = 0 OR T3.DomaineGestion IN (SELECT DomaineGestion FROM dbo.R_DOMAINEGESTION_USERS WHERE UserId='74558278-87CB-46B2-B90A-9B1100E1CE62')) AND ( (UPPER(T2.Nom) LIKE UPPER('lamy%') OR UPPER(T2.Prenom) LIKE UPPER('lamy%') OR UPPER(T2.NomJeuneFille) LIKE UPPER('lamy%') OR T2.NumeroRegimeGeneral = 'lamy' OR CAST(T3.Matricule as NVARCHAR(6)) = 'lamy' OR T1.AP_Telephone = 'lamy' OR T2.TelephoneMobile = 'lamy' OR T1.AP_Fax = 'lamy')) ORDER BY T2.Nom , T2.Prenom ;
2011-01-25 09:45:43.873 72570
SELECT TOP 100 PersP.Nom,PersP.Prenom,S.DateDerniereVisiteMedicale,S.SurveillanceMedicale FROM dbo.SALARIE as S,dbo.PERSONNE_PHYSIQUE PersP WHERE S.Id=PersP.Id AND S.Id IN (SELECT DISTINCT(SAL.Id) FROM dbo.SALARIE as SAL, dbo.PERSONNE P,dbo.CONTRAT_TRAVAIL CT WHERE SAL.SurveillanceMedicale IS NOT NULL AND P.Utilisation = 1 AND SAL.GererRappelVisiteMedicale = 1 AND SAL.Id=P.Id AND SAL.Id=CT.Salarie AND (CT.DateFin IS NULL OR CONVERT(CHAR(10),CT.DateFin,121)>'2011-01-25') AND (SAL.DomaineGestion is null OR (SELECT COUNT(*) from dbo.R_DOMAINEGESTION_USERS WHERE UserId='2222ABED-A948-4913-9A24-99AF01170F80') =0 OR SAL.DomaineGestion IN (SELECT DomaineGestion FROM dbo.R_DOMAINEGESTION_USERS WHERE UserId='2222ABED-A948-4913-9A24-99AF01170F80'))) ORDER BY S.DateDerniereVisiteMedicale ASC, PersP.Nom ASC;
2011-01-25 09:45:42.750 72048 SELECT TOP 100 PersP.Nom,PersP.Prenom,S.DateDerniereVisiteMedicale,S.SurveillanceMedicale FROM dbo.SALARIE as S,dbo.PERSONNE_PHYSIQUE PersP WHERE S.Id=PersP.Id AND S.Id IN (SELECT DISTINCT(SAL.Id) FROM dbo.SALARIE as SAL, dbo.PERSONNE P,dbo.CONTRAT_TRAVAIL CT WHERE SAL.SurveillanceMedicale IS NOT NULL AND P.Utilisation = 1 AND SAL.GererRappelVisiteMedicale = 1 AND SAL.Id=P.Id AND SAL.Id=CT.Salarie AND (CT.DateFin IS NULL OR CONVERT(CHAR(10),CT.DateFin,121)>'2011-01-25') AND (SAL.DomaineGestion is null OR (SELECT COUNT(*) from dbo.R_DOMAINEGESTION_USERS WHERE UserId='74558278-87CB-46B2-B90A-9B1100E1CE62') =0 OR SAL.DomaineGestion IN (SELECT DomaineGestion FROM dbo.R_DOMAINEGESTION_USERS WHERE UserId='74558278-87CB-46B2-B90A-9B1100E1CE62'))) ORDER BY S.DateDerniereVisiteMedicale ASC, PersP.Nom ASC;
2011-01-25 09:45:42.733 172660 SELECT TOP 100 PersP.Nom, PersP.Prenom, S.DernierEntretienAnnuel FROM dbo.SALARIE as S,dbo.PERSONNE_PHYSIQUE PersP WHERE S.Id=PersP.Id AND S.Id IN (SELECT DISTINCT(SAL.Id) FROM dbo.SALARIE as SAL,dbo.PERSONNE P,dbo.CONTRAT_TRAVAIL CT WHERE (SAL.DernierEntretienAnnuel IS NULL OR CONVERT(CHAR(10),SAL.DernierEntretienAnnuel,121) <'2011-02-25') AND P.Utilisation = 1 AND SAL.Id=P.Id AND SAL.Id=CT.Salarie AND (CT.DateFin IS NULL OR CONVERT(CHAR(10),CT.DateFin,121)>'2011-01-25') AND (SAL.DomaineGestion is null OR (SELECT COUNT(*) from dbo.R_DOMAINEGESTION_USERS WHERE UserId='2222ABED-A948-4913-9A24-99AF01170F80') =0 OR SAL.DomaineGestion IN (SELECT DomaineGestion FROM dbo.R_DOMAINEGESTION_USERS WHERE UserId='2222ABED-A948-4913-9A24-99AF01170F80'))) ORDER BY S.DernierEntretienAnnuel ASC, PersP.Nom ASC;
2011-01-25 09:45:42.187 209933 SELECT TOP 100 PersP.Nom, PersP.Prenom, S.DernierEntretienAnnuel FROM dbo.SALARIE as S,dbo.PERSONNE_PHYSIQUE PersP WHERE S.Id=PersP.Id AND S.Id IN (SELECT DISTINCT(SAL.Id) FROM dbo.SALARIE as SAL,dbo.PERSONNE P,dbo.CONTRAT_TRAVAIL CT WHERE (SAL.DernierEntretienAnnuel IS NULL OR CONVERT(CHAR(10),SAL.DernierEntretienAnnuel,121) <'2011-02-25') AND P.Utilisation = 1 AND SAL.Id=P.Id AND SAL.Id=CT.Salarie AND (CT.DateFin IS NULL OR CONVERT(CHAR(10),CT.DateFin,121)>'2011-01-25') AND (SAL.DomaineGestion is null OR (SELECT COUNT(*) from dbo.R_DOMAINEGESTION_USERS WHERE UserId='74558278-87CB-46B2-B90A-9B1100E1CE62') =0 OR SAL.DomaineGestion IN (SELECT DomaineGestion FROM dbo.R_DOMAINEGESTION_USERS WHERE UserId='74558278-87CB-46B2-B90A-9B1100E1CE62'))) ORDER BY S.DernierEntretienAnnuel ASC, PersP.Nom ASC;
2011-01-25 09:44:23.483 2737 SELECT TOP 20 wait_type AS [Type Attente] -- Nom du type d'attente ,wait_time_ms / 1000 AS [Temps Attente Total (s)] -- Temps d'attente (en seconde) ,waiting_tasks_count AS [Nombre d'attente] -- Nombre d'attentes sur ce type d'attente. Ce compteur est incrémenté au début de chaque attente ,CONVERT(DECIMAL(12,2), wait_time_ms * 100.0 / SUM(wait_time_ms) OVER()) AS [% Temps Attente] FROM sys.dm_os_wait_stats ORDER BY [% Temps Attente] DESC;
2011-01-25 09:44:16.700 173 SELECT CONVERT([bit],has_dbaccess([dtb].[name]),0) [IsAccessible] FROM [master].[sys].[databases] [dtb] WHERE [dtb].[name]=@1
2011-01-25 09:44:14.920 548 SELECT dtb.name AS [Database_Name], 'Server[@Name=' + quotename(CAST(serverproperty(N'Servername') AS sysname),'''') + ']' + '/Database[@Name=' + quotename(dtb.name,'''') + ']' AS [Database_Urn], case when DATABASEPROPERTY(dtb.name,'IsShutDown') is null then 0x200 else 0 end | case when 1 = dtb.is_in_standby then 0x40 else 0 end | case when 1 = dtb.is_cleanly_shutdown then 0x80 else 0 end | case dtb.state when 1 then 0x2 when 2 then 0x8 when 3 then 0x4 when 4 then 0x10 when 5 then 0x100 when 6 then 0x20 else 1 end AS [Database_Status], dtb.compatibility_level AS [Database_CompatibilityLevel], dmi.mirroring_role AS [Database_MirroringRole], coalesce(dmi.mirroring_state + 1, 0) AS [Database_MirroringStatus], dtb.recovery_model AS [RecoveryModel], dtb.user_access AS [UserAccess], dtb.is_read_only AS [ReadOnly], dtb.name AS [Database_DatabaseName2] FROM master.sys.databases AS dtb LEFT OUTER JOIN sys.database_mirroring AS dmi ON dmi.database_id = dtb.database_id WHERE (CAST(case when dtb.name in ('master','model','msdb','tempdb') then 1 else dtb.is_distributor end AS bit)=0 and CAST(isnull(dtb.source_database_id, 0) AS bit)=0) ORDER BY [Database_Name] ASC
2011-01-25 09:43:50.857 215 SELECT CAST(serverproperty(N'Servername') AS sysname) AS [Name], ISNULL(tsgsp.msx_server_name,N'') AS [MsxServerName], tsgsp.sqlagent_type AS [JobServerType], CAST(tsgsp.sqlserver_restart AS bit) AS [SqlServerRestart], CAST(tsgsp.monitor_autostart AS bit) AS [SqlAgentRestart], tsgsp.jobhistory_max_rows AS [MaximumHistoryRows], tsgsp.jobhistory_max_rows_per_job AS [MaximumJobHistoryRows], tsgsp.errorlog_file AS [ErrorLogFile], tsgsp.errorlogging_level AS [AgentLogLevel], ISNULL(tsgsp.error_recipient,N'') AS [NetSendRecipient], tsgsp.job_shutdown_timeout AS [AgentShutdownWaitTime], ISNULL(tsgsp.email_profile,N'') AS [SqlAgentMailProfile], CAST(tsgsp.email_save_in_sent_folder AS bit) AS [SaveInSentFolder], CAST(tsgsp.oem_errorlog AS bit) AS [WriteOemErrorLog], CAST(tsgsp.cpu_poller_enabled AS bit) AS [IsCpuPollingEnabled], tsgsp.idle_cpu_percent AS [IdleCpuPercentage], tsgsp.idle_cpu_duration AS [IdleCpuDuration], tsgsp.login_timeout AS [LoginTimeout], ISNULL(tsgsp.host_login_name,N'') AS [HostLoginName], ISNULL(tsgsp.local_host_server,N'') AS [LocalHostAlias], CAST(tsgsp.auto_start AS bit) AS [SqlAgentAutoStart], CAST(tsgsp.replace_alert_tokens_enabled AS bit) AS [ReplaceAlertTokensEnabled], ISNULL(@DatabaseMailProfile,N'') AS [DatabaseMailProfile], ISNULL(@AgentMailType, 0) AS [AgentMailType], CAST(1 AS bit) AS [SysAdminOnly] FROM #tmp_sp_get_sqlagent_properties AS tsgsp
2011-01-25 09:43:50.793 265 SELECT auto_start = CASE @auto_start WHEN 2 THEN 1 -- 2 means auto-start WHEN 3 THEN 0 -- 3 means don't auto-start ELSE 0 -- Safety net END, msx_server_name = @msx_server_name, sqlagent_type = (SELECT CASE WHEN (COUNT(*) = 0) AND (ISNULL(DATALENGTH(@msx_server_name), 0) = 0) THEN 1 -- Standalone WHEN (COUNT(*) = 0) AND (ISNULL(DATALENGTH(@msx_server_name), 0) > 0) THEN 2 -- TSX WHEN (COUNT(*) > 0) AND (ISNULL(DATALENGTH(@msx_server_name), 0) = 0) THEN 3 -- MSX WHEN (COUNT(*) > 0) AND (ISNULL(DATALENGTH(@msx_server_name), 0) > 0) THEN 0 -- Multi-Level MSX (currently invalid) ELSE 0 -- Invalid END FROM msdb.dbo.systargetservers), startup_account = @startup_account, -- Non-SQLDMO exposed properties sqlserver_restart = ISNULL(@sqlserver_restart, 1), jobhistory_max_rows = @jobhistory_max_rows, jobhistory_max_rows_per_job = @jobhistory_max_rows_per_job, errorlog_file = @errorlog_file, errorlogging_level = ISNULL(@errorlogging_level, 7), error_recipient = @error_recipient, monitor_autostart = ISNULL(@monitor_autostart, 0), local_host_server = @local_host_server, job_shutdown_timeout = ISNULL(@job_shutdown_timeout, 15), cmdexec_account = @cmdexec_account, regular_connections = ISNULL(@regular_connections, 0), host_login_name = @host_login_name, host_login_password = @host_login_password, login_timeout = ISNULL(@login_timeout, 30), idle_cpu_percent = ISNULL(@idle_cpu_percent, 10), idle_cpu_duration = ISNULL(@idle_cpu_duration, 600), oem_errorlog = ISNULL(@oem_errorlog, 0), sysadmin_only = NULL, email_profile = @email_profile, email_save_in_sent_folder = ISNULL(@email_save_in_sent_folder, 0), cpu_poller_enabled = ISNULL(@cpu_poller_enabled, 0), alert_replace_runtime_tokens = ISNULL(@alert_replace_runtime_tokens, 0)
2011-01-25 09:43:50.700 34677 insert into #tmp_sp_get_sqlagent_properties(auto_start, msx_server_name, sqlagent_type, startup_account, sqlserver_restart, jobhistory_max_rows, jobhistory_max_rows_per_job, errorlog_file, errorlogging_level, error_recipient, monitor_autostart, local_host_server, job_shutdown_timeout, cmdexec_account, regular_connections, host_login_name, host_login_password, login_timeout, idle_cpu_percent, idle_cpu_duration, oem_errorlog, sysadmin_only, email_profile, email_save_in_sent_folder, cpu_poller_enabled, replace_alert_tokens_enabled) exec msdb.dbo.sp_get_sqlagent_properties
2011-01-25 09:43:50.623 180 SELECT dtb.collation_name AS [Collation], dtb.name AS [DatabaseName2] FROM master.sys.databases AS dtb WHERE (dtb.name=N'msdb')
2011-01-25 09:43:50.607 139 SELECT [dtb].[name] [Name] FROM [master].[sys].[databases] [dtb] WHERE [dtb].[name]=@1
2011-01-25 09:43:50.543 14628 SELECT CAST(COLLATIONPROPERTY(name, 'LCID') AS int) AS [LocaleID] FROM sys.fn_helpcollations() cl WHERE (cl.name=N'French_CI_AS') |
Partager