| Author |
Topic |
|
Stoad
Freaky Yak Linguist
1983 Posts |
 Posted - 2003-12-01 : 06:49:59
|
| The best way to disable a trigger forever?Uh? |
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2003-12-01 : 06:56:41
|
| Drop the databaseDamian |
 |
|
|
Stoad
Freaky Yak Linguist
1983 Posts |
Posted - 2003-12-01 : 07:01:27
|
| With option forever? |
|
|
|
MichaelP
Jedi Yak
2489 Posts |
Posted - 2003-12-01 : 13:12:43
|
| Comment out the code in the trigger? DROP the trigger? What exactly are you trying to accomplish?Michael<Yoda>Use the Search page you must. Find the answer you will.</Yoda> |
|
|
|
X002548
Not Just a Number
15586 Posts |
|
|
Stoad
Freaky Yak Linguist
1983 Posts |
Posted - 2003-12-01 : 15:15:21
|
| AAAAAAAAAAAAAAAAAAHHHHHHHHHHHHHHHHHHH!!!!!!!!!!!!!!!!!6 pages to read!! Brett, have you a digest of your link? |
|
|
|
The Enigma
Posting Yak Master
179 Posts |
Posted - 2003-12-01 : 15:18:41
|
| BTW ... was that the largest thread on this site or there was another bigger than this ???Biggest thread I 've ever participated in :http://www.dbforums.com/t971826.htmlAttitude is everything{The Enigma} |
|
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2003-12-01 : 15:30:33
|
quote:
Originally posted by Stoad
AAAAAAAAAAAAAAAAAAHHHHHHHHHHHHHHHHHHH!!!!!!!!!!!!!!!!!6 pages to read!! Brett, have you a digest of your link?
It's history...the essence of the YAK..Rob hitting 2000!WOW...Good read...2001 a YAK odyssey....all 6.5...talks about just getting going with 2k sp1!About people "learning" to up their post count in the site realted discussion forum (there was no corral back the, he?)Brett8-) |
|
|
|
Stoad
Freaky Yak Linguist
1983 Posts |
Posted - 2003-12-01 : 16:54:22
|
| AAAhhh... about learning how to up the post count...Well.. and what is the best method so far??Are there some interesting discoveries on that uneasy path?Uh? |
|
|
|
Stoad
Freaky Yak Linguist
1983 Posts |
Posted - 2003-12-01 : 16:57:56
|
| BTW.. a couple of times my post count failed to increment.. |
|
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2003-12-01 : 17:01:41
|
| And you say you don't drink.....How are the pink elephants today?Brett8-) |
|
|
|
Stoad
Freaky Yak Linguist
1983 Posts |
Posted - 2003-12-02 : 05:36:58
|
| Ha! elephants.. graz can confirm that it's possible. Last time it happenedabout 2-3 weeks ago... I pressed 'Post Reply' and then I was waiting forthe usual response - 'Thank for your contribution!' but, oops, got insteadthe error message 'Timeout expired' (the line conditions were very bad atthe time)... Well, I thought that my new post was not added but it was.However my post count did NOT increment for this my post.??? |
|
|
|
Stoad
Freaky Yak Linguist
1983 Posts |
Posted - 2003-12-02 : 14:04:24
|
| Heh.. pity.. they think I was joking about the post count.. |
|
|
|
graz
Chief SQLTeam Crack Dealer
4149 Posts |
Posted - 2003-12-02 : 14:32:41
|
| Because all the SQL is in the ASP and not in a stored proc (or transaction) it's possible to post a reply but not have your post count go up. Sorry.===============================================Creating tomorrow's legacy systems today.One crisis at a time. |
|
|
|
Stoad
Freaky Yak Linguist
1983 Posts |
Posted - 2003-12-02 : 16:02:02
|
| Oh.. why 'sorry'? :)I did not mean any complaint.. just an amuzing info.. |
|
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2003-12-03 : 13:57:12
|
| Nobody thinks that historical thread was interesting?geeeezBrett8-) |
|
|
|
JimL
SQL Slinging Yak Ranger
1537 Posts |
Posted - 2003-12-03 : 14:55:51
|
| forever\For*ev"er\, adv. [For, prep. + ever.] 1. Through eternity; through endless ages, eternally.2. At all times; always.Note: In England, for and ever are usually written and printed as two separate words; but, in the United States, the general practice is to make but a single word of them.Forever and ever, an emphatic ``forever.''Syn: Constantly; continually; invariably; unchangeably; incessantly; always; perpetually; unceasingly; ceaselessly; interminably; everlastingly; endlessly; eternally.Source: Webster's Revised Unabridged Dictionary, © 1996, 1998 MICRA, Inc. forevern : time without end [syn: eternity, infinity] adv 1: for a limitless time; "no one can live forever"; "brightly beams our Father's mercy from his lighthouse evermore"- P.P.Bliss [syn: everlastingly, eternally, evermore] 2: (informal) for a very long or seemingly endless time; "she took forever to write the paper"; "we had to wait forever and a day" [syn: forever and a day] 3: seemingly without interruption; often and repeatedly; "always looking for faults"; "it is always raining"; "he is forever cracking jokes"; "they are forever arguing" [syn: always]Source: WordNet ® 1.6, © 1997 Princeton University After all nothing Lasts foreverJimUsers <> Logic |
|
|
|
Arnold Fribble
Yak-finder General
1961 Posts |
Posted - 2003-12-03 : 17:17:57
|
quote:
Note: In England, for and ever are usually written and printed as two separate words;
FOREVER (1872)Forever; 'tis a single word! Our rude forefathers deemed it two;Can you imagine so absurd A view?Forever! What abysms of woe The word reveals, what frenzy, whatDispair! For ever (printed so) Does not.It looks, ah me! how trite and tame! It fails to sadden or appalOr solace -- it is not the same At all.O thou to whom it first occurred To solder the disjoined, and dowerThy native language with a word Of power:We bless thee! Whether far or near Thy dwelling, whether dark or fairThy kingly brow, is neither here Nor there.But in men's hearts shall be thy throne, While the great pulse of England beats,Thou coiner of a word unknown To Keats!And nevermore must printer do As men did long ago; but run"For" into "ever," bidding two Be one.Forever! passion-fraught, it throws O'er the dim page a gloom, a glamour:It's sweet, it's strange; and I suppose It's grammar.Forever! 'Tis a single word! And yet our fathers deemed it two;Nor am I confident they erred; Are you? --- C. S. Calverley |
|
|
|
rrb
SQLTeam Poet Laureate
1479 Posts |
Posted - 2003-12-04 : 02:13:35
|
| Calverly was a chap who'd endeavourTo write lines in verse, very clevera typical pomwith literary aplombBut one who (it appears) could'nt rhyme with "forever"--I hope that when I die someone will say of me "That guy sure owed me a lot of money" |
|
|
|
|
Tough SQL Question