Thanks!

Now I have another question. This one is probably considered by many obvious but the truth is that I’m not sure and my work depends on it so if many...

Yes, when I read your replay I realized that that might be the issue. Didn't the SP3 had some issues of slowing down the server or something? I kind of...

My version info is:

Microsoft SQL Server 2005 - 9.00.3042.00 (Intel X86) Feb 9 2007 22:47:07 Copyright (c) 1988-2005 Microsoft Corporation Enterprise Edition on Windows...

The Task Setup is:

1) First I chek the DB integrity,

2) then Update Statistics,

3) Full Backup of the DBs,

4) Cleanup of the past backup files

5) Transaction log Backup(so...

Thanks dude!

Cool, I'll try it... If I find the time!!! I'll let you know when I do it.

Thanks a lot for the help!

Hi! Thanks for the help!

For what I see this query doest makes the indexes it only suggest it right?

Yes, Im trying to make some time to make some time to see what can I come up with. For I became the DBA for the company with like 30...

thanks! I che it out.

I used the query for a server on SQL Serv 2005 and until now its been greate but teh server that I whant to verify is in 2000.

Is it possible...

OK... Let me see if I understud the query.

It makes a table that gets populated with the info of the user when the triger gets executed?

Should I worry about performance...

Interesting, I'll try it. Thanks!

whow! Why its so dramatic the change?

I was trying to avoid doing that... but it seems that it's going to be the hard way. The sad part is that there are to many users that I...

What other 3rd party application you know of doing this kind of job (for the feautre)?