Hi,

Just curious. Are you able to execute xp_sendmail with outlook 2003 before this incident?

As far as I know, when you change the audit level setting via EM or windows registry, the changes will be taken place only after you perform:

a) server reboot

or

b) stop...

Have you tried to recreate the group from the O/S level (via Computer Management).

Hi,

I got confuse 😉

Let me know if I got your question right:

You perform backup for database A (db size = 700MB) via maintenance plan and the backup file (A_db_yyyymmddhhmn.BAK file)...

Every time you create the maintenance plan, it will generate a SQL job. Can you ensure the SQL job that is generated by your maintenance plan is having the following...

The alert was sent from 19 Oct'07 to 21 Oct'07. The disk space went down after 21 Oct'07, no more alert created.

I want to know what kind of activity has...

I'm sorry that I got your question wrongly. I thought your database size is 700GB and your backupfile size is 30GB.

What's is the option that you selected when you perform...

Hi,

Thanks for your advice and I'll take note the script, however I still can't find which database that I should monitor.

Almost all the databases are set to 'Auto Shrink'...

Are you trying to do full database backup or differential backup?

I don't have any maintenance jobs that run from 19 Oct'07 to 21 Oct'07.

I'll check the databases that are having 'Auto Shrink' option and check their database size on the...

You may want to do the following steps:

1) Stop the SQL services

2) Restore master database from the latest backup

3) Start the SQL services

4) sp_detach_db for all user databases

5) sp_attach_db for...

You can create trigger on the syscolumns while cleaning up or tighten up your access rights on your database server.

can you try to execute the following T-SQL statement:

select * from upload where RTRIM(people_code_id) ='P000008270'

what is the result?

select distinct p.first_name,p.last_name,p.people_code_id

from people as p

inner join peopletype as pt

on p.people_code_id=pt.people_code_id

where p.deceased_flag='n'

and pt.people_type='alum'

and not exists (select *

from Upload

where Upload.People_Code_Id = p.People_Code_Id

and upload.first_name=p.first_name

and upload.last_name=p.last_name)

order by last_name

The above statement...

select distinct p.first_name,p.last_name,p.people_code_id

from people as p

inner join peopletype as pt

on p.people_code_id=pt.people_code_id

left outer join upload as up

on p.people_code_id = up.people_code_id

where p.deceased_flag='n' and pt.people_type='alum'

and up.people_code_id is null

the left outer join...