Thanks again, i will be looking in to this and doing some testing with it.

Looks interesting.

Never used that before - Can you help me with a real example 🙂

This way i really understand if i can see a real example.

Here is one view

DATABASENME =...

Cannot understand the select top 15?

Select @mySQL = N'Alter view myView As Select Top 15 * From ' + @databaseName +'.dbo.yourTableName';

If i have 50 views i would have...

Do you know how to change the view with a stored procedure - that might be worth visiting.

Almost like a search and replace, any guidance would be appreciated.

View would...

So it be something run on the actual server ? yes i can't see any services starting with this .

Kind of strange..

Right click on services and see what account it is set to and log in with this account.

How does this work ......im interested got a few clients outside that connect in saying it slow but want to see if this is before it hits sql or after...

Go to sql server 2005 surface area configuration.

and check remote connections are set up ....using tcp/ip and named pipes.

If that not work on the actual computer you set up the...

DTS worked just a treat - i thought it dropped indexes and such but seems ok .

I am going to try the DTS wizard and see if it works as there more than 80 tables ..

Cheers

Sorry yes primary and foreign keys.

Ok so just do the insert and then select into this.

I thought there was a way to remove the constraint of primary to foreign and...

The datas is in databasea 006 - moving to databaseb 006

DTS didn't think it took care of the constraints.

I take you got it working ....how did you finally do it - this be good to know especially on the cluster incase you have to move the system files...

Thanks i take a look at the other events too..but from APP i can't do too much as it is the vendor software so i need to pass to them...

Make sure DTC is on in services...believe thats the one that turns on the transactions for Linked services and transactions to flow.