Viewing 15 posts - 3,916 through 3,930 (of 6,216 total)
Still not sure why you'd care - better to implement better code that works with the data so that the positioning doesnt matter.
Andy
June 28, 2002 at 4:21 am
On #1, the answer is it depends. In SQL7, no. In SQL2K you can add or delete columns, but not modify. To do this you have to make the changes...
June 28, 2002 at 4:19 am
Not clear on what you're asking. For a user to connect to the server they have to have a login. To connect to a database that login has to be...
June 28, 2002 at 4:16 am
Take a look at sp_addalias too. Aliases are normally used so that you can allow a user to create objects owned by dbo without making them the db owner. You...
June 28, 2002 at 4:15 am
June 27, 2002 at 3:16 pm
If you want the order guaranteed you'll have to add an order by.
Andy
June 27, 2002 at 7:08 am
Interesting. What about when you have a pick list of a hundred or a thousand items? Not uncommon at all.
The approach we've taken is store a code for each answer...
June 27, 2002 at 4:58 am
I see a bunch of postings about it on Google. Tried recreating the profile while logged in using the account the mail will run under? Voodoo.
Andy
June 26, 2002 at 1:50 pm
You can put it in a proc and mark it as a start up proc. Sp_procoption maybe?
Andy
June 26, 2002 at 11:38 am
That method works well. Only point to remember is that updated doesnt necessarily equal changed. If the user updated the col to the same value, it still fires update().
Andy
June 26, 2002 at 11:36 am
No bug that I know of. Could you post the code?
Andy
June 26, 2002 at 8:19 am
I agree there is a ton of advice out there. I'll add my couple thoughts, Im sure you'll get others! RAID 5 is good enough for performance in my experience....
June 26, 2002 at 4:42 am
Thanks again for everyones comments so far. Im pleased to see that a few of you agree with me!
Andy
June 25, 2002 at 4:27 pm
Im all in favor of primary keys, even if you have to contrive one.
Andy
June 25, 2002 at 4:20 pm
Viewing 15 posts - 3,916 through 3,930 (of 6,216 total)