Standard:

User license: 36,500 rs approx

Processor license: 2.33 lac approx

Enterprise:

User License: Rs. 3.5 lac approx

Processor license: Rs. 9.75 lac approx

device based CAL :Rs 7,200

User CAL: Rs 7,200

These are without s/w...

Here is the output of the query for configuration.

AccountRetryAttempts 1 Number of retry attempts for a mail server...

I already tried that.

The results are incorrect. The filegroups are left out if the database has multiple filegroups.

I need to apply this query using CTE, but a little confused.

Regards

Akhil

A trick you can try is as below.

Start a trace in the background while sending test mail through the GUI, it will allow u to see the command that is...

But the log file will keep grow to accomadate both the insert and the delete.

Regards

Akhil

Thanks for your reply.

I am aware that this is a spam issue. But I am a little confused because of the below situation.

I am able to get notifications from jobs...

Yep. Thanks. I got that, I plan to make a copy and schedule it to run as a job on a monthly basis or so.

I hope it to be successful.

Regards

Akhil

Hey guys,

I am also looking for the sp to retain the full backups, and modified it by excluding the full backups in the conditions from the original sp.

Can you please...

I do not believe that it is a straight forward answer.

There is a lot of analysis that needs to be done before you can choose which high availability mechanism you...

I am not so sure if you have tried checkinig the log file directory for sql server in windows.

I believe that this can also happen if the sp_cycle_errorlog is run...

It is generally recommended to use coded scripts for maintenance instead of using maintenance plans, especially in case of enterprise servers.

You would be able to find a lot of scripts...

The 'Auto Update Statistics' option should be enabled for databases where you need to do this.

The database engine automatically updates them when they go out of date.

In addition, you can...

This should not be a problem.

Howeer, you need to very closely monitor your log file growth depending upon the size of the indexes that you are going to defrag. Estimation...

You need to dig into the sql server logs and windows application logs as to why it was unable to find the database.

Maintenance plans are generally not recommended. Deploying a...

I dont think that there is a direct way to do this.

You can, however, use system performance counters for disk usage: split I/O.

You also need to track the usage of...