Showing posts with label missing. Show all posts
Showing posts with label missing. Show all posts

Sunday, March 25, 2012

Attach damaged database

Is there any way to attach a database that is missing a ndf for a file group? Note: The file group has no database objects on it.

Thanks

My first answer is no, but maybe you can create a "dummy" ndf file with all the same properties that the original ndf file should have?sql

Thursday, March 22, 2012

Asynchronus Transformation Component

Hi all,

I am missing something simple. I have added a new Transformation Script, put in my code to read the input rows, defined my outputs. I have tried to change the SynchonousInputId to 0, but I only get the option of None or input "Input 0" (91). What have I missed?

Set the SynchonousInputId to None.

The SynchonousInputId of "None" is synonymous with zero (0). The script transformation editor dropdown for the SynchonousInputId changed between service packs between saying "0" in the earlier case, to "None" in subsequent service packs. Both 0 and "None" for the SynchonousInputId property mean, "this is a async script transform".