Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
dbalearner
Constraint Violating Yak Guru
272 Posts |
 Posted - 2010-08-16 : 21:31:38
|
| I have problem while creating any trigger like with this syntax.CREATE TRIGGER <Trig_name> ON ALL SERVER FOR LOGON AS.......Error:Msg 1084, Level 15, State 1, Procedure Trig_Name, Line 3'LOGON' is an invalid event type.Couldn't find where I could venture to find the solution.Any help please |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
dbalearner
Constraint Violating Yak Guru
272 Posts |
Posted - 2010-08-17 : 17:31:52
|
| Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86) Oct 14 2005 00:33:37 Copyright (c) 1988-2005 Microsoft Corporation Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 2)Thanks Any further clues please. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
dbalearner
Constraint Violating Yak Guru
272 Posts |
Posted - 2010-08-18 : 18:43:37
|
| Thanks for that, however, if you look further into the URL posted it gave us enough evidence for what would be the criteria for my long standing question (Which remains question, till otherday) as the Maintenance Plans will differ with the DATES FORMAT with the lower Service packs, and is proved. I got 1 Shot 2 birds - Thanks |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
|
|
TRIGGER Creation