Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
drsloat
Starting Member
45 Posts |
 Posted - 2004-08-02 : 16:35:13
|
| I have a table with an image column holding a number of xml documents. These documents have custom properties defined in them that I would like to be able to query (with greater accuracy than a full text query).I have this idea that I could put a trigger on the table so that I could parse the file and store the meta data in sql server. Does this sound like a reasonable idea? Would you try to extract the data from the image column in the stored procedure or would it be easier to set a flag that a scheduled task would check for and then update? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
drsloat
Starting Member
45 Posts |
Posted - 2004-08-02 : 17:26:19
|
| It's Windows Sharepoint Services that is storing the documents in the database. WSS is kind of a document management system. I'm trying to modify a custom web app that stores files on the file system and runs queries against custom properties through Index Server, so that it will work with files stored in WSS. |
 |
|
|
Sitka
Aged Yak Warrior
571 Posts |
Posted - 2004-08-04 : 11:49:32
|
| What is the exact table in WSS you are looking at?It is a rich creamy color with a high fat content of 5-7 percent. Being so high in fat, it is usually processed into butter, cheese, or yogurt. An average cow will produce 110 kg. Milk in a lactation period of an average of 149 days |
|
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2004-08-04 : 12:21:01
|
quote:
Originally posted by drsloatDoes this sound like a reasonable idea?
No it does not.If you have to do this I would use a sprocBrett8-) |
|
|
|
|
|
|
Advice on working w/ Image column in trigger
Tara