|
Yes, i've just got the very same advice. At the moment i'm not able to enable it even because i didn't even know about it. Now i'll try to learn it. Thanks!
|
|
|
|
|
At http://www.windowsitpro.com/SQLServer/Article/ArticleID/8828/8828.html i see this sentence in the section "Disadvantages of Full-Text Search":
[i]7. You can only use a wildcard (asterisk) as a placeholder for suffixes; you can't use a wildcard at the beginning of a search string. (For example, to find all occurrences of "sailboat," you need type "sail*" instead of "*boat.")[/i]
If i understand that correctly, that makes Full-Text Search useless to me; however, at the moment that also makes Full-Text Search look to me like useless in absolute, because i can't see anymore what does it do more or better than normal search.
But since it's impossible that Full-Text Search doesn't do anything more or better that normal search, this means that i'll need to better understand the whole matter.
|
|
|
|
|
hi
i want to develope new application which is multilocational & on every transaction i want to transfer data to server which is located at other place
so how i could do this?
either by doing dataset or is there any other method for this
plz answer me this is vey urgent
|
|
|
|
|
You may want to look at web services
|
|
|
|
|
Try to do little home work on Distributed Transaction if you want to update into different database.
Sreejith Nair
[ My Articles ]
-- modified at 7:12 Tuesday 20th September, 2005
|
|
|
|
|
I have a big problem with MS.Access. Now, I have two databases (DB). The problem is that I want to add a record to the first DB and the result I expect that that record is exist in the second DB automatically. In addition, two DBs are on the two computers. Thanks...
|
|
|
|
|
Create a third db (database) with the tables for the two dbs in a single located server point. Use linked tables on client dbs versions to the link central version of the tables. You can now run multiple clients off the same back end db.
|
|
|
|
|
Maybe my question is not clearly. The problem is that I want to control (add, remove, delete, or update a record of a table) the remote database of MS.Access on another computer when I'm from a database of Access on my computer.
|
|
|
|
|
hi there,
vtalau wrote:
I have a big problem with MS.Access
=>what probs u r facing?
vtalau wrote:
I want to add a record to the first DB and the result I expect that that record is exist in the second DB automatically
=> whenever u insert a record to the first DB, also insert this to the second one.
<< >>
|
|
|
|
|
Try to do little home work on Distributed Transaction if you want to update into different database.
Sreejith Nair
[ My Articles ]
|
|
|
|
|
I think "Distributed Transaction" is not exist in MS.Access. How I control (add,remove,delete,or update a record of a table) the remote database of Access when I'm from a database of Access. Two databases are also on two computers.
|
|
|
|
|
Sorry that was a mistake.
If it is access you have to ensure that both database table got Inserted/Deleted/Updated.
Otherwise you have to upgrade your access to Sql Server or other.
Sreejith Nair
[ My Articles ]
|
|
|
|
|
Hi Guyz!!
pls help,
how can one measure the size of connection pool.
confused:
|
|
|
|
|
|
what I mean is that:
-how can one find out the number of connections to the pool
-is there any limits to the connection pooling,if so how can I trace if that limit is reached.
hope I 've clarify my question now "enjoycrack"
|
|
|
|
|
|
I am trying to dubug some of stored procedure which is located in my local server and as well as database which is located in network.
I followed all steps which found in Sql Server 2000 help. But the moment i start debug, the debugger is not allowing me to step into/throu.
Why this ? What will be the issue.
Sreejith Nair
[ My Articles ]
|
|
|
|
|
You can copy the body of your sp to Query Analyzer and debug it there. Replacing input variables foe DECLARES and use SET @Variable to set intial conditions.
|
|
|
|
|
That is what i am doing. But the moment i try to start debug, the Queary analyzer won't allow me to do setu throu/down. It completes the Sp execution automatically.
Sreejith Nair
[ My Articles ]
|
|
|
|
|
Friends,
Is it possible for me to store entire MS-Word document in the SQL server database. If yes, then please tell me how can we do so ? What will be the column's datatype and how to store & retrieve the word file ?
Thanks.
Ahsan
|
|
|
|
|
Yes, you can store an entire MS Word document in Sql Server.
The column in which the document is stored should probably be of type 'image', and you can use the ADO.Net clients to write to the column (image columns accept a byte array - byte[]).
You can read the document into a stream, and use the stream's buffer (byte array) as input for the image column.
Reading the document back from the database works in a similar fashion - read the byte array from the image column into a stream.
Look at FileStream for more info.
The most exciting phrase to hear in science, the one that heralds the most discoveries, is not 'Eureka!' ('I found it!') but 'That's funny...’
|
|
|
|
|
hi there,
play with binary large objects (BLOBs) data type.
<< >>
|
|
|
|
|
I just checked the SQL server data types. There is no BLOB data type. The only matching datatype is "binary". By BLOB do you mean "binary" ?
Ahsan
|
|
|
|
|
The best practise for storing large files such as Word documents is to store the file path location and name in the database. And have the actual file stored in the file system rather than in the SQL server database.
You could use the varbinary[^] column type however there is a limit of 8000 bytes on SQL Server 2000.
Michael
CP Blog [^] Development Blog [^]
|
|
|
|
|
Hello frends!
i have this table:
+-------+----------+-----------------+----------+
| ID | ParentID | ChildIDs | ModuleID |
+-------+----------+-----------------+----------+
| 9 | [NULL] | 91 | 20001010 |
| 90 | [NULL] | 901 | 20001018 |
| 901 | 90 | 9011,9012 | [NULL] |
| 9011 | 901 | [NULL] | [NULL] |
| 9012 | 901 | [NULL] | [NULL] |
| 91 | 9 | 911,912,913,915 | [NULL] |
| 911 | 91 | [NULL] | [NULL] |
| 912 | 91 | [NULL] | [NULL] |
| 913 | 91 | [NULL] | [NULL] |
| 914 | 91 | [NULL] | [NULL] |
| 915 | 91 | [NULL] | [NULL] |
+-------+----------+-----------------+----------+
now what im supose to do is display rows based on the moduleIDs. Now when ModuleID is displayed along with the other IDs, its supose to display all the IDs included in each row's childIDs. for example i search for ModuleID=20001010 the row with ID=9 will be displayed along with row with ID=91 (because its ID is included in ID=9 's childID and because its ParentID is ID=9 ). So will the row with ID=911 will be displayed (because its ID is included in ID=9 's childID) and so on.
I've been busting my head open bout how i could do this. i can only make the 1st tier show (ID=91 ) but the next set of rows i'm quite clueless about. Any Ideas how I could make this work? Thanx so much for all your helps...believe me il be very much greatful to you all!
Aim small, miss small...
|
|
|
|