Dan,

Thanks for the info next time my log file fills up, I will do that.

Cheers

Keyser,

That depends what would you like to do ? Port a schema from an existing SQL Server Database or from another Databse such as Oracle or DB2 ?

Please let me...

Steve,

Hey I just wanted to clarify a few things.

1. When I said yes I was answering this question:

I've heard of something called 'Dynamic SQL', and understand it's mostly used in...

Steve,

You are right there is no_log option in the Backup statement, so I could have done that too. I think I chose to re-boot because there was a few other...

Here are some of answers to your questions:

1. Yes

2. Yes using DTS you can only import their schemas only, can do both schema and Data as well. I have done...

I think I figued out why the package was not opening. One of my packages is accessing a file that is local to server. I am performing a data transformation...

I had the server guys run a trace for me but they don't which counters they should be monitoring ? Which counters should I monitor ?

Thanks for your help. I will try those suggestions immediately.

We are using Analysis Manager that comes with SQL Server 2000.