Hi,

Finally got it to work using Attunity connectors: http://www.microsoft.com/downloads/en/details.aspx?FamilyID=d9cb21fe-32e9-4d34-a381-6f9231d84f1e&DisplayLang=en

jim

Thks jacob, i'll take a look.

j

Hi,

Good article, nice & informative to those who're new to SSMS 2008.

However, ( i know it's a little moan on my part & ) whilst it's nice to have...

hi,

sorry, i didn't explain very well (again) because of the domain security, developers can access all servers regardless of environment !...it's the legacy i have to deal with, so giving...

hi gift,

i agree with your sentiments, yes, what developers do is none of my business, what runs on our servers in Prod is ( my responsibility ), a pertinent point,...

Thanks for all your replies.

It's nice to see how others are managing this, unfortunately we have some rather interesting 'legacy' security issues meaning the lines between environments are...

Hi barsuk,

Forgot to say your suggestion is something that we will implement to try & give us some warning of when the issue is going to happen.

Thanks.

j

Hi,

Ok, this issue is an intermittent one, so unfortunately until the next time it occurs all options such as 'localhost', sysservers, serverproperty & servername are all ok, however at least...

Hi,

Nothing in the event log & any errors reported in the Sql log come from our DTS packages failing because they can't connect ( resolve ) to 'local'.

Server is using...

Hi alzdba,

We edit the packages direct on our (Dev) server(s) with connection (local), this way we can src control them, then once tested successfully, we port them to other servers...

Hi,

Thanks for the replies. However I seem to have omitted that I was trying it on a SqlServer 7 !, as it too works ok for me on Sql2k.

Is...

Ok, solution found !,

We needed to call 'openquery' to do the insert, the following code is an example of how it was done;

insert openquery(SERVERNAME, 'select field_1,field_2, field_3 from tablename')

values (getdate(),'FINISHED', 'sql')

This...

Hi,

Manually increasing the size was just a quick check to see if it would a) work & b) get you round your immediate issue.

Have you tried to add another log...

Hmmmm, world of the strange !!!

Can you manually increase the tempdb Log file ??, if so perhaps this temporary measure will get you over your problem.

Also forgot to ask you...

Hi LN,

Check to make sure that the disk the Log file is located on has available space for the log to grow.

If you have the 'Automatic growth' option checked then...