I stopped the agent, deleted all the sqlagent.* files (except for .out) and restarted the agent and everything looks good at this time.

Thank you.

add your users to the db_owner role...

I tried a lot of different combinations, but haven't been able to figure this one out as yet. I have pasted the code below. The trace starts, file is created...

Mohammed,

Is this behaviour different from SQL 2000? The traces I have work with SQL 2000.

This is what am trying to do...

sp_trace_setfilter @TraceID, 38, 1, 6,  sysadmin

For SQL 2000 this is filter all sysadmin acccount activity. But this is not working for SQL 2005.

I got this information in msdb..sp_set_sqlagent_properties

Yes, I'm connected as the same user. Moreover, when I click New Query it opens a new window and then shows me the database name in the drop down list.

But in...

I refreshed as well

Yes, I re-connected to the server in SSMS but still can't see that database.

Any other suggestions.

This would definitely include increase the size of the logs

This is what I googled, to rebuild a clustered index, there should be 1.25 x (table size) available on the disk.

Can anyone validate this?

TIA

The database is in Simple recovery mode.

Is a copy of the index or table created during the dbreindex process?

I have the following setup:

DB Size 3.8TB - 2 Datafiles In Primary File Group - (DF1 - 2.20 TB / DF2 - 1.6TB) Free Space on DF1 400GB & DF2 300GB

TBL1...

In SQL 2005, you can also rename the 'sa' account. So if you renamed it to, say 'ss2k5guru', and someone tried to login as 'sa' they would receive the error...

Are you talking about Auditing Login. You can set that at the server level. Look for auditing logins on SQL Server