I presume your memory allocation is set to "Dynamic".

If the box is dedicated to SQL Server, then don't worry about it.

With memory allocation set to "Dynamic", if the OS...

select object_name(437576597)

A primary key is nothing to do with performance, it is about uniquely identifying a row in your table.

If you don't create a primary key on your regions table, what...

Why do you want to rewrite it?

Is it slow?

Doesn't it work?

You need to add the OUTPUT keyword to the @out_ClientId parameter when you are calling the stored procedure.

Device type 7 is a virtual device.

Are you doing other backups (as well as via a maintenance plan) using 3rd party tools e.g. Veritas Backup Exec?

IF EXISTS (select * from Emp) print 'exists'.

This only needs to verify that a row exists in the table, and should only do a single I/O, regardless of how many...

Data, log and backup can all reside on the same drive.

Is is wise? NO!!!

If you lose the drive, you have lost your data AND your backups

Ideally, 3 separate...

That query should work... are you using any 3rd party tools to run the backup?

A couple more thoughts...

Are you sure the trigger doesn't fire?

Just add a print statement to the top of the trigger to confirm whether or not it fires.

Does your Table B...

Do you have the server property "nested triggers" set?

Run sp_configure and see if this is set to 1.

You are not qualifying the "and not exists..." part of the query.

I presume it should be something along the lines of:-

and not exists (select * from products where product.productid...

Just be aware that if you have any triggers on the table you are deleting from, that SET ROWCOUNT will also affect the trigger.

This should give you what you need:-

select icompanyid,name,

case when c.phonetype = 417 then c.phonenumber

else p417.phonenumber end...

I think you need to look at your view.

I've created tables and test data with your scenario, and everything works!