If you have already checked sysjobs and sysoperators, have you checked maintenance plans and alerts? Any chance you have a job step that is executing:

sp_notify_operator @name = 'SQL Job Failure'

You...

Open your browser using Run As Administrator and access the URL that way. Once connected, add your account to the administrators on the SSRS site.

Sue

Try checking the description in sysmail_event_log. If you query that, many times it will report if you have some type of SMTP errors or configuration issues. You could join it...

It's there on 2008 - it doesn't matter if you are on Standard or Enterprise.

If you are using Profiler to set it up, after you connect and then the...

I have seen a couple of other reports of this. I think they all ended up being permissions on the file.

Hopefully you still can't see it (sorry) but I am...

dastagiri16 (9/1/2016)

---

hi Team,

I am troubleshooting cpu usage issue of my server.

When i tracked most cpu usage queries, in that most of the procedures are executing continuously but those are recompiling...

DarthBurrito (9/1/2016)

---

Need some assistance my fellow SSRS friends.

My company has an existing report server. All is working just fine when accessing and running the reports. However, when the server was...

Was a log generated when you tried to apply the patches? Success, failure, cancel it should log. The log should be located in:

Program Files\Microsoft SQL Server\110\Setup Bootstrap\Log

Sue

It's doable but can take a bit to work out the permissions issues and how you want to handle that in your environment. You'll need to know where you are...

There are several different ways. The simplest one is probably something like:

--Convert Int to Hex:

SELECT CONVERT(VARCHAR(8),CONVERT(VARBINARY(4), 345678),2)

--Convert Hex to Int:

SELECT CONVERT(INT,CONVERT(VARBINARY(4),'0005464E',2))

You can find others, likely some better approaches...

Clint-525719 (8/31/2016)

---

Thank you. I have done quite a bit of googling, but haven't found what I'm looking for yet.

As for msdb, our current DR strategy is to actually restore...

Clint-525719 (8/30/2016)

---

I am trying to find a script that I can run which will return CREATE statements for all jobs on a SQL Server. I know how to go...

When I get to it, the link only shows as being in the download section.

Try going to downloads. Select servers. Then go to the SQL Server download you want....

Sorry no. However, if you are a member of Visual Studio Dev Essentials, the 2014 Developers edition is free to download.

Joining Dev Essentials is free so you may want...

I don't see any attachment but...with the Express Edition, you get the Import Export Wizard and the Data Source connector but that's it. There is no SSIS designer or SSIS...