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 |
|
venkath
Posting Yak Master
202 Posts |
 Posted - 2006-07-19 : 02:29:14
|
| Hi allIs there any way we can retrieve the dropped table..Thanks |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2006-07-19 : 02:55:08
|
restored your database from backup
KH |
 |
|
|
chiragkhabaria
Master Smack Fu Yak Hacker
1907 Posts |
Posted - 2006-07-19 : 03:07:09
|
| I was just wondering, can we have a triggers on the Database level, i.e. if any of the Table is dropped or Altered we can maitain in same table with the Transaction logs.I faced the problem last month, with one of the Clients in KSA, somehow 2 tables were dropped, and any one didnt know how it happened? So was justwondering is it possible???Chirag |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2006-07-19 : 03:14:20
|
"can we have a triggers on the Database level"I believe it is possible with 2005 but not 2000
KH |
|
|
|
chiragkhabaria
Master Smack Fu Yak Hacker
1907 Posts |
Posted - 2006-07-19 : 03:28:23
|
| Thanks TanChirag |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2006-07-19 : 03:36:02
|
from 2005 BOLquote:
Trigger on a CREATE, ALTER, DROP, GRANT, DENY, REVOKE, or UPDATE STATISTICS statement (DDL Trigger)CREATE TRIGGER trigger_name ON { ALL SERVER | DATABASE } [ WITH <ddl_trigger_option> [ ,...n ] ]{ FOR | AFTER } { event_type | event_group } [ ,...n ]AS { sql_statement [ ; ] [ ...n ] | EXTERNAL NAME < method specifier > [ ; ] }
KH |
|
|
|
chiragkhabaria
Master Smack Fu Yak Hacker
1907 Posts |
Posted - 2006-07-19 : 03:56:07
|
| Aha Thanks Tan, but i guess to upgrade to 2005, our company will take another 2-3 years :), so i can use this functionality that time.Chirag |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2006-07-19 : 04:06:15
|
quote:
Originally posted by chiragkhabaria
Aha Thanks Tan, but i guess to upgrade to 2005, our company will take another 2-3 years :), so i can use this functionality that time.Chirag
Me too. I have SQL 2005 installed for months now and never had a opportunity to really use it. 
KH |
|
|
|
|
|
|
|
|
can i retrieve the dropped table