Chirag (9/3/2009)

---

While creating the table to store filestream data you have specified the filestream file group with the keyword "FILESTREAM_ON". Is it necessary because i did not find the same...

I'm not sure exactly what you mean, but I will try to clarify in hopes that it answers your question.

In...

Ravi S. Maniam mentions this in his blog post on Filestream. Looks...

In the delimited list scenario, it is probably still easiest to rip the list using a User-defined table-valued function.

I agree as well.  Profiler gives you the fastest track to the information regardless of your application's "live" status.

I think most of you all need to get a life .  For crying out loud, does anyone really expect a free lunch?  If...

160G in the home PC, plus the old 160G HDD which I use for daily file backups.  I use it for video editing, DVD production, years of pictures, all my...

I don't know first hand if this will work, but you could try writing a vb script that calls your DTS package and establish the global variable in the vb...

Congrats on the achievment!  I appreciate all the hard work you guys put in every day.  Each morning I look forward to what new I can learn from your articles...

Nice article Andy.  I think it is always good to challenge long held "well everyone knows that" type of knowledge.  I agree that cursors are not evil and are often...

I agree with Hugo.  In addition, the answer statement only returns a recordset rather than performing an insert, as with a "select into".  The question says you are inserting this data.

Good article!  You can extend this concept to store the extracted data in a Dba database and then use scheduled report server reports.  I have used this concept to email...

It looks like they just made a small mistake in flagging the correct answer.  Hey, we're all human.

Not only technically but literally.  Don't worry, the questions/answers aren't always perfect.

The question wording should have been "What message types are available... " instead of "What message types exist..."

But either way I got it wrong fair and square.