Sorry for the delay.

Basically, the table-trigger is used to call master.sys.dm_exec_requests to find out which sql-statement has been used. This, with other info is inserted into an audit-table after an...

Tnx for your input all. This has been very helpful and educational.

How about you give them a batch script that they can schedule that extracts the data, encrypts, and then ftps. Low maintenance, easy to implement, no trust needed.

That would be...

Tnx for answering all. SOme answers for more info:

We have no control what-so-ever over the customer's databases, that is what is worrying me.

The log-shipping will be done once a day,...

You are right, not the Agent, but VSS Writer and Actiove Directory helper. My issue is with connection though.

Any1?

Functionality is indeed enhanced. I was referring to how to start the Activity Monitor. What was wrong with the previous way to start it? What kind of enhancement gives the...

The kind of replication: transactional. But I am interested in the whole replication spectrum. I find all kind of info bits on this subject, but I dunno if I forget...

Maybe you could use the ROW_NUMBER() function, something like this:

WITH ResultSet AS (

SELECT ROW_NUMBER() OVER (ORDER BY Column1 )

AS Row, Column1

FROM MyTable)

SELECT *

FROM ResultSet

WHERE Row between 200 and 300

Have a look at this article:

Dunno if this is what you're looking for.

There are several commercial products on the market for this, but I can't recommend 1 based...

I think you should look at sleeping processes, not users.

I wonder why you think sleeping processes are a problem? How do you measure that? And how many processes are we...

Hm, maybe I misunderstand what you mean: I have downloaded this managementpack(we have SCOM installed) but in the readable objects I cannot find a list with rules for SQL Server,...

General question:

I would like to check on the rules of MP for SQL Server for SCOM, but sofar I have not been able to find anything on this, not even...

Have a look here, you'll probly learn from this article:

http://www.sqlservercentral.com/articles/SSIS/67871/

Tnx for answering both.

The problems we have are being solved, that's not the issue. It's just that several times now I am told about this Oracle feature. Since I've never...

You have more issues, I think. For instance, is this the only file in the DIR you read it from, or is this the most recent file, 1 of several?

But...