Error Message:

(reason: The system cannot find the file specified). The step failed.

I changed the destination of the output file to a network h:\ drive instead of the c:\ and...

Great. You read my mind.

I started testing with a partition table with two schemes, one for data and other for indexes. I was able to switch, split and...

Thanks for the reply.

However, where ever I have researched, there seems to be only one partition mentioned in a switch statement, ALTER TABLE Orders

SWITCH PARTITION 1 TO OrdersOctober2002, courtesy...

Thanks for response.

An index that follows the partitioning strategy of the base partitioned table e.g. same partitioning schema and partitioning column - nothing more, nothing less.

By saying the...

The security permissions on the server login for the user shows no user mapping to the databases in question.

So, just a recap. When I right click on the database...

In addition, if I look at user mapping for user NT AUTHORITY\SYSTEM, the user mapping is empty.

+ive

Thanks All.

With your guidance, I was able to dig out, http://msdn.microsoft.com/en-us/library/ms174335.aspx

Best Practices for Bulk Importing Data

Using INSERT INTO…SELECT to Bulk Import Data with Minimal Logging

You can use INSERT INTO...

Thanks All.

With your guidance, I was able to dig out, http://msdn.microsoft.com/en-us/library/ms174335.aspx

Best Practices for Bulk Importing Data

Using INSERT INTO…SELECT to Bulk Import Data with Minimal Logging

You can use INSERT INTO...

Thanks for your guidance.

I was wondering if I could bring the database up with Primary filegroup and open it to the users while I add the remaining filegroups (while...

Thank you. It worked like a charm.

-WK