****** Anyone? *******

Thanks for the feedback, we'll investigate that option.

Thanjs again.

Thanks. I cant seam to find this in any MS documentation.

Hello,

Sorry, for the hijack.

Can I install a new instance on a SQL Server Default clustered instance with the the shared disks being those that are already used by...

Many thanks for your response mike.

I'll give it ago as per your suggested steps. If it easy for you to find what needs removing, I'd really apprieciate it (give...

The historical data would be much bigger, the largest table containing around 60million records with the smallest around 10million.

The current data would consist of the largest table containing around 15million...

Many Thanks for the response. I'll have a look at the link you've suggested.

Data coming into the tables (from another system) will be thought as current so this flag...

Great thanks for the replies. I'll take a look at the links.

Have any of you used SQL Server with VMare in production? if so how have you found...

Hello All,

Just to give you an update.

After reviewing the products, the 2 runners are Idera and SQL Sentry. I've had a demonstration of both products. Idera...

Wow, thanks for all the responses, suggestions, links etc. I really apprieciate it.

Idera certainly sounds like it is one of the main contenders, from what I've seen so far I'm...

I think i have started a 'SQL-RUMBLE'.

Thanks for the responses.

Thanks.

I apprieciate the thoughts behind not shrinking a database, is there another way giving the O/S back free space the database may have been holding onto?

If I run shrinkdatabase, does...

Thanks everyone.

The application creates the server level logins and assigns permissions on the specific role. Unfortunatly, we cant interact with that.

Can an 'Execute As ' option...

I used the steps as set out by http://www.sqldts.com and they worked great.

Just wondering, is there any way of amending the connections within the dts packages without having to...

Thanks.

The servers are not clustered.  We will be using the same account on each server.

I guess its just the service accounts.  Thanks for your help