Thanks Justin that did the tick, using a DNS alias along with the SQL Alias did the trick.

I also managed to get it working using this method -

To be honest I not quite sure why they bought so much SSD storage at this point, this was done before I joined the company. Th idea was that they...

I've actually found that by entering the DR ip address and instance name in to the hosts file allows the install process to go through because it's not hitting the...

It was collation... :angry:

Ok, the problem has returned and recompile doesn't make a difference. Same symptoms as before, runs fine if sp is executed from SSMS but fills the tempdb data file if...

Happy days 😀 Problem's been solved.... Tracked it down to a developer in Australia who had added a new column to a select query in the sp. However this shouldn't...

Thanks for the links above. As I previously mentioned it only seems to fill up the tempdb if the the sp in question is executed from the SSIS package, when...

The datasource is a OLE DB and basically the sp gathers some data from a couple of table, does some calc and then inserts it into another table in the...

Ditto, we run weekly reports on index fragmentation for each database on our servers. This allows us to rebuild/reorganise only those that need doing and so we are able to...

Indeed! Thought I'd share the final script...

IF OBJECT_ID('tempdb..#Out') > 0

DROP TABLE #Out

-- Creates temp table and inserts diectory information.

CREATE TABLE #Out (output...

Awesone, this will work great. Thanks!:-D

It's so simple can't believe I didn't think of it, doh!

Bump

Hi I am able to send emails using sp_send_dbmail and the smtp server is available

Thanks for the advice 😀

I did a bit of reading on google about sp_sqlagent_get_perf_counters and then deleted the demo alerts from the alerts folder in the SQL Agent and that seemed to have solved...