Completed

P0713 - create a trigger in an SQL-Server database

The target of this job is to create a trigger in the an SQl-Server database. The trigger should log changes in the database

The final result has these features

1 Once per week: Kill all Log data older than 2 Years

2 Log "NEW" record

3 Log "CHANGED" records

4 Log "DELETED" records

See attached PDF.

Greetings

Rainer

Skills: Microsoft SQL Server, SQL

See more: sql server instead of trigger, sql database trigger example, database triggers, before trigger sql server, trigger in sql server w3schools, sql server trigger types, sql server trigger, sql server create or replace trigger, ping sql server database, sql server database java servlet, converting access sql server database, net client code connect sql server database, automatic backup sql server database, convert sql server database access database, pdf files sql server database, save images sql server database telerik, update sql server database csv file, sql server database gatepass, sql server database manipulation using macro, joomla sql server database

About the Employer:
( 12 reviews ) Filderstadt, Germany

Project ID: #20303190

Awarded to:

NoSonforhim

Hello, I read your project description and understand all(about create Trigger). I have rich experience in Ms. Sqlserver Developing and Administration I will make the perfect product what you want. I promise to compl More

€75 EUR in 3 days
(3 Reviews)
2.3

19 freelancers are bidding on average €127 for this job

sumon355

Hello, As an expert in ms sql server, i am very much interested to do create the required trigger. I checked the attached document and i understand the requirements. Looking forward to have a positive response. Tha More

€150 EUR in 3 days
(255 Reviews)
7.6
codetod

Hi I am a database expert with 12 years experience in handling MS SQL and MySQL databases. I have worked as DBA for large ERP databases and use to write and do performance tuning for SQL queries, procedures and trigge More

€120 EUR in 4 days
(77 Reviews)
6.4
xutao650

Hi I can help to create the triggers on sql server. I am a software engineer with 8 years' experience. Please contact me for further discussion!

€100 EUR in 7 days
(17 Reviews)
5.0
digidreamstech

Hello, I have understood the project requirements and we can discuss further in more details. Thanks.

€135 EUR in 7 days
(21 Reviews)
5.5
sreenivas2903

hi I am expertise in sql server and writing queries triggers and procs . please let me know few more details to continue . ping me if you are interested

€140 EUR in 7 days
(17 Reviews)
4.3
marioada

Hello, Let me just get right into it. What we need here is actually 4 triggers and 1 event. The event will be executed once a week and it's the one that will be deleteing all Log data that's older than 2 years. The tr More

€200 EUR in 4 days
(1 Review)
4.0
aap31374

Myself Anil have more then 10 years of experience in SQL Server databse development and Administration. I have worked with big Databases for clients like match. Com, nationstar mortgage and with TCS. I am also good f More

€111 EUR in 1 day
(5 Reviews)
3.3
sangeethDeshal

Hi contact me ASAP

€30 EUR in 2 days
(1 Review)
3.3
huseyinaygun

Dear Sir/Madam, I have relational database design and development experience of 10 years. Recently I completed 5 Database Systems Course projects which cover: - Conceptual design (ER Diagram) - Creation of database More

€200 EUR in 5 days
(6 Reviews)
3.3
nidhi1509

Hi, I have 7+ years of experience working in Top IT companies as a Database Developer. I have read the PDF that you have attached with the requirement. I believe I would be able to create the trigger as required in More

€111 EUR in 5 days
(5 Reviews)
3.1
l0ginp

Hi,I've read your document . your need 2 table : - first table is standard table - second table for trigger from first table, copy all data from first table with process action (NEW, Change Before, Change After, DE More

€100 EUR in 2 days
(5 Reviews)
2.9
abdulmannan9

Hi there - This is Abdul Mannan and i can create trigger queries as described in the attached file as per your requirements, I am an expert in writing My-SQL Queries, no matter how much it is complex.

€200 EUR in 1 day
(1 Review)
1.4
thebartowski

Hello sir, I read your document and I can provide you your Microsoft SQL Server triggers to log manipulation of your data. Just send me a message and we can start immediately! Have a nice day.

€100 EUR in 4 days
(1 Review)
1.1
ibrahim20

hi, i am c# & database developer with 5 years of experience. have developed many application. have knowledge in database like mssql, oracle, postgrey., (store procedure, triggers, sql job scheduler, oracle/ postgrey pa More

€111 EUR in 5 days
(1 Review)
0.6
€155 EUR in 3 days
(0 Reviews)
0.0
afwallah100ayoub

A new freelancer with a good experience in sql and sql server(1 year) and i really like using triggers because of the huge time/effort they save me , i have no problem with working with a low price . Relevant Skills More

€155 EUR in 3 days
(0 Reviews)
0.0
nileshpadhiyar94

I have 1+ year of experience for creating Optimized stored Procedures,function,triggers,views. Looking forward to discuss with you in greater detail.

€111 EUR in 2 days
(0 Reviews)
0.0
christianvillagr

I am a sql developer with almost 9 years of experience in SQL objects. Triggers, Procedures, functions, etc.

€111 EUR in 3 days
(0 Reviews)
0.0