Well, that's interesting. The "CREATE DATABASE GO" statement failed to create a database on my machine.

This is interesting.  On my SQL 2K Server "Standard Edition" with SP 3 this raises a syntax error if I am in any database except for pubs when the commands are...

Dinesh,

See if what is in this article will work for you.http://www.sqlservercentral.com/columnists/jyao/makinggooduseofsysforeignkeystablepart1displaytabl.asp

I hope this doesn't double post.  I refreshed several times, waited a few minutes, refreshed again and my post never appeared, so here goes again.

BCP is not forgiving.  The non-optional paramters--database...

I agree.  BCP will error out with the command line options given in the question and no data will be loaded.  The parameters do not include the in|out and server...

Maudapa,

The last link you posted was excellent.  It solved all my problems. 

Thanks for help. 

It's not that difficult to do once you understand the steps.  It was only a...

Maudapa,

Thanks for the replies and the links.  I'll look into them. 

Maudapa,

I think you're on to something here. 

However, I am running a named instance of SQL Server not a default installation, and there are no instructions for adding spns for...

Mads Holm,

Thanks for the reply.

A couple of things here that I think I might not have made clear in my first post judging from your answer. 

I have two servers in...

jasals,

That is an alias for the column 'uploaddate' that had the max function applied to it. See what is bolded below:

SELECT #t.ProjectID, mud, uploaddate,...

Antares,

Thanks.    You diagnosed it very accurately. 

LOL.  Being a newbie in anything is just so much fun.  The mistake was just my not thinking through real thoroughly how I was going...

I just figured it out. I'd given it up for a while and had an inspiration and it worked.

Hi once again.

I've put something together but I'm misunderstanding a part of the process of taking the cursor output and placing it into sp_dboption. I can create the sproc...

jxflagg,

I just had to drive my wife to work and on my way there I realized that a cursor would be the tool to use. Thanks for confirming this....

Thanks for the help guys. I appreciate the help. I now have a much better idea about how DateDiff works, and when and where to use it. ...