SQL server script

Dear Sir, Please assign this task for me I'll do the job with lowest rate with 100% completion of the Job I'm very much familiar with MS SQL Server ( SSIS SSAS SSRS) and also during last five years I involved many project in ETL, data warehousing, BI reporting and six years of application development experience. I would highly appreciate if you assign this job to me and also I'm Microsoft Certified Technology Specialist (MCTS) for Microsoft SQL Server 2008 for Business Intelligence Development and Maintenance & Microsoft Office SharePoint Server Application Development. Please reply me for further details Best Regards, Jinesh

Hi, I have 10+ years of experience in SQL Server development. I can accomplish this task quickly. Please let me know if you want to move forward. Regards, Farooq

Hi, I have gone through your requirements .I am a DBA at CMMI-5 Level company since August 2006.I am working on MySql,MSSQL Server,Oracle database, I can do your job confidently. I am very much Interested to do your work,Please revert me if you have any concern .I am ready to start now

Hi. I am expert in mssql db development .

Hi, I can help you with this trigger as you have explained. fyi, if we use raiserror then the info would be printed on the terminal as well. would you be ok with this or you would the info to be printed only in errorlog info in errorlog would be something like as given below: --2014-09-10 18:07:20.80 spid52 ddltrig_ddltables: user:dbo eventtype:CREATE_TABLE --2014-09-10 18:08:11.88 spid52 ddltrig_ddltables: user:dbo eventtype:DROP_TABLE if you want entire ddl command can also be printed in errorlog but there is limit in number of characters that can be printed in a single message improved message in errorlog could be as follows: 2014-09-10 18:39:13.90 spid52 ddltrig_ddltables: eventtype:CREATE_TABLE database:testdb schema:dbo user:dbo object:mytable 2014-09-10 18:39:33.36 spid52 ddltrig_ddltables: eventtype:DROP_TABLE database:testdb schema:dbo user:dbo object:mytable hope to hear from you regards Babu

I have experience in this area and already coded something similar. I can sent you a POC if required to have a look/check before selecting a bider.

CREATE TRIGGER trg_log ON DATABASE FOR CREATE_TABLE, ALTER_TABLE, DROP_TABLE AS declare @s nvarchar(max) SELECT @s=EVENTDATA().value('(/EVENT_INSTANCE/TSQLCommand/CommandText)[1]', 'nvarchar(max)'); RAISERROR ('log:%s', 16, 1 ,@s);

A proposal has not yet been provided

Hello, I can create a trigger to log in the text file not use RAISERROR. If you agree, please accept my bid. Best regards, Hoang Minh

A proposal has not yet been provided

Hello! My name is Kimberly Killian of SiteDataView. I'm a SQL Server DBA/Developer with over 20 years experience in the field of IT and 12 as a DBA. I'm located in Metro Detroit in the Eastern time zone. I can put together a monitoring database to capture the information you are looking for.

I welcome. I already created the similar script earlier. I can write error log to log file or to other table.

Professional people do professional thing, as a professional person, I can give you the answer is the ideal service and perfect quality.

I have much experience in SQL and I already created a Framework which capture each DDL change in SQL table with Schema of Table/SP/View/Function with timestamp

I have an overall experience of 12+ years in SQL Server and MS Technologies ..Experience as SQL Server programmer

Hello, I'm a software developer for almost 1 year and 6months. My primary role is Develop, maintain and enhance stored procedures and triggers to improve database performance. I use Microsoft SQL Server 2005, 2008 and 2012. I already made several triggers so I can assure you that I'm good with this. Thanks!

• 6+ years of DBA experience involving data requirements, classification, logical & physical data model creation • Analytical and results driven Senior DBA with long term experience in engineering, implementing, supporting disaster recovery, high availability plans and solutions based on MSSQL software. • Resourceful individual with problem solving capabilities, excellent communication and team leadership skills • Project management and One of the SPOC for delivery with client more than 5 Years • All aspects of SQL Server 2000/2005/2008/2012 DBA including planning, installation, configuration, backup, recovery, security, data manipulation, SSIS,SSRS,DTS and disaster recovery (3rd level support). • SME on Replication, Clustering, SSIS and Performance tuning of SQL environments. • Cluster administration, Storage planning and data movement are key expertise area in SQL Environments. • Worked on High transactional environments and successfully completed upgrades/migrations for low downtime through all different versions of SQL server. • I have fairly well knowledge of few front end languages like C#.Net, VB, C++, C and Java. • Programming Languages: SQL, Shell scripting, • 8+ years of experience with Windows Operating systems/Active Directories Services. • 6+ years of experience in DB Replication, Log shipping, backup Recovery, DB design and mirroring solutions. • 6+ years of experience in handling large and high volume transactional SQL DB servers & SSIS packages (DTS) • 5

2,5 year experience with SQL Server. Worked with: DML statements; stored procedures, functions, triggers, table indexing, table partitioning, backup/restore maintenance plans. Developed db schema for various intern project in the company where i work.

- Over 15 years of expierence in SQL Server development and administration - Developer in major swiss based companies in the financial services area creating similar processes for administration - Sorry, no degree to present - but 100% in depth expirience in real life - can start immediatily working on it

I have the trigger 90% already written, The modifications that I will have to do to my current trigger are, Implement RaiseError, instead of logging to a table. that's it, You can have it tonight I use this trigger in our development and qa enviroments to keep track of my developers changes, It makes my life easier.