Thursday, October 06, 2011

Apple's visionary and creative genius Steve Jobs






How can I deploy SQL 2008 SSRS Report in to SQL 2005 SSRS Server

Error:
The report definition is not valid. Details: The report definition has an invalid target namespace 'http://schemas.microsoft.com/sqlserver/reporting/2008/01/reportdefinition' which cannot be upgraded. (rsInvalidReportDefinition) Get Online Help


You can not deploy  sql server 2008 report (rdl) into sql server 2005 report  server because RDL namespace are different for each version.

Wednesday, October 05, 2011

End of Mainstream Support for SQL Server 2005 and End of Service Pack Support for SQL Server 2008 SP1

Mainstream Support for SQL Server 2005 Service Pack 3 and SQL Server 2005 Service Pack 4 will end on April 12, 2011, and Service Pack Support for SQL Server 2008 Service Pack 1 will end on October 11, 2011. 


Product
Version
SP
Mainstream Support End Date
Extended Support End Date
Options / Notes
SQL Server
7.0
SP4
12/31/2005
01/11/2011
Technical support ends as of 01/11/2011; options for technical and/or hotfix support after this date:
ð  Continue with self-help
ð   Upgrade to the latest supported service pack for SQL Server 2005 or SQL Server 2008 or SQL Server 2008 R2
ð  Custom support agreement
SQL Server
2000
SP4
04/08/2008
04/09/2013
Technical support continues till 04/09/2013, yet mainstream (hotfix) support ends as of 04/08/2008; options for hotfix support after 04/08/2008:
ð   Upgrade to the latest supported service pack for SQL Server 2005 or SQL Server 2008 or SQL Server 2008 R2
ð  Extended hotfix support agreement
SQL Server
2005
RTM (SP0)
07/10/2007
Not applicable
Technical support ends as of 07/10/2007; options for technical and/or hotfix support after this date:
ð  Continue with self-help
ð  Upgrade to the latest supported service pack for SQL Server 2005 or SQL Server 2008 or SQL Server 2008 R2
SQL Server
2005
SP1
04/08/2008
Not Applicable
Technical support ends as of 04/08/2008; options for technical and/or hotfix support after this date:
ð  Continue with self-help
ð  Upgrade to the latest supported service pack for SQL Server 2005 or SQL Server 2008 or SQL Server 2008 R2
SQL Server
2005
SP2
01/12/2010
Not Applicable
Technical support ends as of 01/12/2010; options for technical and/or hotfix support after this date:
ð  Continue with self-help
ð  Upgrade to the latest supported service pack for SQL Server 2005 or SQL Server 2008 or SQL Server 2008 R2
ð  Custom support agreement
SQL Server
2005
SP3
04/12/2011
01/10/2012
Technical support continues till 01/10/2012, yet mainstream (hotfix) support ends as of 04/12/2011; options for hotfix support after 04/12/2011:
ð  Continue with self-help
ð  Upgrade to the latest supported service pack for SQL Server 2005 or SQL Server 2008 or SQL Server 2008 R2
ð  Custom support agreement
SQL Server
2005
SP4
04/12/2011
04/12/2016
Technical support continues till 04/12/2016, yet mainstream (hotfix) support ends as of 04/12/2011; options for hotfix support after 04/12/2011:
ð  Continue with self-help
ð  Upgrade to the latest supported service pack for SQL Server 2005 or SQL Server 2008 or SQL Server 2008 R2
ð  Extended hotfix support agreement
SQL Server
2008
RTM
(SP0)
04/13/2010
Not Applicable
Technical support ends as of 04/13/2010; options for technical and/or hotfix support after this date:
ð  Continue with self-help
ð  Upgrade to the latest supported service pack for SQL Server 2008 or SQL Server 2008 R2
ð  Custom support agreement
SQL Server
2008
SP1
10/11/2011
Not Applicable
Technical support ends as of 10/11/2011; options for technical and/or hotfix support after this date:
ð  Continue with self-help
ð  Upgrade to the latest supported service pack for SQL Server 2008 or SQL Server 2008 R2
ð  Custom support agreement
SQL Server
2008
SP2
See Options/Notes

Support ends 12 months after the next service pack releases or at the end of the product's support lifecycle, whichever comes first. Visit the Lifecycle page to find the support timelines for your particular product.
SQL Server
2008 R2
RTM
(SP0)
See Options/Notes
Support ends 12 months after the next service pack releases or at the end of the product's support lifecycle, whichever comes first. Visit the Lifecycle page to find the support timelines for your particular product.


Tuesday, October 04, 2011

How to get the database property settings value

--DATABASEPROPERTYEX() Returns the current setting of the specified database option or property

SELECT DATABASEPROPERTYEX('AdventureWorks', 'Collation')
SELECT DATABASEPROPERTYEX('AdventureWorks', 'SQLSortOrder') --0 = Database is using Windows collation
SELECT DATABASEPROPERTYEX('AdventureWorks', 'IsAutoShrink')
SELECT DATABASEPROPERTYEX('AdventureWorks', 'IsAutoCreateStatistics')
SELECT DATABASEPROPERTYEX('AdventureWorks', 'IsAutoUpdateStatistics')
SELECT DATABASEPROPERTYEX('AdventureWorks', 'IsFulltextEnabled')
SELECT DATABASEPROPERTYEX('AdventureWorks', 'IsTornPageDetectionEnabled')
SELECT DATABASEPROPERTYEX('AdventureWorks', 'Recovery')
SELECT DATABASEPROPERTYEX('AdventureWorks', 'Status')
SELECT DATABASEPROPERTYEX('AdventureWorks', 'Version')
SELECT DATABASEPROPERTYEX('AdventureWorks', 'UserAccess')
SELECT DATABASEPROPERTYEX('AdventureWorks', 'IsPublished')
SELECT DATABASEPROPERTYEX('AdventureWorks', 'IsMergePublished')
SELECT DATABASEPROPERTYEX('AdventureWorks', 'IsSubscribed')

Monday, October 03, 2011

How to import packages using Integration Services

There are two different way to import ssis packages either command prompt or SSIS.
Here i am going show you , How to import ssis package via SSIS.

1. connect to SQL Server Integration Services
2. Expand Stored Packages
3. Expand the MSDB
4. Create Folder called My SSIS Packages
5. Import Packages
6. Package Location : File system
7. Package Path : C:\SSMS_Export_to_Excel.dtsx
8. Protection Leve : Rely on the server storage and role for access control

9. Package is imported now as you can see