This site should be useful for you.

http://www.sqlusa.com/bestpractices/datetimeconversion/

We've done it the same way (jobs listed in database) and it worked fine. Not too terribly significant a load on the server.

And SPICE

You can script out the table and its indexes from SSMS. As for the statistics, you should leave that to the DB Engine.

Once you script your table, change the...

Right click database, tasks --> generate scripts. Follow the wizard.

That will allow you to script out the database schema. Unless you are talking about the user schema, and...

Do you need to copy data too?

Lowell (1/14/2010)

---

my mind reading hat is better than yours today...

actually he put in a description along with the subject, which you can only read at the topic listing level, and...

Ifila, thanks for posting the information that was being requested. This topic has shown that SSC can help and will help when challenged. I hope the results of...

I see data and no description. Please provide a description of what you are trying to accomplish with that data. Also, please provide table scripts where applicable.

GSquared (1/14/2010)

---

jferrel-1093506 (1/14/2010)

---

True Lynn, I have not read much else on SSC.... but as disgusted as he is about customer support, I can equate that to me having to wade...

http://msdn.microsoft.com/en-us/library/cc719165.aspx

http://technet.microsoft.com/en-us/library/cc966399.aspx

Nope - no fruitcakes this time of year. Except maybe in the eyes of that...

Lynn Pettis (1/14/2010)

---

ifila (1/14/2010)

---

A few months ago, a forum member suggested reducing the size of the email fields from 1000 to something more reasonable.

So i created a TestDB that is...

It's a matter of timing.

You're welcome. Good to see that you also found an answer to your question.

Dom Horton (1/14/2010)

---

jferrel-1093506 (1/14/2010)

---

True Lynn, I have not read much else on SSC.... but as disgusted as he is about customer support, I can equate that to me having to...