>> 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.

It is possible.

delete from TableName where ColumnName < getdate() - 31

>> to prevent users from entering whatever they like for an email address.

It is better to do this validation in the front end.

In my openion, second one is better. The key word 'AS' serves as a hint. It is easy to guess that mycolumnname is an alias.

1) Add linked server

2) SELECT column_list FROM Server.Database.Schema.Table

Why is your client changing from DAS to SAN?

Is it for clustering?

Do you mean softcopy (PDF) in the Net?

I suggest you to purchase the hardcopy (book). It will be convenient to read. You can underline the points that are usefull to...

Use Surface Area Configuration to enable remote connections.

1) If you use .BAK extension, you can configure Database Maintenance Plan to delete older backup files.

2) File name extension should not affect the file content. The parameters will determin...

nchar,nvarchar, and ntext are unicode data types.

They are used to support multiple languages.

Storage size is double of normal data types.

Use sp_changedbowner to set the database ower name.

Suresh

If you are storing the date and time of insertion in a column, you can use following query:

select * from TableName where ColumnName >= dateadd(mi, -30, getdate())