After looking this over, you'll see why I need this book! On the flip side, this article made me go research OVER and I learned something today.

select b.bookedby, B.bus_id,...

This appears to be an easier way to set SPN"s for the service account.

http://www.expta.com/2010/02/allowing-service-account-to-manage-its.html

Hello,

When SSRS components are loaded on a server other than the DB server and you are using Windows authentication for the reports, you'll run into the 'Double Hop', 'Kerberos' issue.

Couple...

Issue has been resolved. Needed to update SPN with two new entries.

--Original

mssqlsvc/VurtSQLSrv:MyInstance

mssqlsvc/VurtSQLSrv.MyDomain.com:MyInstance

http/MySSRSServer

http/MySSRSServer.MyDomain.com

--Working Settings

mssqlsvc/VurtSQLSrv.MyDomain.com

mssqlsvc/VurtSQLSrv.MyDomain.com:PortNumber

mssqlsvc/VurtSQLSrv:MyInstance

mssqlsvc/VurtSQLSrv.MyDomain.com:MyInstance

http/MySSRSServer

http/MySSRSServer.MyDomain.com

The SP calls specifically for SA. It's old code (1999) that's been removed in our latest version but we stil have a ton of customers on the old stuff.

Corporate...

I've got the perfect example to that statement.

Our app requires a stored procedure be run after we apply an auto patch. These patches usually replace or create new views...

Yeah, I'm a strong believer in testing your changes on something other than production before

implementing them.

Sorry to say that our customers do not always have a test or...

I doubt they have a QA system but that's a great idea to pass along.

'Test on a training or test system before deploying to production.'

If they have one...

Thank you both for the quick response. That sounds like the best path for them to take.

We'll pass along this suggestion and the warning that there may...

paul.knibbs (5/19/2011)

---

I'm pretty sure the 30% was a ballpark figure that one of the guys who wrote SQL server came up with--it wasn't ever intended to be a "you must...

Thanks for all of the replies.

I removed the records from MSDB which is fine for now.

I need to remember the Integration Services part when looking into this in...

What's the current version?

SELECT CAST( SERVERPROPERTY( 'MachineName' ) AS varchar( 30 ) ) AS MachineName ,

CAST( SERVERPROPERTY( 'InstanceName' ) AS varchar(...

Looked a little bit more and found this under the System Views

use MSDB

select * from dbo.sysmaintplan_plans

This shows the plans from the GUI and I was able to delete the old...

No luck there. Sysmaintplans has one record and it looks like it's a default from the installation of SQL Server.

I removed the old jobs from the old...

In a perfect world not changing anything until somebody makes a command decision on the business end of things and in the original article, I suspect the report could have...