Hi,

Good useful article once the errors are sorted.

I myself have left the rebuilding of indexes out as I always prefer to manually check any index creation before going ahead no...

That error you describe with the '"(null)" reported an error' does indeed come up on 2005 SP2 but it should only be on the gui you get this... run a...

gints.plivna (3/26/2008)

---

How about reading this very thread from this very forum?

Gints Plivna

http://www.gplivna.eu[/quote%5D

Nah.... can't be bothered.;)

Seriously though thanks.

If you're running 32 bit SQL then...

My experience with linking to an oracle database is to use MSDASQL... especially (MSDASQL only exists in Server 2008 for 64 bit)

I find...

A slight alteration on that query:

SELECT h.tagname FROM history as h

inner join livedata as l on l.tagname = h.tagname

where value = 1

It's not that it can't find the fieldname it's...

Although I have not encountered this particular issue on my 64 bit infrastructure (we got rid of all our DTS') I have come across a bucket load of 64 Vs...

I think somehow I will be going back to them now since I've found more strange things... some I know that are not right.

My company is currently setting up a new infrastructure using HP Blades.

After prelim tests we've made the decision to use physical machines in our live environment but have found VMWare...

In my old company I had a similar issue... it really comes down to (well it did for me) what your IT department is comfortable using (for mine SATA was...

Aye...

 

I had the cast/case statement ready as my work around... I was hoping for an answer that was more of a setting but nevermind...

 

Thanks very much for your help

 

Mark

 

On a random without further information...

 

 

delete a

from table a

join table a1

on a.passportid=a1.passportid

where

a.date > a1.date

 

That should leave you with only 1 passport record and only the highest date.

I'm an idiot....

 

I have however solved it.

 

Probably confused by the garish colours of 2005.

London.

Day of stupidity over...

Thanks for the replies anyways.  Yep basically just did the join and then let asp format the results for me.

I got that far... it was actually getting the DTS packages...

 

which having opened my eyes I found in sysdtspackages.

 

Sometimes my amazing skills of perception seem almost superhuman...