There should be a New Query button near the top left hand corner of your screen. If there isn't, choose Toolbars from the View menu, and make sure Standard...

Use Profiler to capture the execution plans for the two ways of running the code, and then compare them.

John

Please copy the command from the job, paste it into a SSMS query window, run it, and tell me what happens.

John

The only way I know of performing a "downgrade" such as this is to script out your database and all objects in it, recreate it on the destination server, and...

Yes, I would expect that. But you were complaining that your BACKUP DATABASE statement was unsuccessful. What happens when you run that?

John

Paul

You're quite right - Books Online (2008 R2) says: "The SQL Server Native Client ODBC driver and SQL Server Native Client OLE DB Provider for SQL Server automatically set ANSI_NULLS...

If your databases are in Simple recovery mode, your transaction log backups will fail. What happens if you run your BACKUP DATABASE statement in a SSMS query window?

John

paul.knibbs (8/24/2010)

---

Isn't ANSI_NULLS set to OFF by default? So the behaviour in this article will only apply if you've explicitly set it to ON. I'd have thought that deserved more...

You can do that in SSIS without using any looping mechanism. Just set your data source using a query, something like SELECT col1, col2, col3 FROM MyTable WHERE type...

If you run SELECT [name] FROM sys.servers, do you see the old server name, or the new one?

John

Given the choice of thinking of something and being able to see it, I choose the latter. I don't have AdventureWorks, in any case. If you want help,...

Any error messages?

John

If you take a full backup immediately before running the log backup job, does it still fail? It's possible that someone is running a BACKUP LOG WITH TRUNCATE_ONLY or...

So please can we see DDL for the dependent tables, as well as for the foreign key constraints between them and the Product tables? Would you also be looking...

Abhijit

Surely you just create a table with an identity column, and then insert the values from your two tables into it? If this is too simplistic, then please describe...