Basically the plan is to upgrade the production server to sql2005 from sql2000. It has tonnes of websites, dts, dtsx and other applications that connect to it so rather than...

Thats great, will that keep all the orginal instances too ??

Cheers

Cheers mate, now the only thing left to do it convince the boss to upgrade the server 🙂

Hi MJ,

It's 2005 RMT, i've just done some readin up on it and it looks like a possible bug with 2005RMT runnin on 2003, would you agree with this ?

Cheers,

Hehe, silly me i forgot to restore the backup with norecovery :hehe:

Cheers everyone for the wealth of knowlegde 🙂

You mean technothenet lied to me.... the buggers!!

Basically i've been asked to find out the following

SELECT A, B, MAX(C) AS C_max

FROM ...

Thanks Paresh,

You where bang on , default profile trace had been switched on.

Cheers 🙂

Yeah, a profiler trace is running on the server and i wanna from which machine its running from.

Cheers John,

That worked a treat 🙂

Cool,

That's great to know, thanks for the update.

🙂

Champion! that worked a treat 😀

Thanks

Yeah it quite probable to be a bug, because where still on RTM :w00t: I'm trying hard to get the powers that be to authorise a service pack upgrade. In...

Hi Gail,

Thanks for the reply, i've managed to resolve the issue by re-creating the pubs and subs. Thanks again 🙂

Chris,

I'm glad we're thinkin on the same level because i've already created T-SQL backup plan and have forfiles, copying and removing .bak across the network. Its just annoying that i...