Ok, my confusion increases! 🙂

When you set up an alert, you include a job to run. Then you set up the operator and then email.

Should the alert send...

Hello,

Yes, I have set up a mail profile.

I have tested it.

The Alert Systems do have my profile that I created.

The table mail_items does have the emails that I sent out...

Just as a follow up.

I went into SSMS and then analysis services.

I right clicked on the cube and went to browse. There was an error. I then right...

We found a "report services site settings". When we clicked on that, we have the options to enable remote errors.

Now the vendor is seeing the errors.

Thanks.

This is an incredible day!!

I want to thank all of you for your responses. I am in constant learn mode with SQL Server. From asking one question, I...

The reason I proposed my question is why am I getting this in the errorlog when the database is in recovery mode is simple.

This may be a stupid question to...

Hello,

Autoshrink is set to false.

However, the files autogrowth is turned on.

Thanks.

Thanks for posting this.

I just configured a new server with SQL Server services. For some reason, SSRS would not start.

I used these steps and rebooted. The service started...

Thanks Fitz for jumping in there with some help. I appreciate it.

Yay! I got it to work. Here is my journal of how I did it:

•Installed developer install of SQL SERVER for reporting services.

•Got an error that says: The...

Thank you. I will give this a try.

I really appreciate it. I know on most servers, we are not allowed to cmdshell.

However, this is a DEV server, so...

I appreciate the help. However, what I need is to list ALL incidents for each facility whether they had any incidents or not.

For example,

if Table b had the following:

Sample...

Oh My Goodness!!!!!!!!!!!!!

Finally success.

I had to create the profile name on the server that I am using with the connection manager. I had previously created a profile on the...

I've already done that.

Most of the sites are saying go into SSMS and create a profile.

I've done that.

I've created a public profile in database mail in SSMS and set the...

Well thank you for responding. But like a lot of the things I am seeing, there is one or two things that aren't explained.

I ran the script, but it...