WayneS (7/23/2010)

---

Lynn Pettis (7/23/2010)

---

Stefan Krzywicki (7/23/2010)

---

Lynn Pettis (7/23/2010)

---

Okay everyone, the hardest thing I have had to do since I started here (work) a little over 5 years ago is done,...

It would definately help if you posted your code. Hard to help when we can't see what you see.

I'm curious, why can't you use SSIS?

hxkresl (7/23/2010)

---

OP stands for me, the Outstanding Person, I believe 🙂

OK, and what if the source database is corrupted, ie. a virus attack that deleted tables and data, but not...

Here is one way of doing this in SQL Server 2005:

CREATE TABLE dbo.TestTable

(

ID int,

[Name] varchar(50)

) ;

insert into dbo.TestTable (ID, [Name]) values(1, 'John Doe') ;

insert...

halifaxdal (7/23/2010)

---

Thank you in advance, here is a sample:

CREATE TABLE tbl

(

ID int,

[Name] varchar(50)

)

insert into tbl (ID, [Name]) values(1, 'John Doe')

insert into tbl (ID, [Name]) values(2, 'John Smith')

insert into tbl (ID,...

GilaMonster (7/23/2010)

---

PaulB-TheOneAndOnly (7/23/2010)

---

A snapshot is taken by splitting a mirrored storage device - like EMC BCV.

SQL Server snapshots a operationally identical to standard SQL Server backups but you do not...

Table DDL (CREATE TABLE statement(s)) for the table(s) involved including defined indexes would also help.

I'd be interested to know if there is an index on the dUCrtd column.

I think I'm getting a little lost. You mention something about restoring a snapshot. I don't believe this is possible as you can't backup a snapshot.

What may help...

I think I know what you are trying to do, but to be sure could you post the DDL (CREATE TABLE) statement(s) for the table(s), some sample data (as a...

Could you clarify what it is you are asking? You can use a DB Snapshot to revert a database to the point in time that the snapshot was taken.

CirquedeSQLeil (7/23/2010)

---

Alvin Ramard (7/23/2010)

---

CirquedeSQLeil (7/23/2010)

---

Lynn Pettis (7/23/2010)

---

Fun time right now, putting together a list of tasks I should try to complete before COB 2010-08-06. Not really that long, yet,...

Actually, I think ROWE and agile techniques may be quite beneficial. Unfortunately, I am not in either of those environments (new employer from what I can tell uses their...

LutzM (7/23/2010)

---

Lynn Pettis (7/23/2010)

---

Okay everyone, the hardest thing I have had to do since I started here (work) a little over 5 years ago is done, now the countdown to...

Fun time right now, putting together a list of tasks I should try to complete before COB 2010-08-06. Not really that long, yet, but may not have enough time...