Showing posts with label inserts. Show all posts
Showing posts with label inserts. Show all posts

Friday, March 30, 2012

Managed index in Fuzzy Lookup Error

If we run the package with fuzzy lookup without selecting the "manage index" option it runs great and select the data and inserts data within the table as expected.

If we run the sam package after selecting the option for "manage index" it gives error:

Error: 0xC0202009 at Data Flow Task, Composite Lookup [15209]: An OLE DB error has occurred. Error code: 0x80040E14.

An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80040E14 Description: "A .NET Framework error occurred during execution of user defined routine or aggregate 'sp_FuzzyLookupTableMaintenanceInstall':

OK this becasue there is a known issue in SQL server 2005 June CTP. Its not there in Sep CTP

Managed index in Fuzzy Lookup Error

If we run the package with fuzzy lookup without selecting the "manage index" option it runs great and select the data and inserts data within the table as expected.

If we run the sam package after selecting the option for "manage index" it gives error:

Error: 0xC0202009 at Data Flow Task, Composite Lookup [15209]: An OLE DB error has occurred. Error code: 0x80040E14.

An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80040E14 Description: "A .NET Framework error occurred during execution of user defined routine or aggregate 'sp_FuzzyLookupTableMaintenanceInstall':

OK this becasue there is a known issue in SQL server 2005 June CTP. Its not there in Sep CTP

Friday, March 23, 2012

Making a database auditable

Hi,
I’m doing a database project and I need to make it an auditable system. I
mean, I need to know "the time and the date" when a user inserts a record, o
r
modify it, or delete it in some tables.
I’m working with Visual Studio 2005 and SQL Server 2000.
Any idea about it '
TanksRobe,
How about SQL triggers? You are able to capture when a record is
inserted, updated, or deleted.
You could create another simple history table, that logged that
information for you...just write a few SQL triggers to populate it.
Reuben
Robe wrote:
> Hi,
> I'm doing a database project and I need to make it an auditable system. I
> mean, I need to know "the time and the date" when a user inserts a record,
or
> modify it, or delete it in some tables.
> I'm working with Visual Studio 2005 and SQL Server 2000.
> Any idea about it '
> Tanks|||I have a convention where any table thats holding business
transactions has these additional fields:
Created, CreatedBy, LastUpdated, LastUpdatedBy, blnDeleted
The stored procedures for Add , Update, Delete (Update) use the
variables GetDate() and SYSTEM_USER - thus taking the audit atsk away
from the client application.
I thought about using triggers and a history table, it can store many
more facts, but this works for what we need.
HTH
reuben.ahmed@.gmail.com wrote:
[vbcol=seagreen]
> Robe,
> How about SQL triggers? You are able to capture when a record is
> inserted, updated, or deleted.
> You could create another simple history table, that logged that
> information for you...just write a few SQL triggers to populate it.
> Reuben
> Robe wrote: