So what you are syaing is that the proposed Replication strategy you have in mind will be 2 Database of different design?

NO NO NO! You will get yourself into lots...

J Scott,

You are not missing anything here other than the fact that you can backup a Database to any Server on your network.

You have to use T-SQL for this. You...

Is this a dedicated SQL Server? Or is there Applications run from it as well?

NOT FOR REPLICATION for what? What type of objects are you wanting to use this option on?

Identity Columns, Triggers or Foreign Keys?

Luk,

In light of what Jeff has just mentioned, if this does appear to be a statistics issue with your Tables/Indexes then you should be able to see long running queries...

I agree with Jeff Moden.

What on earth would make you think Oracle is going to do any better. I'm an Oracle DBA as well as an SQL Server DBA and...

Then how do apply the fix for DST as it sais to stop the Notification Service first?

Stepehen,

I will try your suggestion. I just have to learn how to create a variable and where to find the script task.

Yes! I'm new to SSIS as well.

I'll let you...

I tried your suggestion.

I deleted the file from the destination and then ran the SSIS Package but the package fails with errors.

If I place the file back into the destination,...

Hey I sorted it out. I was using the SQL Native Clinet and I should be using the OLE DB Connection as the SQL Server is on the network.

Thanks.

Got it. I had to enable trace flag 3604.

Thanks.

Sergiy,

Well done. Your solution is now performing an Index seek as oppossed to an Index Scan and it runs quicker.

Cheers.

I did what you said and all i get is DBCC Execution Completed.

Let me go back to the Users and clearly find out what on earth is really required here!

This is something I have inherited not written myself. Stay tuned!

Hi Jeff,

There is no correlation between the 2 tables hence the CROSS JOIN. In other words, there is no column to join on.