Hi, not trying to hijack this post, but I have a question I cannot seem to find the answer to.

When a user is a member of multiple AD groups, that...

I am getting a very large number (over 500 days - 49841633470 Ms) for my CPU time on a user database

in this code snippet:

My Server was rebooted less than 2...

Thanks for your pleasant reply.

The fact that the database engine was completly rewritten does give me a more relevant reason as to the differences betwen versions.

Hi,

there is no indices on table in either version. Would it pay to create a clustered index?

What I really wonder, is to why they results should be different, asd the...

yes, sorry, that's exactly what I mean.

I know I have one, definetly, but would like some sort of script to check all procedures and views.

Thnaks! - both work fine

thanks - it was supposed to be:

EXEC sp_trace_setstatus 1, 0;

but it looks like the only way for me to get what I want, would be to set the maxfilesize to be...

EXEC sp_trace_setstatus 1, 2;

but I don't want to have to delete the trace, before I can read the ouput file - is there not a way to do this?

cheers

This is what I am running:

EXEC sp_trace_create 1 OUTPUT, 6, C:\Logs\SQLServer_Audit', 10;

EXEC sp_trace_setevent @traceid, 102, 1, @on;

EXEC sp_trace_setevent @traceid, 102, 10, @on;

EXEC sp_trace_setevent @traceid, 102, 11, @on;

EXEC sp_trace_setevent @traceid, 102,...