Hi,

Have you tried:-

Use [db name]

Go

Exec sp_changedbowner 'login'

Go

Hi,

I've also been recommended SQL Sentry and Quest Spotlight. Have not had any experience with them though. Going to trial this week.

Andrew

Hi,

If the endpoint is no longer required (and you are sure), have you tried dropping it?

DROP ENDPOINT <endpoint name>

Andrew

Hi,

Loads of articles on this, here's a starting point:-

http://www.mssqltips.com/sqlservertip/2717/monitoring-jobs-on-multiple-servers-by-using-multi-server-query/

Andrew

There can be multiple causes of this. I would confirm the correct URL in Reporting Services Configuration Manager and try accessing the \Reports page on the server directly.

IF it does change it to \Reports

Hi,

Does the URL you are clicking on end with \ReportServer?

Andrew

Ah, OK. I've been given the names of two resellers so might have to do some haggling. Thanks for letting me know.

If your database get updated once a day I would backup your database and log before the load, adjust the log to a size that is suitable (preferably avoiding autogrowth)...

Is it quite expensive? I'm going to a reseller tomorrow for quotes.

Might investigate Red Gate a little further,

Andrew

Hello,

Just from having a quick look at the error log, have you been getting failovers during the week? It would explain why the communication errors are there and why the...

Hi,

I'm trialling Ignite and Red Gate as well. I feel that Ignite is more towards tuning SQL queries by showing the wait types associated whereas Red Gate has much more...

Hello,

As your database is in the full recovery mode, the transaction log will not be truncated unless you perform a transaction log backup. When you backup the log, the log...

Hi, does this help?

CREATE TABLE #Mytemp

(Id INT ,

value CHAR(1),

name CHAR(3))

INSERT INTO #MYTEMP

SELECT 1,'B','XYZ'

UNION ALL

SELECT 1,'C','XYZ'

UNION ALL

SELECT 1,'D','XYZ'

SELECT * FROM #MYTEMP

DROP TABLE #MYTEMP

Sorry, forgot to say that when you run the query have a look at Activity Monitor for IO_COMPLETION wait types