I hope you can find your hacker using...

/*

DBA_FailedConnectionTracker: Maintain an overview of which connections are made to this SQLServer instance

-- This implementation user SQLServer Service Brocker with Event Notifications

*/

USE YourAuditDB;

if...

Check your sqlinstance errorlog, it may contain messages of your activation procedure !

Maybe these scripts can help you find the issue.

http://www.sqlservercentral.com/scripts/Maintenance+and+Management/31867/

Helical Johan (1/7/2011)

I have a job for generate a backup in the server A.

I must put the file in other server (B).

1. net use \\10.16.500.222\v3_bak\CC /user:domain\user ...

Create table #tmpRegValues ([Value] varchar(50), [Data] varchar(1000))

insert into #tmpRegValues

exec master..xp_instance_regenumvalues N'HKEY_LOCAL_MACHINE', N'SOFTWARE\Microsoft\MSSQLServer\MSSQLServer\Parameters'

Select @LogFolderName = substring(Data, 3,datalength(Data) - charindex('\',reverse(Data)) - 2)

from #tmpRegValues

where Data like '-e%'

no.

You need to test it for your configuration and situation.

But to comfort you a bit, they did already launch CU1 for SP4.

They did chose number of characters to be the third part of the substring function.

That's just a convention.

In the other case, there would also have been users complaining...

Space shuttle also has 5 on board computers.

Let me be number 5...

Based on your last info, I would say to fall back to full set comparisson:

This way you compare all columns of the rows of the set.

Keep in mind columns are...

Ah ... I should have known that :blush:

Indeed, Antwerp was a mess this morning. Slippery roads and unadapted driving style causing "fun" traffic jams all over the place 🙁

Regarding the pastries, I was aiming for the theme...

Koen (da-zero) (1/9/2011)

Tom.Thomson (1/9/2011)

?? :ermm:

Do you Americans work to 14th night instead of...

Keep in mind there may be non-related rows that have the same

Bedrag, Boekdatum and Omschrijving1, but belong to a different account.

SELECT Rekening

,...

Can you post the full DDL of your tables ? (object explorer \ rightclick on the table name and script table as create to ...)

This way we can...

What's are the primary key columns of the source table and which are the key columns you must use to make sure you are comparing the correct rows.

Once you figure...

just a subtle remark.

Make it a unique constraint ! That is implemented with a unique non-clustered index by sqlserver, but will result in everybody knowing it is a constraint and...