I gave that a whirl and it didn't work either. This time instead of exporting to a text file and importing that, I exported to a table and imported from...

No I didn't get it to work. All of your assumptions are true  except for the logins existing on both servers. They do and they don't.

Let me try explaining the...

This is actually the query I want. The sid don't match and xstatus !=2. If I run your query everything BUT logins defined for linked servers. The query below returns...

I tried that but the login still fails. Instead of exporting to a text file I'm going to export to a SQL Server table and import to that to see...

What you say is true. However, I'm finding that when dbcc sqlperf(logspace) says my log is 93% full that there isn't room for even the smallest transaction, i.e. updating one...

Doing magic with SQL is sometimes great in a pinch. But when it takes a 4 page article to display the results of a query that doesn't seem very maintainable...

Forgive me for being naive. I answered the question wrong and understand what it can't be used for. That still doesn't tell me of what use the timestamp is. If...

XP Home is on it's way out 🙂

I figured out the OLAP Adminstrators thing on our Servers running Windows 2000. However, I'm also trying to mess around with this on my home PC running XP Home. I...

I'm a newbie too. There is an online course being put on by the folks at SDG. I found out about it at the PASS conference. Check it out at...

Did you get any answers to you question? I'm just getting off the ground with OLAP services and ran into a similar problem. Whether trying to connect to a server...