Wednesday, February 26, 2014

Support Ends for the list of MS SQL products

http://support.microsoft.com/lifecycle/search/?sort=PN&alpha=sql

Products ReleasedLifecycle Start DateMainstream Support End DateExtended Support End DateService Pack Support End DateNotes
SQL Server 2000 64-bit Edition11/30/20004/8/20084/9/20137/11/2002
SQL Server 2000 Desktop Engine11/30/20004/8/20084/9/2013
SQL Server 2000 Desktop Engine Release A1/29/20034/8/20084/9/2013
SQL Server 2000 Developer Edition11/30/20004/8/20084/9/20137/11/2002
SQL Server 2000 Enterprise Edition11/30/20004/8/20084/9/20137/11/2002
SQL Server 2000 Reporting Services Service Pack 19/22/2004Not ApplicableNot Applicable7/11/2006
SQL Server 2000 Reporting Services Service Pack 24/22/2005Review NoteReview NoteSupport 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 16/12/2001Not ApplicableNot Applicable2/28/2002
SQL Server 2000 Service Pack 211/30/2001Not ApplicableNot Applicable4/7/2003
SQL Server 2000 Service Pack 3a1/7/2003Not ApplicableNot Applicable7/10/2007
SQL Server 2000 Service Pack 45/6/2005Review NoteReview NoteSupport 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 Edition11/30/20004/8/20084/9/20137/11/2002
SQL Server 2000 Windows CE Edition 2.012/16/20021/8/20081/8/2013
SQL Server 2000 Workgroup Edition6/1/20054/8/20084/9/2013
SQL Server 2005 Compact Edition2/19/20074/12/20114/12/20167/10/2007
SQL Server 2005 Developer Edition1/14/20064/12/20114/12/20167/10/2007
SQL Server 2005 Enterprise Edition1/14/20064/12/20114/12/20167/10/2007
SQL Server 2005 Enterprise Edition for Itanium-based Systems1/14/20064/12/20114/12/20167/10/2007
SQL Server 2005 Enterprise X64 Edition1/14/20064/12/20114/12/20167/10/2007
SQL Server 2005 Express Edition6/1/20064/12/20114/12/20167/10/2007
SQL Server 2005 Express Edition with Advanced Services7/16/20064/12/20114/12/20167/10/2007
SQL Server 2005 Service Pack 14/18/2006Not ApplicableNot Applicable4/8/2008
SQL Server 2005 Service Pack 22/19/2007Not ApplicableNot Applicable1/12/2010
SQL Server 2005 Service Pack 312/15/2008Not ApplicableNot Applicable1/10/2012
SQL Server 2005 Service Pack 412/13/2010Review NoteReview NoteSupport 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 Edition1/14/20064/12/20114/12/20167/10/2007
SQL Server 2005 Standard Edition for Itanium-based Systems1/14/20064/12/20114/12/20167/10/2007
SQL Server 2005 Standard X64 Edition1/14/20064/12/20114/12/20167/10/2007
SQL Server 2005 Workgroup Edition1/14/20064/12/20114/12/20167/10/2007
SQL Server 2008 Developer11/6/20087/8/20147/9/20194/13/2010
SQL Server 2008 Enterprise11/7/20087/8/20147/9/20194/13/2010
SQL Server 2008 Express11/11/20087/8/20147/9/20194/13/2010
SQL Server 2008 Express with Advanced Services11/22/20087/8/20147/9/20194/13/2010
SQL Server 2008 R2 Datacenter7/20/20107/8/20147/9/20197/10/2012
SQL Server 2008 R2 Developer7/20/20107/8/20147/9/20197/10/2012
SQL Server 2008 R2 Enterprise7/20/20107/8/20147/9/20197/10/2012
SQL Server 2008 R2 Express7/20/20107/8/20147/9/20197/10/2012
SQL Server 2008 R2 Express with Advanced Services7/20/20107/8/20147/9/20197/10/2012
SQL Server 2008 R2 Parallel Data Warehouse11/9/20107/8/20147/9/2019Hardware 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 17/12/2011Not ApplicableNot Applicable10/8/2013
SQL Server 2008 R2 Service Pack 27/26/2012Review NoteReview NoteSupport 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 Standard7/20/20107/8/20147/9/20197/10/2012
SQL Server 2008 R2 Standard Edition for Small Business7/20/20107/8/20147/9/20197/10/2012
SQL Server 2008 R2 Web7/20/20107/8/20147/9/20197/10/2012
SQL Server 2008 R2 Workgroup7/20/20107/8/20147/9/20197/10/2012
SQL Server 2008 Service Pack 13/31/2009Not ApplicableNot Applicable10/11/2011
SQL Server 2008 Service Pack 29/24/2010Not ApplicableNot Applicable10/9/2012
SQL Server 2008 Service Pack 310/6/2011Review NoteReview NoteSupport 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 Standard11/6/20087/8/20147/9/20194/13/2010
SQL Server 2008 Standard Edition for Small Business11/6/20087/8/20147/9/20194/13/2010
SQL Server 2008 Web11/6/20087/8/20147/9/20194/13/2010
SQL Server 2008 Workgroup11/6/20087/8/20147/9/20194/13/2010
SQL Server 2012 Business Intelligence5/20/20127/11/20177/12/20221/14/2014
SQL Server 2012 Developer5/20/20127/11/20177/12/20221/14/2014
SQL Server 2012 Enterprise5/20/20127/11/20177/12/20221/14/2014
SQL Server 2012 Enterprise Core5/20/20127/11/20177/12/2022
SQL Server 2012 Express5/20/20127/11/20177/12/20221/14/2014
SQL Server 2012 Parallel Data Warehouse7/12/201310/9/2018Review NoteSQL 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 111/7/2012Review NoteReview NoteSupport 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 Standard5/20/20127/11/20177/12/20221/14/2014
SQL Server 2012 Web5/20/20127/11/20177/12/20221/14/2014
SQL Server 4.2 for OS/2Not Available7/1/1999Not Applicable
SQL Server 6.0 Standard EditionNot Available3/31/1999Not Applicable
SQL Server 6.5 Enterprise Edition3/1/19983/31/2004Not Applicable
SQL Server 6.5 Service Pack 112/31/1998Not ApplicableNot Applicable1/1/2002
SQL Server 6.5 Service Pack 29/15/2000Not ApplicableNot Applicable
SQL Server 6.5 Service Pack 31/15/2000Not ApplicableNot Applicable
SQL Server 6.5 Service Pack 4Not AvailableNot ApplicableNot Applicable3/24/1999
SQL Server 6.5 Service Pack 5a12/24/1998Not ApplicableNot Applicable3/31/2004
SQL Server 6.5 Standard Edition6/30/19961/1/2002Not Applicable
SQL Server 7.0 Enterprise Edition3/1/199912/31/20051/11/2011
SQL Server 7.0 Service Pack 15/25/1999Not ApplicableNot Applicable3/31/2004
SQL Server 7.0 Service Pack 23/20/2000Not ApplicableNot Applicable
SQL Server 7.0 Service Pack 3Not AvailableNot ApplicableNot Applicable7/26/2002
SQL Server 7.0 Service Pack 44/26/2002Review NoteReview NoteSupport 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 Edition3/1/199912/31/20051/11/2011
SQL Server Compact 3.52/19/20084/9/20134/10/201810/13/2009
SQL Server Compact 3.5 Service Pack 1 for Windows Mobile8/11/2008Not ApplicableNot Applicable7/12/2011
SQL Server Compact 3.5 Service Pack 26/29/2010Review NoteReview NoteSupport 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.04/13/20117/12/20167/13/2021
SQL Server Notification Services 2.0 Enterprise Edition11/26/20021/8/20081/8/2013
SQL Server Notification Services 2.0 Standard Edition11/26/20021/8/20081/8/2013

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

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