I installed SQL Server 2012 RC0 today. Then I tried to install the sample database, using the following code:
CREATE DATABASE AdventureWorks2008R2
ON (FILENAME = 'C:\AdventureWorks2008R2_Data.mdf')
FOR ATTACH_REBUILD_LOG ;
I got the access deny error. Then I changed it to the D drive. It worked. Someone says that this is because of the compressed volume issue. But both C and D are not compressed. Why???
SQL Server Administration, Development and B.I. Development related
An SSIS Problem - Package Processing hangs on forever, no error but keep processing
Problem:
Package Processing hangs on forever, no error but keep processing
Reason:
Because insert, updates, or deletes work on the same table, resulting in heap contention, the table locked for the first action, so the subsequent actions hang on forever. The SQL codes in different tasks in in the package are treated as in a batch.
Solution:
1. Change the "BulkInsertTabLock" property for the destination table to False as shown below, you may also need to increase the timeout for a large data flow as shown below.
2. Create a cluster index or PK on the destination table
Subscribe to:
Posts
(
Atom
)