You might find

MS article id:906954 "You may receive an error message when you try to run distributed queries from a 64-bit SQL Server 2005 client to a linked 32-bit...

I have found that several patches I have applied to SQL lately (SP and Cum Upds) will update the RSClientPrint dll. This is unfortunate as it also appears to...

I've spot checked and these have the correct tempDB name. Since I don't have my old DB anymore to compare I have to assume one of two things. ...

Can you give any examples of where you found the DB name in the stored procedures. We've been running without error since the upgrade.

I am still trying to finish the SQL 2000 migration to SQL 2005. I have read the comments that the SQL 2000 to SQL 2008 migration might be a...

After reevaluating the intent of the security document that prompted this question, I believe all that needs to be done is verifying that the SQL Server Agent proxy accounts (which...

I'm getting tired, let me clarify that post. I can send mail from Agent to an operator; I can send via xp_sendmail to a list of email accounts, but...

I was wondering if you had any secrets to that distribution group. I just moved the mailbox associated with the SQL Service account to exchange 2007 and now xp_sendmail...

Just a note. The name issue is a SQL RS upgrade bug. I also had that issue. It happens when you use the default name prefixed with...

Really useful script that shows how to do use the trace. Thanks!

Thanks! Thanks! I had planed an upgrade on a test server and redone it several times. But on the production server upgrade of SQL 2000 it did not...

After much consternation, I have found a trigger referencing the invalid object. Trigger [Schedule_UpdateExpiration] on ReportServer table Schedule has the offending reference in it. In test, I altered...

OK, I found this:

http://www.sqlservercentral.com/Forums/Topic553765-147-1.aspx

which includes this:

"Renaming a report server database is not supported because the report server databases are considered internal components. Renaming the report server databases causes...

Let me add a few comments to my reply.

AppRoles were chosen because of two main criteria.

1. Users were not going to be allowed to have access except through...

I took a job several years ago where application roles in combination with Windows authentication (Kerberos) were being used as the standard for web applications. This is my quick...