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 |
|
reddymade
Posting Yak Master
165 Posts |
 Posted - 2006-08-16 : 16:40:08
|
| Could you please tell me how can i drop a trigger from query analyzertriggername is: insTAB_NetCN_logthe above trigger is under the table dbo.TAB_NetCNThank you very much for the information. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-08-16 : 16:42:16
|
| Did you even try searching in SQL Server Books Online? DROP TRIGGER...Tara Kizer |
 |
|
|
sqldba2k6
Posting Yak Master
176 Posts |
Posted - 2006-08-16 : 16:55:59
|
| IF EXISTS (SELECT name FROM sysobjects WHERE name = insTAB_NetCN_log' AND type = 'TR') DROP TRIGGER insTAB_NetCN_log |
|
|
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
Posted - 2006-08-17 : 10:50:35
|
| How about..IF DB_ID('insTAB_NetCN_log') IS NOT NULL DROP TRIGGER insTAB_NetCN_log------------------------I think, therefore I am - Rene Descartes |
|
|
|
|
|
|
How to drop a triiger via query analyser