Please will you provide table DDL and sample data in the form of insert statements. This wuill help us to help you.

Thanks

John

David

I thought of that, and it would certainly work for the sample data provided. However, I reasoned...

Tom Carnahan (8/24/2010)

---

Good article ...

---

A topic I wish had been addressed is how to handle nulls in datetime fields. I think that you do the following. Let me know...

Please will you provide table DDL and sample data and show us what you've tried so far.

Thanks

John

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,...