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

GilaMonster (11/20/2014)

---

Latest version of SQL prompt can do that...

Luis Cazares (11/19/2014)

---

If we need to do it in our office and giving that the code here doesn't have any formatting standards and is a PITA to read, I would...

Sean Lange (11/19/2014)

---

cphite (11/19/2014)

---

I have several hundred reports that I maintain over various systems... many of them based on one or more stored procedures, many others with one or...