Tuesday, October 27, 2009

Understanding "login failed" (Error 18456) error messages in SQL Server 2005


Tuesday, October 6, 2009

List of users in a Windows Global group


C:\>net group [GroupName] /domain

ex: NET GROUP DBAGroup /DOMAIN

SQL 2005 - Query to retrive SQL Agent Jobs scheduled time.

select j.name,sc.active_start_time,active_end_time,*
from sysjobs j
inner join dbo.sysjobschedules jsc
on j.job_id = jsc.job_id
inner join dbo.sysschedules sc
on jsc.schedule_id = sc.schedule_id
where j.name like '%ssis%'