Nice Article.

Welcome........

Also the data type of the primary key and the foreign key column

should be the same.

Cheers,

Satnam

Hello,

Where is the column named Artist_ID in the table Band?

Your script is:

alter table Band add Constraint fk_Band Foreign key(Artist_ID) references Artist(Artist_ID)

The column name specified as foreign key should be...

I could not see any script which creates the foreign key.

Cheers,

Satnam

If you had defined the check constraint before executing the insert statement then it would have worked fine.

The problem is in check constraint you are specifying a condition that the...

Nice article and Very well explained...

Cheers,

Satnam

Fantastic....

On Job Failure, run the following script against the master database.

exec master..xp_smtp_sendmail

@from=N'Email address from where the message is sent',

@to =N'Email address to whom the message needs to be sent',

@subject...

Simple and nice to understand.

Excellent Article Divya.....

Satnam

Yes Ritesh, i implemented it,it was fantastic.I loved the idea and the entire presentation which i believe only a good DBA can do...........................

Fantastic article Ritesh, You are a star DBA............

A few days back i wrote the below trigger to send an email whenever any record gets inserted,update,deleted in a table.You can modify it as per your requirements, hope it...

Consider an example wherein i have to delete a backup file older than 2 days.I have a database named example whose backup is happening in D drive.The backup file name...