Joie Andrew (7/24/2016)

---

When I say the SSRS logs I mean the logs that are natively a part of SSRS. By default they would be located here:

C:\Program Files\Microsoft SQL Server\MSRS13.MSSQLSERVER\Reporting Services\LogFiles

Reporting...

SoHelpMeCodd (7/25/2016)

---

Did you restore report server's databases from another server and point your laptop's SSRS to them (via RSCM or rsconfig)? If so, you need to export the Encryption Key...

I did restore the config file, but it didn't help. I tried several methods to turn on error logging via the http service and iis. None of those worked (error...

Rod at work (7/22/2016)

---

Stephanie Giovannini (7/21/2016)

---

I don't understand why code re-writes cause so much fear, both among developers and management. It's the code equivalent of cleaning out the basement by...

I don't understand why code re-writes cause so much fear, both among developers and management. It's the code equivalent of cleaning out the basement by emptying it, scrubbing it clean,...

Does anyone have any ideas on this? I don't know where to start with this kind of problem. Everything looks correct, except that reporting services returns 503 error every time....

This QOTD should have a disclaimer:

This schema blatantly violates second normal form and is presented for demonstration purposes only. Do not use this schema as part of class-scheduling system. No...

CREATE TYPE Steve AS TABLE (id int);

GO

CREATE PROCEDURE Steve AS SELECT 1;

GO

CREATE SCHEMA Steve;

GO

GRANT EXECUTE ON Steve TO public;

This succeeds and grants permission execute permission to Steve. Which Steve? The...

I've updated your most recent test script. The MERGE statement allows more flexibility in the OUTPUT clause than other DML statements. This allows the RowID to be passed from one...

I finally sacrificed some of my free time to address this stand-alone server. I uninstalled SQL Server Express 2016 and installed a clean copy of SQL Server Express 2016 with...

When the variable is INT, there are two seek keys on the clustered index seek:

Seek Keys[1]: Start: PtnId1000 >= Scalar Operator((1)), End: PtnId1000 <= Scalar Operator((4))

Seek Keys[2]: Prefix: [Sandbox].[dbo].[test_part].year =...

But even if tokens are enabled, will this job do what the DBA wants it to do?

I ran an altered test scenario on my local SQL Sever. I had...

This is probably more than 20 years ago, but I realized that I had all my high school creative writing backed up on 5 1/4 floppy disks in AppleWorks format,...

What version of SSMS (SQL Server Management Studio) are you running? (Help/About)

Do you have SQL Server Express with Advanced Services? If you downloaded it, you might know that.

Also note that the [No of Applications] column is an integer. In the WHEN expressions, it should not be in single quotes. That's a string and the implicit conversion may...