The maintenance plan wizard is pretty straight forward. Just remember that it will go through and reindex everything. How large are the databases that you are working with?...

You can find out the columns of a table from the INFORMATION_SCHEMA or sys.objects to determine if the source and history tables match.

It's probably a safer bet to just make...

I believe it's just flat files.

Here's a link to the documentation on it:

http://vyaskn.tripod.com/sp_readerrorlog_undocumented.htm

If his source code is setup to use xp_cmdshell and he's not willing to change the code then it is probably the only way you will be able to grant...

Is he parsing the error log?

If so can't he get everything from a xp_readerrorlog command?

Thank you so much for your help!

I'll keep testing!

Thanks for the test.

Just one question, what happens when you click "test connection"? Does it succeed?

The one thing to point out, in your example above... the second server is a partner server and they are on 2005 still. So the cube is 2005.

Does that...

We get that error message when testing the connection in SSMS.

It works fine with the exact same configuration in SQL Server 2005. The only difference is the provider version....

What did you delete and recreate? The cubes?

The problem on my side is that we have no control over the remote side's system. It's a partner system that...

I'm also seeing the same on one of our servers. There are about 20-35 TRACEWRITE wait types at any given time. The users are complaining of performance issues....

Thanks for the helpful responses guys. I will look into all suggested solutions and see what I can do.

Much appreciated - John

I don't think that's right... because when I do SELECT * FROM sysindexes WHERE indid = 255 and groupid = 3 I'm getting results back

John

Sorry I should have posted the "why" at the beginning... Basically we are trying to empty a file group and get rid of the file in that file group. ...

Oops i meant sysindexes... sql 2000... sorry that was a type-o

As far as using the GUI, it says online that if I update the location in the designer it'll recreate...