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

Can be done using SELECT INTO

Example:

use pubs

go

select * into dbo.Trial from master.dbo.Trial

Copy the .LDF file also.

.MDF file is data file. LDF file is Log file.

GilaMonster (7/8/2008)

It is not normal to have 10 deadlocks a day...

Run DBCC UPDATEUSAGE.

BOL has following remarks:

In earlier versions of SQL Server, the values for the per-table and per-index row count and page counts can become incorrect. Under certain circumstances,...