Ramoji Ryali's Fundas
learn.microsoft.com/en-us/archive/blogs/ramoji
The interesting things I experimented with SQl Server.
- Posts
- 19 from 17 Sep 2008 to 6 Jan 2011
- Posting
- archived, read-only
- Kind
- personal blog
- Feed
- https://learn.microsoft.com/en-us/archive/blogs/ramoji/feed.xml
2011 1
2010 4
- Comparing data between two tables in SQL Server
- Message "TFS10139: The following check-in policies have not been satisfied" comes in VSTS2010
- Error while enabling CDC on a table. The server principal "xyz" is not able to access the database "msdb" under the current security context.
- SSIS Data Flow Task fails with Unspecified Error
2009 7
- SSIS package fails with Protocol error in TDS stream
- Could not update the metadata that indicates database is enabled for Change Data Capture. The failure occurred when executing the command SetCDCTracked(Value = 1)
- Explicit value must be specified for identity column in table [XXXXXX] either when IDENTITY_INSERT is set to ON or when a replication user is inserting into a NOT FOR REPLICATION identity column
- Failed to open package file due to error 0x80070020. The process cannot access the file because it is being used by another process. This happens when loading a package and the file cannot be opened or loaded correctly into the XML document.
- Checkin cannot proceed because the policy requirements have not been satisfied.
- Transfer permissions between objects in SQL Server 2008
- The AcquireConnection method call to the connection manager failed with error code 0xC0202009
2008 7
- General Network error. Check your network documentation.
- Package migration from version 3 to version 2 failed with error 0xC001700A. The version number in the package is not valid. The version number cannot be greater than current version number.
- How to open DTS packages in SQL Server 2008?
- Reading DTS and SSIS packages programmatically
- Moving indexes from one filegroup to another in SQL Server
- Creating new tables and loading data in SQL server by reading an Xml file
- How to get missing values from an Identity column?