Thanks gents for the advice, I'm currently setting up the login inspection db to capture the growth of the tempdb so to see exactly when this might happen, plus i...

Hi Jeff,

It's hard to say just how big it wants to get, because it always runs out of HD, but i can tell you it gobbles up 40 Gbs within...

Too true, thanks for the help and advice, i 'll reply with anythin interesting that might come up. Thanks again

Mr J 🙂

thanks Paul, i already purged the tempdb so its not goin to be much information within it until it blows out again next time. So i guess I'll have to...

Can't say i'm familiar with sys.dm_exec_query_text, sorry... little help?? 🙂 Also the replication is fine runs smoothly without any issues.

Its a mix of the three, but its mainly merge. I know its the replication agent because i ran this query

SELECT

sys.dm_exec_sessions.session_id AS [SESSION...

Yeah the server is a bit old and is due to be replace in a few months, the event log didn't suggest anythin out of the blue, just runnin a...

Very true, because i was using merge replication i could point the web site to another server and not have any downtime, so my only concern was to create a...

The solution to my problems was to fix the database in suspect mode.

Note only use this to grant access to the db so you can drop it and accompanying...

Hmmm i would be interested in learning more about capturing the output from the first stored proc to an SSIS variable. 🙂

Hello Friends its me again,

I've done what you have suggested using global temp tables and using RetainSameConnection, but i seem to be receiving another perplexing error

ExecuteReader requires an open and...

Thanks heaps guys I've learn alot today 🙂

Yeah thanks for that i understand. Does it use multiple connections for queries too? you would think this is done in a singular connection.

Yeah i guess I'm hoping to avoid this because it means re-writing a lot of SP and I'm feeling particularly lazy today :rolleyes:. Its quite annoyin the SSIS has issues...

Thanks dude for the advice but still hasn't help. Free feel to suggest anythin else if you think it might help, I'm bit of a dead end with this one!