Many times we use “Execute Package Task” to execute a child package from a parent/wrapper package and we use “Parent Package Variables” as means of configuration for child package. Do you know that we have to keep “ExecuteOutOfProcess” to “False” in order to use parent variables in child package? If we set “ExecuteOutOfProcess” to “True” than parent variables are not visible in child package and configured child’s vari...
Read More
This is documented in Microsoft KB article 958004. When you restore a database from 2000 version of SQL Server to ver 2005 (specific builds being SQL Server 2005 build 2191 or later builds of SQL Server 2005 Service Pack 1, SQL Server 2005 Service Pack 2 or later builds), you find inconsistent file growth settings. Read more on this here: http://support.microsoft.com/kb/958004 @SQLServerGeeks
Many of you know that SQL Server 2008 R2 can be installed side-by-side with SQL Server 2008. SQL Server 2008 R2 is a minor release. Since both the versions share the same major version, R2 installation will automatically upgrade the shared components between the two versions. In case you are planning to install R2 along with 2008, you should check out this link: http://msdn.microsoft.com/en-us/library/ee210714.aspx
Want to try out Denali (SQL Server 2012) without installing it? A HyperV image of SQL Server Denali CTP3 in action, including fully configured services and integration with SharePoint 2010 and Office 2010 is available at http://www.microsoft.com/download/en/details.aspx?id=27740 The following software is configured on the virtual machine: SQL Server "Denali" CTP3 SharePoint 2010 Office 2010 Enjoy ! @SQLServerGeeks http://www.FaceBook.com/SQLServerGeeks
The default instance, by default, listens on port 1433. SQL Server can listen on multiple ports on the same IP address. For this you can list the ports separated by commas. For example: 1433,1533,1633. (Note: There is a limitation of 2047 characters.) You can do this from Configuration Manager. To configure SQL Server to listen on multiple ports, the Listen All parameter must also be set to No, on the Protocols Tab of the TCP/IP Properties dialog box.
Did you know that apart from system catalogs, you can also use System Functions like DATABASEPROPERTYEX to extract metadata about a database. For example to find out whether AutoShrink is ON or OFF, you can use the function this way: SELECT DATABASEPROPERTYEX ('AdventureWorks','IsAutoShrink') The function takes in the name of the database and the property name: another example; to find out the status of the database, you can use the function this way: SELECT DATABASEPROPERTYEX ('AdventureWorks',...