Tracking Table Changes On SQL Server Ce Without Using RDA?

Feb 24, 2007

Hi,

Can anybody let me know if there are ways to programatically track changes made to a SQL SERVER CE table? I am writing a db monitoring tool on SQL server CE which should track any changes made to the table.(Insert update and delete)

We could have done this using triggers on Sql Server 2005. Since triggers are not supported on SQL Server CE, are there any alternate ways to achieve this functionality?

Regards,

Ananth

View 1 Replies

SQL Server 2008 :: Change Tracking On Table?

Jun 8, 2015

best way to track changes for a very pesky table.We pull down a table from an Oracle database (via linked server) into our SQL Server on a daily basis. The data in this table is just truncated and reloaded daily. There is no "history" kept in the oracle database and values are not being "updated" its just dropped and repopulated.

So, I have toyed around with CDC and even creating my own custom auditing method but I can't come up with a reasonable solution that doesn't involve a massive audit table that doesn't provide much useful info.

For example, there are two date fields in the table that my customer wishes to have history tracked for. Every day, this table is truncated and reloaded - however those dates may stay the same for many many many months. If I turn on CDC, I will get tons of audit records for a delete and an insert every day but the values for the two date fields may not have even changed.

The table has tons of fields in it but I only care about the 2 date fields for history purposes.Here is a snippet of the table (I took out all the additional fields in the table and just left the two date fields that need to be tracked):

CREATE TABLE [dbo].[Fake_Name](
[lin] [char](6) NOT NULL,
[boip_no] [char](6) NOT NULL,
[dt_tc] [varchar](25) NULL,

[Code] .....

method to track changes to this table with it being truncated every day?

View 1 Replies View Related

I/O Tracking For A Sql Table?

Jun 16, 2004

I'm looking for a way to monitor I/O(select, delete, & updates) to a particular SQL Table for a period of time. Any suggestions?

View 3 Replies View Related

Tracking All Table Modifcations

Apr 26, 2004

I am looking for an efficient way to track all modications to a a database. I have come up with a few ideas but none are very efficient.

View 6 Replies View Related

How Can We Do Row Based Table Tracking

Nov 2, 2007

hi there,
how to retrieve a specific Row from a table based on its row number???

Example:
Select [2nd Row] from TAB001 in SQL Server2000.

regards,
Nilotpal

View 5 Replies View Related

RDA Tracking - No Primary Key On Table

Apr 18, 2007

Hello,

Can a table be tracked if it does not have a primary key? I am using rda.Pull method in VS2005 using C#. If not, what are my options? Any help is appreciated.

Thanks.

View 1 Replies View Related

RDA - Multi Table Error For Tracking

Apr 18, 2007

Hello,

I receive an error message when I try to Push data that the table is not tracked. However, when I try to turn on the tracking option it gives me an error that the table is a multi query table and therefore cannot be tracked. Here is my code to Pull the table.

string TPDAPull = string.Format("SELECT Table1.Field1,Table1.Field2, Table1.Field3, Table1.Field4, from Table1 Left Join Table2 on Table1.Field1 =Table2.Field1 WHERE Table2.Field12='{0}'", this.FindWorker(var));

rda.Pull("Table1", TPDAPull, rdaOleDbConnectString, RdaTrackOption.TrackingOn);

This table does not have a primary key. I was wondering what can I do in this situation? I do not want to Pull the whole table. Any suggestions would be greatly appreciated. I am working in VS 2005, NCF2.0, C#, WM5.0.

Thanks in advance!

View 6 Replies View Related

Tracking Member Views Of Clan Pages (was Table Design Help Needed)

Feb 28, 2005

I am helping a friend with a gamming website. There are pages which displays data from other clans.

Members need to register and login to view full clan details. User who have not logged in can only view partial data about a clan.

I need to keep track of the kind of hits each page received. That is I want to tell say "Clan X" that these particular members viewed your page these many times and on these dates and these members who have not registered have viewed your page these many times and on these dates.

I am using ASP with MS SQL.

I would like some help on designing the table layout that is efficient for keeping track of the visitors for each page.

Any help will be appreciated.

View 14 Replies View Related

Tracking Changes In SQL Server 2005

May 12, 2008

Hi there,

Is there a way in SQL Server to track changes that were made to a stored procedure. See when it was modified and what changes were made?

I'm trying to chase the history of one stored procedure that was changed and affected a live system from running correctly.

Thanks in advance!!!!

S

View 2 Replies View Related

Change Tracking For SQL Server

Jul 20, 2005

Has anyone come across a change tracking tool for SQL Server. Specificallythe scenario I want is the following :A Production DB needs some modifications to its content.This tool will copy the DB to a dev environment.The Dev environment will be 2 copies of the DB, 1 as a control set and theother the change DB.The developer makes their changes in the Change DB. They test them out andthen when they decide the changes are ready to pushto production they hitthe "go" button on the tool.The tool calculates the delta between the Control and the Change DB and thenpushes the changes to producitonAny ideasThankss

View 2 Replies View Related

Tracking Changes To A SQL Server Database During Development

Apr 24, 2008

I am running both SQL Server 2000 and SQL Server 2005.

Lets say I have a live database that is version 1 for an application. The database is copied onto a development machine to develop version 2 of the application. I want to be able to take a snapshot of the database and then get a program to write all the changes made after the snapshot into sql code. This is so I can run this sql code on the live database and transform version 1 to version 2.

Is there any program/tool that will allow me to do this?

Jagdip

View 4 Replies View Related

Tracking Schema Changes In SQL Server 2005 Db

Jul 11, 2006

I wonder how can I track the changes in the columns whether added, deleted or their name is changed and how can I test that?

your help is appreciated

View 9 Replies View Related

SQL Server 2000: Tracking Down Source Of Failed Logins

Oct 4, 2006

I was checking the logs because of some failing backups and found literally hundreds of enties for failed logins for user sa. This is does not seem to be related to the failed backups, because even after fixing the problem (disk space), the entries continue to pile up.

Needless to say, the information provided in the log is a bit sparse: date and time, source (Login), message (Login failed for user 'sa'.). If that is actually enough to go on, then there must be some way of cross-referencing this information with that found somewhere else. Is there a 'somewhere else' or are there other things I need to do in order to track this down?

I don't suspect any malicious intent, but I'm not ruling it out. My main concern at this point is twofold: to gain a better understanding of system management; to identify and correct the failed login.

Any recommendations, whether tools, documentation, or otherwise are very much appreciated.

Ron.

View 1 Replies View Related

Tracking Changes

Sep 26, 2003

Please Help.

How do you track changes to objects in SQL Server.
For example changes in stored procedure,views and indexes. What system table or column track or indicate changes in text of sp or views.
Help appreciated.

Regards

View 6 Replies View Related

Tracking Who Is Doing What?

Aug 9, 2006

We are building an inventory management system complete with BOM. It is important to track what employee is updating what tables. Currently all such tables have a Date field that is updated when a change is made, and an EmployeeID field which records the employee making the change. I am wondering if someone knows of a better way to track this information. Any suggestions?

View 2 Replies View Related

Tracking

Aug 26, 2004

Hi,

I am trying to create a tracking spreadsheet for my SQL Servers in order to keep track of every thing.

Here is a example of what I have:

DateTracking IDServerIssuesSolution

8/26/20046760FORMSCAPEDOCSBackup failSwitch Transaction logs to the D: and left the database backup on the E:

Should I be more detailed and add some more fields and if yes can you recommend some.

Thanks

View 2 Replies View Related

SQL Tracking

Mar 6, 2006

I have an application that uses SQL server. Is there a way to find out what SQL statements the application is passing to the SQL server?

I would like to know all kinds of activities going on in the background of the application. I am sure there is a way.

Thanks in advance.

View 11 Replies View Related

Tracking

Jul 20, 2005

OK. For DDL, please refer to the classical Northwind ORDERS table,problem/challenge, find the longest duration (start_date andend_date), during which, no orders were placed.FYI, column names by the order of colid per syscolumns:OrderIDCustomerIDEmployeeIDOrderDateRequiredDateShippedDateShipViaFreightShipNameShipAddressShipCityShipRegionShipPostalCodeShipCountryAny idea/approach? TIA.

View 1 Replies View Related

CDC Not Tracking Changes

Sep 5, 2007

Hi
I'm trying to get CDC going, it works however when i query the LSN using the functions i get no changes. The min and max LSN returns null. SQL agent is running, db is on full recovery model etc.

any ideas ?

thanks

View 4 Replies View Related

Sp Tracking.

Dec 19, 2007

Yesterday I had problem with that a sp that contained join that the developer had forgotten the where part. The sp join very large tables and sp took more 95% dual itanium processor. How do fastest track this down when it accrues. Find the sp or sql that running and consume this much processor resources. I tried with a lot. Sp_who, sp_who2, activity monitor.

View 5 Replies View Related

Tracking Old New Values

Mar 7, 2006

im trying to create a procedure that will insert/update a small table
that has an ID, AmtBefore & AmtAfter.

this is just a table that i'd be using to monitor other activity on the database.

i'm really pulling a price + ID every hour and i need to track that somehow and know when the procedure runs if a price is lower than it was the last hour, plus of course keep the ID's straight.
does anyone have a good approach to something like this?

thanks for any help on this
rik

View 2 Replies View Related

Tracking Who Is Changing What?

Aug 9, 2006

View 4 Replies View Related

Tracking The History Of Changes.

Oct 19, 2007

Hi,

I have a bit of a problem I could do with some help with please...

I am updating an old windows client server app that uses ADO 2.8. Slowly but surely I am migrating the code from VB6 to .NET and this now means the ADO code is going to be replaced with ADO.NET.

As it is a client server the application used to establish an ADO connection and hold on to the connection for the entire duration of the app being alive. When a user signed in it would record the user logon code in a database table along with the current @@SPID value.

When the user does something in the application it typically usees an SP to do the database work. Inside the SP it also audits the work being carried out, of course the audit trail records the user id that did the work. The way it determines who called this SP is to query the logon table using the current @@SPID to get the users logon code (remember this was paired up when the user signed in).

This all worked very nicely as only one connection was ever being used and it was always the same connection that was used. However, when I come to use ADO.NET this is no longer valid. I want to use the connection pool and follow the best practices where my connections are always obtained as late as possible and released as soon as possible.

This leave me with the problem of how to get the current users logon code in to the SPs in order for them to continue writing the audit trail. Currently I am thinking that I am going to have to send the users code in to the SP as a parameter, I just wondered if there was an alternative.

Any help would be great.

Regards

Graham

View 3 Replies View Related