Viewing 15 posts - 3,331 through 3,345 (of 3,556 total)
Hans,
If you use Full Text Search facilities then you must have a primary key because SQL Server saves various status flags and other bits and bobs in the primary key.
I...
July 10, 2003 at 4:43 am
quote:
Can I host all the SQL Servers on one powerful machine under windows 2000?
Yes...
July 10, 2003 at 3:00 am
quote:
I don't understand your point? Why do you so forcefully express that your Identity column HAVE to be your primary key?
July 10, 2003 at 2:30 am
I've had this sort of problem with a number of applications. Message boxes that appear behind modal forms are a good one!
I've also seen it happen when someone has...
July 9, 2003 at 8:41 am
One of the content management systems I use is called OBTREE and all binary files are stored within the database. One client has over 8,000 binary files stored in...
July 8, 2003 at 1:46 am
My company works with many CMS vendors. The attitudes of two of them show up the stark contrasts between vendors.
Vendor A
July 4, 2003 at 2:28 am
I've been looking at e-commerce and one of the options open to me as a developer is to route the payment method through a known credit card provider. In...
July 3, 2003 at 2:52 am
My identity column is ALWAYS my primary key, otherwise there would be no point in having it. It tends to be my clustered index but won't necessarily be so.
If I...
July 1, 2003 at 2:10 am
I've also had problems where Access is referencing a VIEW and there is no primary key.
Unless Access has a primary key, virtual or otherwise, it doesn't like editing records.
June 30, 2003 at 9:38 am
Thanks for that both of you.
The other trade-off I have to consider is that I will be handing over the database and stored procedure list to other developers so that...
June 30, 2003 at 2:40 am
quote:
David, quick question. When you select from this table are you joining to it or from it? When you join...
June 30, 2003 at 2:20 am
It depends on your user's abilities. If they are surviving brain donors then you will need something expensive to allow them to write their own reports.
For the reasonably literate...
June 27, 2003 at 10:39 am
http://www.technology-and-computers.com/Computers/Programming/Disassemblers/6502/
BBC Model B...ahh those were the days. I've heard that there has been a major university project to extract data from the old Doomsday project that used BBC B's...
June 27, 2003 at 5:30 am
quote:
I've had to deal with are errors like PK violations ... I would like to figure out how to trap these kinds...
June 26, 2003 at 7:30 am
On the ADO error thing I tend to have a local stored procedure variable that I use to record errors that occur within the stored procedure.
Obviously I try and test...
June 26, 2003 at 7:16 am
Viewing 15 posts - 3,331 through 3,345 (of 3,556 total)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy