1) In the master database the column type may be correct (varbinary).

2) You are converting to varchar. You should convert to varbinary.

BTW master database should not be used to store...

Yes, it is listed in the BOL.

sp_unbinddefault

alter table

sp_binddefault

Don't call the job. Schedule it to run at required interval.

See the BOL to know more about sp_send_dbmail....

if that job is expired in 7 days so we have to send an email alert to those employer from 7 days onwards,

for this i need a trigger.

how to write...

Do you have any triggers?

If @@IDENTITY is used, replace it with SCOPE_IDENTITY()

Is it self blocking? If yes, ignore it.

Schema can be used for this.

Following query shows whether SNAPSHOT is enabled or not:

select [name], is_read_committed_snapshot_on, snapshot_isolation_state, snapshot_isolation_state_desc

from sys.databases

where [name] = 'AdventureWorks'

You have to created an operator first.

It is very easy to create an operator.

Expand "SQL Server Agent". Right...

5GB is not that big.

It is recommended to keep .mdf and .ldf on separate drives.

Thanks Michael

USE master

GO

RESTORE DATABASE DatabaseName

FROM DISK = 'D:\BackupFileName.BAK'

SELECT @@SERVERNAME

BOL:

ALTER INDEX REORGANIZE statement is always performed online. This means long-term blocking table locks are not held and queries or updates to the underlying table can continue during the ALTER...