Hello,

I've only been here a week. However, no pattern yet. Update script. Insert rows. They come in from about 6 developers.

Thanks.

Tony

Thanks Mike.

I know if Integration services were installed. However, Integration services are not installed on this server. The import.and export wizard is there. The package was created...

That may be. I can check.

But is there a way to export a cube to a series of tables or a single table?

Thanks.

I just noticed that the execution account and the service account have the same account. Whoever installed this used the same account for both.

I may try to change the...

Yes, I thought of that also.

I did a right click and ran as administrator.

I tried to change the Windows authentication to sql server login to use 'sa'. But it...

I am on the reporting services server. The database engine and the reporting services are installed on the same server.

They are both SQL Server 2012. SSMS to database engine...

Yes, I know the database is always the problem to some.

However, I just wanted to give due diligence to the problem. Just in case there wasn't something else that...

Yes, I am working on that angle. Unfortunately, having the development rewrite an application can take a lot of work.

Would the only solution be to release the connections (from...

Ok, I found the answer.

I re-read the articles on creating the alerts. I saw one item: restart SQL Server agent.

When I restarted the agent, I started receiving emails....

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...