This was a part of an 'Archiving' process.  We had already move the data were were deleting over to our archive server, but needed to delete that data out of...

I'm deleting 6 out of 12 million, so I'm not truncating..

Can I loop the above statement or not?

I see the issue with the phone value being used twice..

The datefr and dateto are

SET @DateFr = '5/11/2006 12:00:00AM'

SET @DateTo = '5/11/2006 11:59:59PM'            

But it also accepts @DateFr = '5/11/2006' and...

Figured it out!!

When the file was importing the table it created had a varchar8000 for each column (a very wide table).

WHen I modifed the column data types the data went...

That's exactly what happened.

What did you do?

I'm thinking of uninstalling everything and starting from scratch..

Thanks for the advice Anthony, I'll probably end up just wiping it and starting over.

Enjoy your weekend.

Susan

I was able to figure this one out..

You need to make sure you have your model database set to readonly mode.

Then all databases you restore automatically have that option...

What is the timeout period for the applicatoin? Can you extend it?

You could also set up a trace and monitor the database while they are running the application.

THanks

Susan

When I try and connect to the db I get the following error -

Error 927: Databaes 'dbname' cannot be opened. It is in the middle of a restore.

Any suggestions?

I did have the undo files

restore database SusanB

from disk = 'd:\fullbackuptest\SusanBFullbackup.bak'

with standby = 'd:\fullbackuptest\undo\SusanBUndo.ldf'

restore log susanb

from disk = 'd:\fullbackuptest\SusanBTranbackup.bak'

with standby = 'd:\fullbackuptest\undo\SusanBUndo.ldf'

Thanks for your help once again Lowell!!

Thanks for your help. It did the trick and doesn't look like such a mess..

Thanks again

Susan

I've made the modifications suggested, but am having trouble creating it.

I get the following error - Maybe I've been looking at it too long, but I don't see the...

Lowell,

Can you provide me with an example of the split function you mentioned?

I don't see it in BOL

Thanks

Susan