Why get tables cleaned and copied in an SQL-Server DB?
0
votes
1
answer
59
views
I'm working on an SQL-Server database.
Regularly, entries from one table get moved to another one (from
entries
to Log_Entries
) in order not to flood the database. (The Log_Entries
get cleaned afterwards too)
I would like to know how this works, but I don't find any corresponding entry in the "Stored Procedures" or "Functions" and there seem not to be any "Database Triggers". Also the "Rules" part of the database seems to be empty.
Which entry in the database can be responsible for such a task?
**Edit after first comment**
I have "Database Diagrams", "Tables", "Views, "External Resources", "Programmability", "Service Broker", "Storage" and "Security".
Within "Programmability" there are "Stored Procedures", "Functions", "Database Triggers", "Assemblies", "Types", "Rules", "Defaults" and "Sequences".
Where is that SQL Agent?
Thanks in advance
Asked by Dominique
(609 rep)
Mar 17, 2022, 09:04 AM
Last activity: Mar 19, 2022, 01:28 PM
Last activity: Mar 19, 2022, 01:28 PM