If that does not work (presumably because the services were not closed correctly before the file was deleted), there is a recent article that has an approach to doing this:

http://www.sqlservercentral.com/articles/Disaster+Recovery/63311/%5B/url%5D

If...

I would question how much digging is actually legal. With the laws around hiring practices, I think even googling someone's name would run a very high risk of returning...

SSIS is very data type sensitive. My guess is that your source data is a different data type. It can be something as simple as your source is...

You have to add it to the GAC also.

The 10g oracle client is not 100% OLEDB compliant. I am sure it is not the only client version with compliance issues. It has caused the same issue...

That's the generic "cannot connect" message. Ignore all of the extra wording, it just means that when the connection attempt was made, the server could not be contacted.

Since it...

You can start a job using msdb.sp_start_job

Did you add it to your toolbox items?

Go to Tools -> Choose Toolbox Items in the menu.

You also have to make sure your exchange server is configured to allow you to use it as an SMTP relay. I think, by default, it allows relay to...

Like Gail said, these hints have some awful side-effects. NOLOCK in particular can result in missed or even duplicated data as your query reads through the pages.

I have found...

Basically, the answer is No, No, and No.

Putting files and partitions on different drives is to get additional read and write heads from the physical disks that do not interfere...

Just beware of it.

It ends up pretty slow because it typically ends up with a looping cursor in the background - so it is row-by-row processing.

But in cases of recursion...

I think the original post was wrong.

If you look at the diagram and the data, 40 and 60 are children of 30 and 50, not in the path we are...

You can use a recursive CTE.

I had to use a UNION to go back up the tree, but this seems to have worked,

[font="Courier New"]CREATE TABLE #t (PID INT, ParentID INT,...

Look up sp_Attach_db in books online. It is common practice to attach a database from another instance. I do it regularly. I have not tried to detach...