You can find the reason here for why you get "No Targets Found"

http://msdn.microsoft.com/en-us/library/bb510458(v=sql.100).aspx

The SQL Server Audit mechanism is built on Extended Events which are much more light-weight than SQL Trace so there should be no noticeable impact.

Yes I have SQL Server audit enabled with some defined audits on all of our SQL 2008 Enterprise servers. I found a couple of things... a setting needs to be...

I suspect that it is your join that is causing this. Can you supply the query that you are using?

Hello,

You can use the built-in Policy Based Management and import the Best Practice Policies from Microsoft and run that against your instance to se where you are failing against industry...

Hello,

You could query sys.dm_os_buffer_descriptors which returns information about all data pages currently in the buffer pool. this will give you an idea of how the pool is split up between...

Hello,

Depending on what you are trying to achieve but to selectively encrypt some columns you need to make them a varbinary data type and use the EncryptByKey and DecryptByKey...

sys.databases has a column called is_published for those databases that are enabled for replication.

I am having the same problem today and found numerous articles on the internet that point to the VMWare tools. Once these are removed this issue goes away. Try the...

cheers, thanks.

That's what I had too but it's the last bit where it's checking for rows that are not null that seems to take too long in a test I...

I'd say you think that about religion Brad, because most of the people you meet are Americans and they are religous people. I however are not either American nor religous.

Hi,

Do you want to apply the service pack to a clustered instance of SQL Server 2005 or to a standalone instance?

cheers.

hi,

As far as I remember SQL2000 jobs always runs under the context of the service account... usually you would make the agen and the server service accounts the same.

However, looking...

Hi all,

I do have two columns... but what I've given you is just the child column and I wanted to find the parent from that column and update the parent...

I moved from a 40hr week in New Zealand to a 50-55 hour week in Thailand.

I tell you that it's not productive... I'm getting really tired so think that the...