..If am able to recall, this issue I have faced when trying to connect DB engine with a lower version of client.

In your case I am not sure though.

ok.. Let me check with them anyway.

Thank you.

Thanks Gila.

Well, I just assumed as I saw the value as some guid kind of value instead of the actual physical location.

Yes, will be getting the details directly from them...

Thanks Perry.

I ran profiler and got the host name. It was coming from a test server which was removed from domain.

I stopped a sharepoint service which was running and the...

Rectified the issue. Thanks a lot Gila...!

Yes Gila. I have enabled DDL trigger for auditing purpose. It inserts a record into one of the table in that...

LSAdvantage (12/1/2014)

---

I ran into this once as well. In my case, I was executing msdb.dbo.sp_send_dbmail from one database and was querying a table in another. If this is...

Anyone faced this issue ? Please advise.

Pulivarthi Sasidhar (11/27/2014)

---

The query executing successfully in Query window?

If yes... then Security permission issues are there ..

The problem with the SQL Agent is that it runs under an account which...

All the services are runnind under "local system account" and we are still getting this error in our error log. Can someone please guide on this ? Thanks.

Reporting services DBs were missing from this server.. hence the issue.

Thank you very much.!

So a failover is essential is it ?

We will failover and then faiolver back once again as we need the current node as active.

Thanks once again.

That depends. Are you rebuilding those unwanted indexes? Are you rebuilding all of your indexes? Or are you using a defrag process that is more intelligent and...

Thank you.

So if I have multiple unwanted indexes, obviously it will be...

kumarjohnt (10/15/2014)

---

Hi All,

I have granted SQLAgentUserRole permission to one of the user and using enterprise edition of SSMS. still user is not able to view SQL Server Agent when he...