Thanks a bunch Steve. Always wondered about that one.

Thank you!

Hi Yelena, how about this one? Is it not the same application?

http://tinyurl.com/2wzve7

I see, thanks much for your great reply. And thanks to everyone as well.

Regards,

Shahgols

I have 4GB memory and SQL 2K Enterprise Edition. Which way do you recommend me to set it up so that it gets more memory?

ARRGGGHHH, I am using Win 2K Server, and it's not supported.

How can I give more memory to SQL on Win 2K Server?...

Hi J,

I am not sure how to do step 1.

We are running sql 2000 SP4 on Win 2000 SP4. User is running MMC 2.0 whereas I am...

Thanks everyone.

Thank you Wesley, that query works for me too.

On my servers dtproperties doesn't have any indexes. Could it be that in your environment this table was modified?

Hi there,

Thank you to both of you for your help!

Lance, your query worked great! Except it also returned the table dtproperties, which doesn't have an index on it. ...

Thank you so much to both of you!

What is the SSIS service called on your server? Thanks.

Thank you for your replies.

I am not sure what you mean by setting a default schema. How is that done?

We are probably going to do a variation...

Thank you!!!!

Hi Greg,

Data consistency is why I am concerned. But I am not sure how this will cause data loss. For example:

1. We replicate the databases from server...