Hi, use the Target Server Memory and Total Server Memory performance counters.

Andrew

Hi, compression is an attributed which is replicated. Please have a look here:-

http://msdn.microsoft.com/en-us/library/cc280449.aspx

Andrew

I'm quite looking forward to seeing the ability to extend the buffer pool to an SSD card.

Andrew

Hi, Ola Hallengren has a really good set of scripts for this:-

http://ola.hallengren.com/

Andrew

Hi,

Sorry but we would need more information on what the stored procedure is doing. Does it accept parameters and if so, do they vary?

Regards,

Andrew

Hi,

If you have the one instance as a linked server, you can reference it from the other instance by:-

[Server Name].[Database Name].[Schema Name].[Object Name]

Andrew

Thank you for the help and advice guys.

I've been doing more research and it looks like SSIS does not support delegation:-

http://msdn.microsoft.com/en-us/library/aa337083.aspx

The work around I have got is to execute the...

Not giving up on this one!

The problem seems to be that the account is used NTLM authentication, so it is not surviving the "double hop", hence the failure for...

Hi,

Without knowing more about the server it is hard to make a call. How many and now big are the databases on it? What type of work load does it...

Please try this (you can alter the returned columns as needed).

USE [msdb]

GO

SELECT *

INTO #temp

FROM OPENROWSET('SQLNCLI', 'server=SERVERNAME;trusted_connection=yes',

'set fmtonly off exec msdb.dbo.sp_help_job')

SELECT name, enabled, current_execution_step, current_execution_status

FROM #Temp

DROP TABLE #Temp

Disable TCP/IP in SQL Server configuration manager?

Hi,

Have a look here:-

https://www.simple-talk.com/sql/database-administration/sql-server-endpoints-soup-to-nuts/

Andrew

Hello,

I think you're trying to restore into SQL Server 2008, the database was backed up in SQL Server 2008 R2.

Have a look at the build numbers here:-

http://www.sqlteam.com/article/sql-server-versions

You cannot restore a...

Definitely, I have a powershell...

Are there active connections to the database?