Thanks Everyone for your reply and time.

I am aware about SSMS 2008 features but I am looking forward to make it automatic so that once a week the table is...

Hi Chris,

Current version is Microsoft SQL Server 2005 - 9.00.4262.00 (X64)

Enterprise Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 2)

Cheers,

Thanks guys,

Sorry for late reply as it seems like we are in different timezone.

@Barry

The problem why we can't use windows credential is that the way application connect to SQL backend...

Thanks guys,

Sorry for late reply as it seems like we are in different time zone.

@skybvi

yes I checked SQLAGent have access to backup directory.

There is no detail in maintenence...

Thanks for quick Craig,

How can we ensure that user is trying to reset his own password and not some one else ?

Is there anyway we can verify user before allow...

Thanks for reply guys,

Yes I am aware about that and I entered bak and dif without dot.

Thanks Bhuvnesh and Gila,

I know that but here my idea is to make sure the table doesn't have frequent insert \update before I create an Index. If table data...

Hi Rateesh,

I am on SQL 2005 Ent edition with SP3.

Hi Gail,

I am not sure weather trigger is good idea or not as my aim is to find number of updates...

I think Pradeep is right.

His script will not create backup at default location.

Read this QotD

http://www.sqlservercentral.com/Questions/Tags/Backup/Backup/

and related discussion will clear all your confusion.

Create database level DDL trigger to track when the permission is changed and who did it.

try this.

EXEC sp_attach_single_file_db @dbname = '', --- your database name

@physname = '' --- the location of the .mdf file