Please check log of maintenance plan or the Job.

It may happen that SQL Server agent was not running and Backup did not happen. Or becuase of some issues like...

identify all process ID's from sysprocess table of the particular user.

Kill all processes one by one.. write some logic with loops.

and then drop the login.

🙂

Use import/export wizard.

Also you can save it as a SSIS package and re-use it.

is there any issue in creating indexed views?

Why are u using copy database wizard?

Please explain.

This trigger is fine. It should send the mail for each insert statement. In SQL Server trigger is fired at statement level.

If number of rows afftected(in update or delete...

This is really wonderful finding

Recommend you to change the code to

declare @send_email_flag char(1)

set @send_email_flag='1'

select nullif(@send_email_flag, '')

go

declare @send_email_flag char(1)

set @send_email_flag='0'

select nullif(@send_email_flag, '')

go

--or

declare @send_email_flag smallint

set @send_email_flag=1

select...

If your requirement is to send out the mail for every insert/update/delete it may slow down your application performance if number of transactions are high.

If number of transactions to this...

Why are running so short of disk space?

If you have critical application, Recommend you to have proper disk space allocated as per the requirement to avoid such kind of...

Its right. Also you are refer to the Help that comes with SQL Server upgrade advisor, which gives more information.

Hi Ananda,

If you are using 2008, please refer to below info-

Central Management Servers

SQL Server 2008 introduces a new method of administering multiple servers by enabling you to designate Central...

R u not able to change the server settings from trusted mode to mixed mode?

General answer-

SQL jobs run under the context of logon account with which SQL Server angent is running.

.

if it is not parameter sniffing then it could be application which is taking more time to display or render the results and execution time at database is just 1...