From notification point of view, you can check this site: http://sqldev.net/xp/xpsmtp.htm

This is very good for SMTP implementation.

Can check \Microsoft SQL Server\MSSQL\LOG\SQLAGENT.OUT & SQLAGENT.1 thru SQLAGENT.7, if you could find any error in the log. You could also try checking ERRORLOG * ERRORLOG.1 thru 7 for any...

If you are consuming most of your time (out of your 1.5 sec) in retrieving the data from a specific table (or couple), you could think about to pinning table...

ckempste reminded me about one of the problems occured few months earlier.

We had somewhat similar issue with NIC on few of our terminal servers (not Database Servers). Someone changed the...

Great Link Allen. Just in Time. We are in the process of doing a DR test. This will help a lot.

Thank You.

If the ID you are logging into SQL Server is not part of System Administrator's Server Role, then you cannot see SQL Server Logs view.

Which ID (& Server Role) are...

Thanks Jeff.

I am sorry about that. I take back my word. I meant that "in my case Auto Close might not causing the problem."

When I looked at my colloegue's database server,...

Hi All,

We just checked one of my colleague's DEV Database Server Log for "Starting up database xxxxxxx" yesterday. We have restarted the SQL Server (7.0). As soon as we restarted,...

By Default Administrators group will have sysadmin access on SQL Server. Try accessing thru Windows NT Authentication, you can change "SA" password this way.

Good to know. Thank You.

Yes. I am having one Win2K SP4 machine. I did not have any problems so far. Let us know if we need to look for any specific issues.

Rahul,

I think as long as you have sysadm rights, you can perform anything in the database. And user "SA" can do anything in the database.

I got this solved.

I have reduced the MAX rows, in the database Maintenance plan, then manually ran the job to get it cleared by the system itself.

After this job started...

Brian,

Could not get much info from the earlier article.

Since this is the first time I am setting up SMTP mail sending out. If we are trying to send SMTP mail...