Can you please post the DDL for the table?

Thanks,

Jared

Not being completely familiar with these tables... Why are all of the values in both tables for 'name' field NULL?

Jared

My question (not being rude, just practical) is who cares? We know that logical and physical names can be different and that they are linked. So, if this...

One more thought! Have you tried using SYSDATETIME() instead of GETDATE()?

SELECT GETDATE();

GO

SELECT SYSDATETIME();

GO

Quite a difference!

Jared

I still think using sqlpubwiz is the easiest way to do this. It works on 2008R2 (as I've just tested it) and I would run it in a batch file...

Since you mentioned you are not very familiar with date functions... Check out this pdf: http://www.dotnet4all.com/snippets/factsheet%20SQL%20Server.pdf

This helped me a lot when I was learning, and I still use it for...

That's what it sounds like to me. It should ask you which instance you want to upgrade during the installation/upgrade process.

Look at step 12 here. http://msdn.microsoft.com/en-us/library/ms144267.aspx

Thanks,

Jared

jared-709193 (10/19/2011)

---

Are the databases you are connecting to on your local machine, or on a server? Which machine has developer installed, the server or your local machine? i.e. The...

Are the databases you are connecting to on your local machine, or on a server? Which machine has developer installed, the server or your local machine? i.e. The database...

Were you upgrading from SQL Server Express 2005 to 2008 Dev? There is no upgrade path for 2005 Express to dev edition. Also, how are you determining that the "databases...

Arne Holmen-458117 (10/19/2011)

---

Hi Jared

The slow backup is from one virtual server which is going to be a testserver (for testdatabases, not for my own testing) and from av SQL2008 Failover...

Just to clarify... Was this strictly for your testing or are the instances you were referring to from your first post...

David Lester (10/18/2011)

---

I had this problem frequently, initially the IMEX setting on it's own worked fine. However, to work fine the excel sheet data has to have the mixed char/numeric...

To answer your first question... I don't know. I use the GUI for this and have never scripted it. You should be able to find the answer by...

Jeff Moden (10/18/2011)

---

jared-709193 (10/18/2011)

---

The job that I took in April of this year was one of these...