thanks for your help guys, the devs went with the option to write a function to determine if a date is within a BST period or not.

..........or you could just restore the backup 🙂

I don't think this is in the default trace but worth a check.

Otherwise best bet is from the backup history for the database. If you have a backup run restore...

replication will catch up.

CirquedeSQLeil (10/2/2010)

---

george sibbald (10/2/2010)

---

RichardDouglas (10/2/2010)

---

CirquedeSQLeil (10/1/2010)

---

RichardDouglas (10/1/2010)

---

CirquedeSQLeil (10/1/2010)

---

RichardDouglas (10/1/2010)

---

CirquedeSQLeil (10/1/2010)

---

RichardDouglas (10/1/2010)

---

CirquedeSQLeil (10/1/2010)

---

RichardDouglas (10/1/2010)

---

paul.knibbs (10/1/2010)

---

Well, it can't be a TINYINT or a SMALLINT because we've already passed the maximums for those,...

RichardDouglas (10/2/2010)

---

CirquedeSQLeil (10/1/2010)

---

RichardDouglas (10/1/2010)

---

CirquedeSQLeil (10/1/2010)

---

RichardDouglas (10/1/2010)

---

CirquedeSQLeil (10/1/2010)

---

RichardDouglas (10/1/2010)

---

CirquedeSQLeil (10/1/2010)

---

RichardDouglas (10/1/2010)

---

paul.knibbs (10/1/2010)

---

Well, it can't be a TINYINT or a SMALLINT because we've already passed the maximums for those, and it seems...

Brandie Tarvin (10/1/2010)

---

What type of configuration are you using? XML, Environment, etc.

We use an XML file and only choose to save the Connection strings...

BOL is as good a resource as any. You will have one BCP statement per table.

newbieuser (10/1/2010)

---

Yes.. Our client sent a sql file with bunch of insert statements and I had to split the files to run in the query.. I thought BCP utility...

we are trying this at the moment. I'll get back to you early next week. post here if you don't hear from me.

Incidentally we have already tried moving heavily used...

I would agree with Gail that if this file is insert statements this is not the best way to do this. Presuming your client sent these files to you in...

yes, having it done by...

Is the script a bunch of insert commands? This would have to be done using the sqlcmd utility.

Any chance of breaking it down into segments, say by table?

does it...

lets celebrate both milestones then! 🙂

I wonder if the rate of posting has slowed since ASKSSC was started?

Interestingly if you view members profile it states that users no of posts out of the total. In...