Use DATEADD function. For example:

select getdate(), dateadd(m, -25, getdate())

2008-06-23 10:03:11.3172006-05-23 10:03:11.317

http://support.microsoft.com/kb/942861

>>i can do that by running update query manually but when i run sp its not working pls help me

You mean following query is working. Right?

update testtbl set value='anj@test.com'...

Replace '31/05/2008' with '05/31/08'

>>Should I create these indexes during the schema creation or after the populations scripts?

Create indexes after pupulating the data.

Benefits:

1) Data population will be faster as there is no index update.

2)...

If you have difficulty in restoring the database using UI, use RESTORE command.

For example:

restore database NewDatabaseName

from disk = 'E:\Training_full.bak'

with move 'Training_Data' to 'E:\Training2_Data.mdf',

move 'Training_Log' to 'E:\Training2_Log.ldf'

CLR Integration Data Types ?

sp_start_job

We have alert for all the object (table, stored procedure, index, etc) changes.

>> Why do we name all constraints by the same name here?

Same name is not used for all the constraints. It is used for only for the first one...

Log is written sequentially. Therefore, multiple files will not improve performance.

You can go for it to resolve free disk space issue.

>> whether I should do first 70-441 or 70-443.

Do first the one which is easy to you.

BOL:

To run this stored procedure (sp_add_job), users must be a member of the sysadmin fixed server role, or be granted one of the following SQL Server Agent fixed database roles,...

Using Profiler, it is possible to get which user is calling which stored procedure from which host.

If you are using Windows Authentication for that user, password is to be changed in the Active Directory.