Viewing 9 posts - 1 through 9 (of 9 total)
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
December 4, 2006 at 3:41 pm
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....
December 1, 2006 at 3:12 pm
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...
December 1, 2006 at 3:00 pm
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.
December 1, 2006 at 2:55 pm
You could import the data into a temp table and just do the update off of that.
November 3, 2006 at 11:22 am
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...
November 3, 2006 at 10:21 am
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...
November 2, 2006 at 6:44 pm
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...
November 1, 2006 at 9:22 am
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...
November 1, 2006 at 9:15 am
Viewing 9 posts - 1 through 9 (of 9 total)