Its posted on this site that the command is still good. I just haven't found a person that has got it to work.

Thanks for the reply

I can tell you one thing I have invested a few weeks looking into the best 2005 management tool because everyone I work with also hates the new Management studio....

Sorry didn't read this through you want to schedule a maintanance plan with the wizard if they do not have a DBA there to script a job out.

In Management...

If you register the server then connect to it in the object explorer you can right click on the database and it will give you the same thing as EM.

You could import the data into a temp table and just do the update off of that.

Thanks for the replies.

It switches from a Index seek (without isnull) to a index scan on a rather large table and takes 70% of that query which takes 80% of...

Thank you for the reply. I added a similar statement (case statement) to that where clause and it fixed it I was just wondering if anyone else was having this...

I have the same issue but it had nothing to do with the changing of datatypes. If you remove the distributed query it works however if you keep it and...

I have the exact same issue. When I remove the distributed query it works. However in some cases I was about to modify the select statement to return all data...