Checkout for the network bancwidth also.

Run the DBCC CHECKDB with repair option to get rid of those errors.

Second that.

You need to send mails using xp_sendmail option.

Please refer to the link

http://technet.microsoft.com/en-us/library/ms365356.aspx

CREATE PROC grants as

declare curse cursor for select name from sysobjects where type='P'

OPEN CURSE

declare @proc varchar(100)

declare @stmt nvarchar(200)

fetch next from curse into @proc

while @@fetch_status=0

begin

set @stmt='grant execute on '+@proc+' to...

You can use many methodologies

1. run sp_who to find longer running processes and blocking

2. sp_lock to find locks in the server

3. use SQL profiler to trace sql performance problems

4. use...

Public is a database role. When you add a login you add that to the sql server instance. you can map it to the public role when you add the...

The database is less than a GB and only with 2 users and some transaction. You can handle this efficiently with a 2GB memory with 1GB for OS and other...

You get the same answer. What exact is your need if you can tell me i can think of other possible solutions if i have any.

Yes thats right Henri. I was just telling you an additional solution that was possible. Moreover you can write to the log and send them in the mail step which...

How many databasea are there and what are thier sizes. If you have limited number of DBs smaller in size do a snapshot replication. Why don't you go for log...

Are you using script to do this or the GUI. Can you post the script if you are using 1. The database as such will not go in read-only mode...

Do you have remote connections turned on in the server.

You can run from a client machine also. but you have to run against the server where the trace was taken from.