That just bout answer it... open straight in BOL...

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/extran9/html/d33985f7-1048-4023-83e4-274090acda78.htm

UPPER (SSIS)...

bitbucket (2/13/2009)

---

I think I have gained an insight into why some of the users questions appear to be soooooo, well not intelligent. Last evening I attended a SQL User...

I can't wait to see what he'll answer to why did you / do you want to leave your current position? Oh, just because!

... and in the "you're screwed category", the award goes to : http://www.sqlservercentral.com/Forums/Topic656268-357-1.aspx

The other way to restore that data is to manually reenter it... that is if you keep some sort of hard copies.

That reminds me of those 2 procs... hoping you don't need to use them anytime soon :

exec sp_update_resume

exec sp_distribute_resume

Just my 2 cents, use the windows search (can scan network drives and multiple drives without making a complicated loop).

Then make sure those files are not needed

Get authorisation to...

Can't you connect to it using query analyser?

For anyone who cares to know, this behavesas stated in the explaination both for 2005 and 2008 of ma machine (latest services packs).

When was it ever logical???

Not since 6.5. One...

Cool, when would now be the time to most "correct" questions to ask?

... and then you probably still missed some :P.

RBarryYoung (2/6/2009)

---

Lowell (2/6/2009)

---

i've got a stored proc i made that i named sp_getDDL, which trolls thru the table definition and it's columns and builds the script for the table;...

I'd go the complete opposite. If the data requiresa unique index (for data quality), then go ahead and create the index. I wouldn't do a unique index just...