SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Site Related Forums
 The Yak Corral
 Trigger Madness
 New Topic  Reply to Topic
 Printer Friendly
Previous Page | Next Page
Author Previous Topic Topic Next Topic
Page: of 5

Kristen
Test

United Kingdom
22403 Posts

Posted - 11/17/2005 :  00:44:46  Show Profile  Reply with Quote
Never did 1.8 times table at skool

What's the matter with 16C = 61F (cold) and 28C = 82F (hot) ?

Kristen
Go to Top of Page

elwoos
Flowing Fount of Yak Knowledge

United Kingdom
2050 Posts

Posted - 11/17/2005 :  03:34:07  Show Profile  Reply with Quote
quote:
elwoos: what's the "F" thing that they put after their temperature figures?


Hey Kristen, you're a lot older than me I thought you would know that


steve

-----------

Facts are meaningless. You could use facts to prove anything that's even remotely true!
Go to Top of Page

madhivanan
Premature Yak Congratulator

India
22755 Posts

Posted - 11/17/2005 :  04:26:13  Show Profile  Send madhivanan a Yahoo! Message  Reply with Quote
>>Hey Kristen, you're a lot older than me I thought you would know that

I think he forgot it

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page

Kristen
Test

United Kingdom
22403 Posts

Posted - 11/17/2005 :  04:51:26  Show Profile  Reply with Quote
Forgot what?
Go to Top of Page

madhivanan
Premature Yak Congratulator

India
22755 Posts

Posted - 11/17/2005 :  04:57:53  Show Profile  Send madhivanan a Yahoo! Message  Reply with Quote
Forgot of what you forgot

Madhivanan

Failing to plan is Planning to fail

Edited by - madhivanan on 11/17/2005 04:58:33
Go to Top of Page

Kristen
Test

United Kingdom
22403 Posts

Posted - 11/17/2005 :  05:54:36  Show Profile  Reply with Quote
Can you remind me what my password is here, thanks ...
Go to Top of Page

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

USA
7020 Posts

Posted - 11/17/2005 :  08:07:28  Show Profile  Reply with Quote
You mean 16C = 60.8F and 28C = 82.4F?

I just remember that -40C = -40F, real, real cold.

quote:
Originally posted by Kristen

Never did 1.8 times table at skool

What's the matter with 16C = 61F (cold) and 28C = 82F (hot) ?

Kristen



CODO ERGO SUM
Go to Top of Page

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

USA
7020 Posts

Posted - 11/17/2005 :  08:17:29  Show Profile  Reply with Quote
More trigger madness:
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=57883




CODO ERGO SUM
Go to Top of Page

steamngn
Constraint Violating Yak Guru

USA
306 Posts

Posted - 11/17/2005 :  08:25:33  Show Profile  Visit steamngn's Homepage  Reply with Quote
Here's two cents from an inexperienced newbie:
I've learned a million things from everyone here (Thanks again!),and as Kristen and Brett know, I'm about to learn a helluva lot more about SQL with my new position. Several books that I have just purchased go into great detail about triggers, without somuch a even a mention of system overhead and the such. Even with my limited knowledge I can see that there are better ways than triggers, but triggers have an 'ok, that makes sense' look to them while constraints tend to leave the uneducated scratching their heads a bit. Read some trigger code in a book (or BOL), and it says something like 'Do this if that equals this or else do something different', while a constraint says the same thing in a very condensed way. Beginners have a hard time connecting the dots, I think. I'm reading, I'm reading!!

Hey Brett, when are we having those Margaritas? And it is more like winter now, huh?
andy

There's never enough time to type code right,
but always enough time for a hotfix...
Go to Top of Page

Kristen
Test

United Kingdom
22403 Posts

Posted - 11/17/2005 :  08:31:11  Show Profile  Reply with Quote
"I just remember that -40C = -40F, real, real cold"

When your spit (or whatever it might be, if you are really brave!) freezes before it hits the ground, eh?

Kristen
Go to Top of Page

elwoos
Flowing Fount of Yak Knowledge

United Kingdom
2050 Posts

Posted - 11/17/2005 :  10:41:44  Show Profile  Reply with Quote
Kristen - did you forget that you'd hit enter

-----------

Facts are meaningless. You could use facts to prove anything that's even remotely true!
Go to Top of Page

mcrowley
Aged Yak Warrior

771 Posts

Posted - 11/17/2005 :  12:02:32  Show Profile  Reply with Quote
He's testing that functionality. You never know what a regression test is going to pick up. ;-)
Go to Top of Page

Kristen
Test

United Kingdom
22403 Posts

Posted - 11/17/2005 :  13:15:08  Show Profile  Reply with Quote
Bang! That's the regression test trigger firing ...
Go to Top of Page

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

USA
7020 Posts

Posted - 12/09/2005 :  15:58:27  Show Profile  Reply with Quote
More Trigger Madness:

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=58902





CODO ERGO SUM
Go to Top of Page

Sitka
Aged Yak Warrior

USA
571 Posts

Posted - 12/09/2005 :  16:32:53  Show Profile  Reply with Quote
Response to

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=58902

Do you need to send an email notification within that trigger as well; You know?, to let the person
know the file has arrived, please let me know so I can better help you.


That's too asshole to say in real life and it would takes days for me to write any trigger anyway.

"it's definitely useless and maybe harmful".

Edited by - Sitka on 12/09/2005 16:33:43
Go to Top of Page

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

USA
7020 Posts

Posted - 06/29/2006 :  17:21:52  Show Profile  Reply with Quote
More Trigger Madness.

Error updating an Access database from a trigger.
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=68518




CODO ERGO SUM
Go to Top of Page

X002548
Not Just a Number

15586 Posts

Posted - 06/29/2006 :  17:47:12  Show Profile  Reply with Quote
Is there a Kristen Trigger that keeps this thread alive?



Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

Add yourself!
http://www.frappr.com/sqlteam
Go to Top of Page

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

USA
7020 Posts

Posted - 06/29/2006 :  18:00:43  Show Profile  Reply with Quote
There is an endless variety of strange things people want to do with triggers.



CODO ERGO SUM
Go to Top of Page

Kristen
Test

United Kingdom
22403 Posts

Posted - 06/30/2006 :  01:54:24  Show Profile  Reply with Quote
"trigger in mssql which should update a table in a msaccess database"

I read that and went OMG ... but then I assumed it was just me, and didn't type a reply!

I'll go and do it right now ...

"Is there a Kristen Trigger that keeps this thread alive?"

Just another Trigger Happy programmer!

Kristen
Go to Top of Page

jen
Flowing Fount of Yak Knowledge

Sweden
4110 Posts

Posted - 06/30/2006 :  02:19:41  Show Profile  Send jen a Yahoo! Message  Reply with Quote
no whips please...

i understand why developers should not be given the opportunity to create triggers unless really really necessary

for DBA, in my humble experience, I needed to create a trigger that will prevent commitment of data in instances where the request is coming from an unauthorized:
1. machine name
2. account
3. ip address
4. time of the day
5. application
which is mostly due to sharing of connection credentials

Developers/users are very clever in circumventing permissions and ways to access databases that they don't have access to (especially timesheet tables)

Example, devA has access to dbA, devB is developing a new apps for dbA, so instead of asking for appropriate permissions, devB uses devA credentials (sql login and any approle issued)... Since deployment of the apps does not go through the DBA, one day you just see in your daily summary, loginA is the same for appsA and appsB

Another is creating applications using dynamic sql for server requests because they didn't want to use query analyzer and created their own version of enterprise manager, and then pulling millions of data for review or exporting to excel files for 'format' review, etc...

sorry for the rant

But after awhile, when they realize, they shouldn't be doing it coz nothing gets committed, you can disable the trigger and just enable it once in awhile for random check


--------------------
keeping it simple...
Go to Top of Page
Page: of 5 Previous Topic Topic Next Topic  
Previous Page | Next Page
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.31 seconds. Powered By: Snitz Forums 2000