| Products Released | Lifecycle Start Date | Mainstream Support End Date | Extended Support End Date | Service Pack Support End Date | Notes |
|---|---|---|---|---|---|
| SQL Server 2000 64-bit Edition | 11/30/2000 | 4/8/2008 | 4/9/2013 | 7/11/2002 | |
| SQL Server 2000 Desktop Engine | 11/30/2000 | 4/8/2008 | 4/9/2013 | ||
| SQL Server 2000 Desktop Engine Release A | 1/29/2003 | 4/8/2008 | 4/9/2013 | ||
| SQL Server 2000 Developer Edition | 11/30/2000 | 4/8/2008 | 4/9/2013 | 7/11/2002 | |
| SQL Server 2000 Enterprise Edition | 11/30/2000 | 4/8/2008 | 4/9/2013 | 7/11/2002 | |
| SQL Server 2000 Reporting Services Service Pack 1 | 9/22/2004 | Not Applicable | Not Applicable | 7/11/2006 | |
| SQL Server 2000 Reporting Services Service Pack 2 | 4/22/2005 | Review Note | Review Note | Support ends 12 months after the next service pack releases or at the end of the product's support lifecycle, whichever comes first. For more information, please see the service pack policy at http://support.microsoft.com/lifecycle/#ServicePackSupport. | |
| SQL Server 2000 Service Pack 1 | 6/12/2001 | Not Applicable | Not Applicable | 2/28/2002 | |
| SQL Server 2000 Service Pack 2 | 11/30/2001 | Not Applicable | Not Applicable | 4/7/2003 | |
| SQL Server 2000 Service Pack 3a | 1/7/2003 | Not Applicable | Not Applicable | 7/10/2007 | |
| SQL Server 2000 Service Pack 4 | 5/6/2005 | Review Note | Review Note | Support ends 12 months after the next service pack releases or at the end of the product's support lifecycle, whichever comes first. For more information, please see the service pack policy at http://support.microsoft.com/lifecycle/#ServicePackSupport. | |
| SQL Server 2000 Standard Edition | 11/30/2000 | 4/8/2008 | 4/9/2013 | 7/11/2002 | |
| SQL Server 2000 Windows CE Edition 2.0 | 12/16/2002 | 1/8/2008 | 1/8/2013 | ||
| SQL Server 2000 Workgroup Edition | 6/1/2005 | 4/8/2008 | 4/9/2013 | ||
| SQL Server 2005 Compact Edition | 2/19/2007 | 4/12/2011 | 4/12/2016 | 7/10/2007 | |
| SQL Server 2005 Developer Edition | 1/14/2006 | 4/12/2011 | 4/12/2016 | 7/10/2007 | |
| SQL Server 2005 Enterprise Edition | 1/14/2006 | 4/12/2011 | 4/12/2016 | 7/10/2007 | |
| SQL Server 2005 Enterprise Edition for Itanium-based Systems | 1/14/2006 | 4/12/2011 | 4/12/2016 | 7/10/2007 | |
| SQL Server 2005 Enterprise X64 Edition | 1/14/2006 | 4/12/2011 | 4/12/2016 | 7/10/2007 | |
| SQL Server 2005 Express Edition | 6/1/2006 | 4/12/2011 | 4/12/2016 | 7/10/2007 | |
| SQL Server 2005 Express Edition with Advanced Services | 7/16/2006 | 4/12/2011 | 4/12/2016 | 7/10/2007 | |
| SQL Server 2005 Service Pack 1 | 4/18/2006 | Not Applicable | Not Applicable | 4/8/2008 | |
| SQL Server 2005 Service Pack 2 | 2/19/2007 | Not Applicable | Not Applicable | 1/12/2010 | |
| SQL Server 2005 Service Pack 3 | 12/15/2008 | Not Applicable | Not Applicable | 1/10/2012 | |
| SQL Server 2005 Service Pack 4 | 12/13/2010 | Review Note | Review Note | Support ends 12 months after the next service pack releases or at the end of the product's support lifecycle, whichever comes first. For more information, please see the service pack policy at http://support.microsoft.com/lifecycle/#ServicePackSupport. | |
| SQL Server 2005 Standard Edition | 1/14/2006 | 4/12/2011 | 4/12/2016 | 7/10/2007 | |
| SQL Server 2005 Standard Edition for Itanium-based Systems | 1/14/2006 | 4/12/2011 | 4/12/2016 | 7/10/2007 | |
| SQL Server 2005 Standard X64 Edition | 1/14/2006 | 4/12/2011 | 4/12/2016 | 7/10/2007 | |
| SQL Server 2005 Workgroup Edition | 1/14/2006 | 4/12/2011 | 4/12/2016 | 7/10/2007 | |
| SQL Server 2008 Developer | 11/6/2008 | 7/8/2014 | 7/9/2019 | 4/13/2010 | |
| SQL Server 2008 Enterprise | 11/7/2008 | 7/8/2014 | 7/9/2019 | 4/13/2010 | |
| SQL Server 2008 Express | 11/11/2008 | 7/8/2014 | 7/9/2019 | 4/13/2010 | |
| SQL Server 2008 Express with Advanced Services | 11/22/2008 | 7/8/2014 | 7/9/2019 | 4/13/2010 | |
| SQL Server 2008 R2 Datacenter | 7/20/2010 | 7/8/2014 | 7/9/2019 | 7/10/2012 | |
| SQL Server 2008 R2 Developer | 7/20/2010 | 7/8/2014 | 7/9/2019 | 7/10/2012 | |
| SQL Server 2008 R2 Enterprise | 7/20/2010 | 7/8/2014 | 7/9/2019 | 7/10/2012 | |
| SQL Server 2008 R2 Express | 7/20/2010 | 7/8/2014 | 7/9/2019 | 7/10/2012 | |
| SQL Server 2008 R2 Express with Advanced Services | 7/20/2010 | 7/8/2014 | 7/9/2019 | 7/10/2012 | |
| SQL Server 2008 R2 Parallel Data Warehouse | 11/9/2010 | 7/8/2014 | 7/9/2019 | Hardware products will receive 5 years of support following Microsoft’s end of sales date for the Major Product version. Minor Product releases follow the Support Lifecycle of their respective Major Product versions. | |
| SQL Server 2008 R2 Service Pack 1 | 7/12/2011 | Not Applicable | Not Applicable | 10/8/2013 | |
| SQL Server 2008 R2 Service Pack 2 | 7/26/2012 | Review Note | Review Note | Support ends 12 months after the next service pack releases or at the end of the product's support lifecycle, whichever comes first. For more information, please see the service pack policy at http://support.microsoft.com/lifecycle/#ServicePackSupport. | |
| SQL Server 2008 R2 Standard | 7/20/2010 | 7/8/2014 | 7/9/2019 | 7/10/2012 | |
| SQL Server 2008 R2 Standard Edition for Small Business | 7/20/2010 | 7/8/2014 | 7/9/2019 | 7/10/2012 | |
| SQL Server 2008 R2 Web | 7/20/2010 | 7/8/2014 | 7/9/2019 | 7/10/2012 | |
| SQL Server 2008 R2 Workgroup | 7/20/2010 | 7/8/2014 | 7/9/2019 | 7/10/2012 | |
| SQL Server 2008 Service Pack 1 | 3/31/2009 | Not Applicable | Not Applicable | 10/11/2011 | |
| SQL Server 2008 Service Pack 2 | 9/24/2010 | Not Applicable | Not Applicable | 10/9/2012 | |
| SQL Server 2008 Service Pack 3 | 10/6/2011 | Review Note | Review Note | Support ends 12 months after the next service pack releases or at the end of the product's support lifecycle, whichever comes first. For more information, please see the service pack policy at http://support.microsoft.com/lifecycle/#ServicePackSupport. | |
| SQL Server 2008 Standard | 11/6/2008 | 7/8/2014 | 7/9/2019 | 4/13/2010 | |
| SQL Server 2008 Standard Edition for Small Business | 11/6/2008 | 7/8/2014 | 7/9/2019 | 4/13/2010 | |
| SQL Server 2008 Web | 11/6/2008 | 7/8/2014 | 7/9/2019 | 4/13/2010 | |
| SQL Server 2008 Workgroup | 11/6/2008 | 7/8/2014 | 7/9/2019 | 4/13/2010 | |
| SQL Server 2012 Business Intelligence | 5/20/2012 | 7/11/2017 | 7/12/2022 | 1/14/2014 | |
| SQL Server 2012 Developer | 5/20/2012 | 7/11/2017 | 7/12/2022 | 1/14/2014 | |
| SQL Server 2012 Enterprise | 5/20/2012 | 7/11/2017 | 7/12/2022 | 1/14/2014 | |
| SQL Server 2012 Enterprise Core | 5/20/2012 | 7/11/2017 | 7/12/2022 | ||
| SQL Server 2012 Express | 5/20/2012 | 7/11/2017 | 7/12/2022 | 1/14/2014 | |
| SQL Server 2012 Parallel Data Warehouse | 7/12/2013 | 10/9/2018 | Review Note | SQL 2012 PDW appliance hardware and the server software configured and running on the appliance hardware shall receive five years of support from General Availability of SQL Server Parallel Data Warehouse 2012. | |
| SQL Server 2012 Service Pack 1 | 11/7/2012 | Review Note | Review Note | Support ends 12 months after the next service pack releases or at the end of the product's support lifecycle, whichever comes first. For more information, please see the service pack policy at http://support.microsoft.com/lifecycle/#ServicePackSupport. | |
| SQL Server 2012 Standard | 5/20/2012 | 7/11/2017 | 7/12/2022 | 1/14/2014 | |
| SQL Server 2012 Web | 5/20/2012 | 7/11/2017 | 7/12/2022 | 1/14/2014 | |
| SQL Server 4.2 for OS/2 | Not Available | 7/1/1999 | Not Applicable | ||
| SQL Server 6.0 Standard Edition | Not Available | 3/31/1999 | Not Applicable | ||
| SQL Server 6.5 Enterprise Edition | 3/1/1998 | 3/31/2004 | Not Applicable | ||
| SQL Server 6.5 Service Pack 1 | 12/31/1998 | Not Applicable | Not Applicable | 1/1/2002 | |
| SQL Server 6.5 Service Pack 2 | 9/15/2000 | Not Applicable | Not Applicable | ||
| SQL Server 6.5 Service Pack 3 | 1/15/2000 | Not Applicable | Not Applicable | ||
| SQL Server 6.5 Service Pack 4 | Not Available | Not Applicable | Not Applicable | 3/24/1999 | |
| SQL Server 6.5 Service Pack 5a | 12/24/1998 | Not Applicable | Not Applicable | 3/31/2004 | |
| SQL Server 6.5 Standard Edition | 6/30/1996 | 1/1/2002 | Not Applicable | ||
| SQL Server 7.0 Enterprise Edition | 3/1/1999 | 12/31/2005 | 1/11/2011 | ||
| SQL Server 7.0 Service Pack 1 | 5/25/1999 | Not Applicable | Not Applicable | 3/31/2004 | |
| SQL Server 7.0 Service Pack 2 | 3/20/2000 | Not Applicable | Not Applicable | ||
| SQL Server 7.0 Service Pack 3 | Not Available | Not Applicable | Not Applicable | 7/26/2002 | |
| SQL Server 7.0 Service Pack 4 | 4/26/2002 | Review Note | Review Note | Support ends 12 months after the next service pack releases or at the end of the product's support lifecycle, whichever comes first. For more information, please see the service pack policy at http://support.microsoft.com/lifecycle/#ServicePackSupport. | |
| SQL Server 7.0 Standard Edition | 3/1/1999 | 12/31/2005 | 1/11/2011 | ||
| SQL Server Compact 3.5 | 2/19/2008 | 4/9/2013 | 4/10/2018 | 10/13/2009 | |
| SQL Server Compact 3.5 Service Pack 1 for Windows Mobile | 8/11/2008 | Not Applicable | Not Applicable | 7/12/2011 | |
| SQL Server Compact 3.5 Service Pack 2 | 6/29/2010 | Review Note | Review Note | Support ends 12 months after the next service pack releases or at the end of the product's support lifecycle, whichever comes first. For more information, please see the service pack policy at http://support.microsoft.com/lifecycle/#ServicePackSupport. | |
| SQL Server Compact 4.0 | 4/13/2011 | 7/12/2016 | 7/13/2021 | ||
| SQL Server Notification Services 2.0 Enterprise Edition | 11/26/2002 | 1/8/2008 | 1/8/2013 | ||
| SQL Server Notification Services 2.0 Standard Edition | 11/26/2002 | 1/8/2008 | 1/8/2013 |
Wednesday, February 26, 2014
Support Ends for the list of MS SQL products
http://support.microsoft.com/lifecycle/search/?sort=PN&alpha=sql
Friday, April 12, 2013
details of FULL_LOG_Transactional_Differential Backups.
--Get Full Database Backups
SELECT database_name, backup_start_date, type, *
FROM msdb.dbo.backupset
WHERE backup_start_date BETWEEN DATEADD(hh, -24, GETDATE()) AND GETDATE()
AND Type = 'D'
ORDER BY backup_set_id DESC
GO
--Get Transaction Log Backups
SELECT database_name, backup_start_date, type, *
FROM msdb.dbo.backupset
WHERE backup_start_date BETWEEN DATEADD(hh, -24, GETDATE()) AND GETDATE()
AND Type = 'L'
ORDER BY backup_set_id DESC
GO
--Get Differential Backups details
SELECT database_name, backup_start_date, type, *
FROM msdb.dbo.backupset
WHERE backup_start_date BETWEEN DATEADD(hh, -24, GETDATE()) AND GETDATE()
AND Type = 'I'
ORDER BY backup_set_id DESC
GO
--File\File Group Backups
SELECT database_name, backup_start_date, type, *
FROM msdb.dbo.backupset
WHERE backup_start_date BETWEEN DATEADD(hh, -24, GETDATE()) AND GETDATE()
AND Type = 'F'
ORDER BY backup_set_id DESC
GO
node_cluster _details
SELECT SERVERPROPERTY('ServerName') as 'Server\Instance',
SERVERPROPERTY('ComputerNamePhysicalNetBIOS') as 'Node',
(select left(af.filename,3)from sys.sysaltfiles af where af.name like '%MSDB%' and af.fileid = 1) as 'Drive',
ec.local_net_address as 'IP Addr',
ec.local_tcp_port as 'SQL Port'
from sys.dm_exec_connections ec
where ec.session_id = @@SPID
SERVERPROPERTY('ComputerNamePhysicalNetBIOS') as 'Node',
(select left(af.filename,3)from sys.sysaltfiles af where af.name like '%MSDB%' and af.fileid = 1) as 'Drive',
ec.local_net_address as 'IP Addr',
ec.local_tcp_port as 'SQL Port'
from sys.dm_exec_connections ec
where ec.session_id = @@SPID
Tuesday, January 15, 2013
getting Serial Number thru cmd
to get the serial number of the laptop/machine
type in cmd
wmic bios get serialnumber
Tuesday, June 19, 2012
Grant rights to user
declare @sql nvarchar(4000)
declare @db sysname ; set @db = DB_NAME()
declare @u sysname ; set @u = QUOTENAME('
set @sql ='select ''grant exec on '' + QUOTENAME(ROUTINE_SCHEMA) + ''.'' +
QUOTENAME(ROUTINE_NAME) + '' TO ' + @u + ''' FROM INFORMATION_SCHEMA.ROUTINES ' +
'WHERE OBJECTPROPERTY(OBJECT_ID(ROUTINE_NAME),''IsMSShipped'') = 0'
exec master.dbo.xp_execresultset @sql,@db
Sunday, March 18, 2012
Wednesday, February 15, 2012
MS SQL downloads
Management Studio Download link..
http://www.microsoft.com/download/en/details.aspx?id=22985
MS SQL Express ..
http://www.microsoft.com/download/en/details.aspx?id=23650
Subscribe to:
Posts (Atom)
