Viewing 15 posts - 2,791 through 2,805 (of 4,272 total)
I think there is a BLOB source on Codeplex that would probably be better than that, but I don't have its URL right now..
CEWII
February 16, 2010 at 11:48 am
CirquedeSQLeil (2/16/2010)
Come to think of it - it seems like he just wanted us to hold his hand and do it for him maybe 😀
That link you sent was the...
February 16, 2010 at 11:44 am
I just needed to vent a little bit..
I see that it was in the 7, 2000 group but the title is:
Dynamic Connection TO DIFFERENT INSTANCES in SQL SERVER...
February 16, 2010 at 11:42 am
If that is your path then it would likely make sense to make the column varbinary(max) and put a full-text index on it. For a full-text index you need...
February 16, 2010 at 11:38 am
Grrrr..
Do people not know how to read these days..
Between me and another prominent poster we provided an answer and a link to exactly do the answer. And later on...
February 16, 2010 at 11:03 am
CirquedeSQLeil (2/16/2010)
varma1412-1092791 (2/16/2010)
Please help me out with the above question. No one answering .
An answer and a resource on how to do it was posted. Is the question different...
February 16, 2010 at 10:59 am
You *might* be able to do this with SQLCLR however, crossing the boundary from SQL into the Filesystem should not be considered lightly. You have a lot more potential...
February 16, 2010 at 10:58 am
I would take something like:
FSSearchIndex Framework - A managed File System search and indexing framework
http://fssearchindexfx.codeplex.com/
And use it to find the text and then write the path and filename to...
February 16, 2010 at 10:27 am
That reference definitely shows all the steps.
CEWII
February 16, 2010 at 10:09 am
My first thought is that I would not do this in SQL. I might use SQL to store saved terms. Or even pull the files into a table...
February 16, 2010 at 10:08 am
I'm saving that link for future use, I hate re-explaining that everytime this question comes up and it seems to come up a lot..
CEWII
February 16, 2010 at 9:30 am
I see you doing this with a Exec SQL Task to return a full resultset that is used by a For-Each Loop to hold a data-flow task.
CEWII
February 15, 2010 at 4:47 pm
So you had a GO statement following your update statement that didn't seem to run? That sort of rang a bell, if you didn't I can think of cases...
February 15, 2010 at 9:06 am
I thought of another potential solution.
You could add that user to the model database and it would be there automatically at creation without using a DDL trigger.
CEWII
February 11, 2010 at 8:35 am
Although at first blush I'm not a fan of what you are doing and would want to hear a whole bunch about why.. You could probably build a dynamic...
February 10, 2010 at 2:44 pm
Viewing 15 posts - 2,791 through 2,805 (of 4,272 total)