Thanks i added 8 of files for 8 CPU.

so i have tempdev 8

tempdev2 ...

Restarted the agent seems to be working great now thanks........did not think of the obvious one to start.

Yesterday and today i have same problem.

I can right click on the job and run this and the email fires off.

I do see a lot of activity threads of DatabaseMail90...

Let me see if i can rewrite this.

Im looking at changing the database default to use the new snapshot feature in SQL 2005

So that i do not get any blocks...

Thanks...

The statement

USE AdventureWorks

SET TRANSACTION ISOLATION LEVEL SNAPSHOT

I do not have to include this in every statement ?

Has anyone been running using snapshot mode and...

The script - could it be able to run on one server and then pick up all servers in network and then i could report on every server in the...

Hmmmm wish list ---- Wow i have many that i need to write.

Here is just one.........

SQL NT Accounts

Show database access, role security, tables access, select...

Thats a good script did not know you could call vbs scripts in SQL 2005.

Nice - thanks for sharing

I had some similar problem and this was caused by one stored procedure kept committing and was in a loop and it therefore keep adding to the log - the...

Is there a way to get this as Total Size and Free and in GIG and MG.

Thanks for checking.

-- delete the emails

DECLARE @delete_date datetime

SET @delete_date = dateadd(dd,-1,getdate())

print @delete_date

EXECUTE msdb.dbo.sysmail_delete_mailitems_sp @sent_before='Jun 2 2008 12:11PM'

-- this deletes the logs

EXECUTE msdb.dbo.sysmail_delete_log_sp

Which one will delete the SQL...

i had same problems with SQL 2005 to SQL 2000 after installing the Cumulative 6 update for SQL 2005 all linked problems were resolved.

You cannot even get to go to the query to run sp_who2 when this occurs.

Is there a way to run sp_who2 in sqlcmd without bringing up the gui and get...

No -- for me this is on our dev box and you just get a message waiting for internal operation to finish and then studio never comes up..so you can't...