I had this problem a while back and it was aggravating the heck out of me... in the end, it turned out to be pretty simple and stupid: ...

SQL-DBA-01 (6/19/2015)

---

Hello Experts

I wrote a custom procedure to shrink the db log files alone. It works well always but yesterday in one of the server the job execution was failed.

Error...

Sean Lange (4/17/2015)

---

Please note that the query in the apply from cphites excellent solution is using TOP 1 but it also needs to have an order by so you know...

Marcus Farrugia (4/14/2015)

---

Hi I have tried a number of different attempts to get this going and am not having any luck,

I have to populate a table of exchange rates...

greg.celentano (3/27/2015)

---

As another SnapMgr user, do you get the issue with full backups or change any config recently? I have had the case with SnapMgr that I had re-run a...

It's been a long time since I've used Access for anything, but if I remember correctly Access creates locks against whatever tables it touches, and doesn't let them go until...

TSQL Tryer (1/7/2015)

---

Morning All,

I have created reports and also shared datasets within SSRS. Unfortunately staff still want the opportunity to see the data directly in Excel (exporting the report...

doug.brown (12/23/2014)

---

Have a look at the Data Source the reports are using - that is what dictates what user's permissions are being passed to the database. If the Data...

sqlprof123 (12/13/2014)

---

thanks v much for taking time out in replying..(sorry for my un-formatted post previously..i've now formatted it and slightly modified a couple of lines in the first para)

and yes,...

If I am understanding correctly, you are simply putting the link in the report and then the user running the report clicks the link and expects to get to the...

Gazareth (12/5/2014)

---

Copying the results of this into SSMS might be quicker (category_id 100 should be Report Server - check this first!):

select 'exec msdb.dbo.sp_update_job @job_id = ''' + cast(job_id as varchar(50))...

I believe...

lilywhites (12/4/2014)

---

OK....i have run a simple test (select getdate()) and can confirm that SSRS will rerun missed subscriptions.

- created a very simple report to output to a file (filename appended)

-...

sharonsql2013 (12/4/2014)

---

We need to make some changes in our DB tables but don't know how many reports use them on the reporting server?

Since we have a lot of reports. Is...

TJT (12/3/2014)

---

There has been a lot of great feedback to my questions and I have a few more questions:

Would you recommend splitting TempDB into multiples files equal to the number...