Welcome to
Sign in
|
Help
in
Diverse (forum)
Romanian Section (group)
(Entire Site)
Search
Home
Blogs
External Feeds
Forums
Photos
Downloads
About Us
»
Romanian Section
»
Diverse
»
Re: sql log, history
sql log, history
Last post 05-28-2009, 12:40 PM by
ggciubuc
. 3 replies.
Sort Posts:
Oldest to newest
Newest to oldest
Previous
Next
05-28-2009, 11:24 AM
7223
creieru
Joined on 11-24-2008
db_datawriter
sql log, history
Reply
Quote
Salut
m-ar interesa daca exista o chestie gen log sau history pentru operatiile pe tabele,
adik daca am modificat campul XXX in tabela YYYY
sa se inregistreaza cumva automat
fara sa pun eu cate un trigger pe fiecare tabela si sa fac salvare la mana unde vreau eu.
merci anticipat pt atentie
Report abuse
05-28-2009, 11:28 AM
7225
in reply to
7223
ignatandrei
Joined on 11-17-2006
Bucuresti
sysadmin
Re: sql log, history
Reply
Quote
sql server 2008 - cauta CDC - change data capture
Ignat Andrei
http://serviciipeweb.ro/iafblog
Report abuse
05-28-2009, 12:30 PM
7226
in reply to
7225
creieru
Joined on 11-24-2008
db_datawriter
Re: sql log, history
Reply
Quote
vad ca fiecare database are atasat un fisier de log....Mydatabase.ldf
nu pot extrage de aici informatii despre modificarile asupra tabelelor (insert rows, modified fields in rows etc.) ?
am incercat DBCC log (database_name)...nu prea ma ajuta
Report abuse
05-28-2009, 12:40 PM
7227
in reply to
7226
ggciubuc
Joined on 03-18-2006
Bucharest
sysadmin
Re: sql log, history
Reply
Quote
O discutie pe aceeasi tema
aici
Gheorghe Ciubuc,SQL Server Influencer, MCP(SQL 2000), MCTS (SQL Server 2005) , OCA(Oracle 9i), Sybase(Brainbench)
Report abuse