I finally managed to remove the noise words. It seems that MSSQLSVR2K8R2 (Uf!) has hardcoded somewhere (apparently some "resource" database, whatever that is) the noise words for each language. So, what I did was:
1.- Create my own stoplist[^]
2.- Through the SQL Management Studio, open the full-text index properties and then select the recently created stoplist rather than the default.
3.- Alter[^] the stoplist and drop the noise word.
4.- Re-index the full-text index.
Yeh, tried looking for those files, yet didn't find 'em on MSSQLSVR 2008. I found the Thresaurus, mind you, but not the words. I read in MSDN that in 2008 they were stored in the "Resources" database, yet I wasn't able to find 'em.
I have an application where the client is working against a local DB, and each night will upload its data to the server, so I need Id's that are unique in the server's DB. The server and client DB's are identical.
Here's the tables:
CREATE TABLE tblOperators
(OperatorId INT IDENTITY NOT NULL,
AccountNo VARCHAR(10) NULL,
[Name] VARCHAR(100) NOT NULL,
Address1 VARCHAR(100) NOT NULL,
Address2 VARCHAR(100) NULL,
City VARCHAR(100) NOT NULL,
[State] VARCHAR(2) NOT NULL,
ZipCode VARCHAR(10) NOT NULL,
Phone VARCHAR(10) NOT NULL,
Email VARCHAR(100) NULL,
IsActive BIT NULL)
CREATE TABLE tblFacilities
(FacilityId INT IDENTITY NOT NULL,
OperatorId INT NOT NULL,
FormOfPaymentId INT NULL,
SaleTypeId INT NULL,
FacilityName VARCHAR(100) NULL,
FacilityAddress1 VARCHAR(100) NULL,
FacilityAddress2 VARCHAR(100) NULL,
FacilityCity VARCHAR(100) NULL,
FacilityState VARCHAR(02) NULL,
FacilityZip VARCHAR(10) NULL,
FacilityPhone VARCHAR(10) NULL,
BankName VARCHAR(100) NULL,
ManagerName VARCHAR(100) NULL,
ManagerPhone VARCHAR(10) NULL,
ManagerEmail VARCHAR(100) NULL,
PickupDays VARCHAR(100) NULL,
IsActive BIT NULL)
You can see the Operator and Facility Id's. They won't work once sent to the server.
I'm not sure how to define compound keys. Can someone point me in the right direction?
You may need to rethink your whole application. I mainly wonder why the
clients would be adding records to these tables.
What if the client doesn't have a network connection? Where would the store the data. This application cannot have down time in the event of a lost connection. So the app will have a local data store and update the server periodically.
So, since new records can be added in the client's DB, I need to make sure the PK's are unique.
Is this a oneway communication where the data is only uploaded, or will it synchronise the data with the server?
If it's just an upload you don't need to have global keys, you can add new keys at the server when uploading.
I downloaded Oracle's ADO.net connector and added support for it in my database classes. That meant that I could access Oracle databases from my console and WinForms apps, including one that allows the user to enter ad hoc queries and view the schema.
SQLTools[^] if you want it lightweight. TOra[^] is at the other end of the spectrum.
Both are opensource.
SQL Developer and Oracle Developer Tools for Visual Studio has already been mentioned. They are from Oracle and are supported, ... sort of.
You will also need to install some version of the Oracle Client which is available in several versions such as the normal Client, Instant Client or Oracle Data Provider for Dotnet.
Oracle Developer Tools for Visual Studio has the Client built in.