CREATE TRIGGER trg_Insert

ON TableName

AFTER INSERT

AS

BEGIN

DECLARE @EmailTo VARCHAR(255)

SELECT @EmailTo = Inserted.EmailTo FROM Inserted

EXEC @EmailTo

END

try it by using below script..

USE [TEMP]

GO

IF NOT EXISTS (SELECT 1 FROM sys.schemas WHERE name = N'lsrSchema')

BEGIN

PRINT 'test Print'

CREATE SCHEMA [lsrSchema] AUTHORIZATION [lsr]

END

GO

You have to create the database roles which sets the permission for users on objects.

Create one database role set the permissions using DENY / GRANT.

Mapp the user and database role...

For restoring log file in one shot you have to write the script which took the all the log files from the folder and restore it according to there dates...

It menas if i'll not take the full2 then I can restore the database in below sequece...

Full 1, Diff 4, Tran backups 11,12

correct?

You can migrate the data, but after migrating data just verify the database consistancy using DBCC CHECKDB command for new database in SQL Server 2005, check for the index fragmentation....

In this case instead of trncating the logfile if i'll shrink the log file what will happen?

You hva to specify the linked server name that you have create on either Server "A" or on Server "B".

SELECT * FROM

Check whether the any user is connected to database (including you) disconnect it. To chek active connection you can use queries provided by others( in above replies ) or...

You simply need to create the UPDATE trigger on Customer table which includes Insert statment for AuditCustomer, Inserts the record from inserted / deleted table ( inbuild table in database...

Gila,

Can we perform the restoration strategy this below manner..

1 Full say full1, full2

2 Differential say diff1, diff2, diff3....

3 Transaction say trn1, trn2....

When restoring the database.. Suppose u have already...

Can u just reply with what exact message you are getting when job fails and fails to send a mail.

Have you written any bulk logic within the stored procedure or getting the resultset from the table. There may be the chances of blocking / locking of tables also.

If bulk...

Can't we take it from registry settings using CLR ?

Are you running any job which uses xp_cmdshell ?

Regards,

Abhijit