I am not sure why auto close is set to true. The DB was a restore trial from a sql server express database. Must have gotten set to that on...

That error was in the history log. There were no erorrs in the sql log that I can find.

Thanks

Quinn

Auto close is set to true. It varies from a couple minutes to over a half hour.

Thanks

Quinn

Rudy

I really appreciate your help on this.

Here is the message from the last one.

10 percent processed.

20 percent processed.

30 percent processed.

40 percent processed.

50 percent processed.

60 percent processed.

70 percent processed.

80 percent processed.

90...

Here they are.

WSGISG:\SQLExpressFiles\WSGIS.mdfDPRIMARY42949672963518437208064010057E0A711-5010-402F-957A-CBD86420C1F60030398873605121NULL500000003229300037FA21D7CF-289B-4F3F-8A90-70BF67115A8601

WSGIS_logG:\SQLExpressFiles\WSGIS_log.LDFLNULL31021465602199023255552200370D1030-EA8E-4B05-9D2A-E290F2424C5B0005120NULL000000000-0000-0000-0000-00000000000001

(2 row(s) affected)

Thanks

Quinn

Rudy,

I am not clear about what you are asking.

If I script the restore that worked I get this:

RESTORE DATABASE [Testing]

FROM DISK = N'D:\SQLBackups\wsgis20090906.bak'

WITH FILE = 1, ...

I am not sure exactly what changed but I was able to do a full resotre without an error. Before that I was checking the suggestions that you made. I...

I am just trying to restore from SSMS. From the context menu in databases.

Thanks

Quinn

Jim,

I have created a package using the ibmdasql provider. The performance is great. I use it to download data into SQL for our GIS system. The trouble I am having...

Also work and also cool.

Like you said quite a bit shorter.

Thanks

Quinn

Lutz

THat did it. Thanks. Sorry I didn't have my data pposted correctly. It skipped my mind.

I learned a bit about subqueries on that.

Thanks again.

Quinn

Here is a chunk of data.

CTL SI

LG0

BSL41

SX19

BSL31

A61

A61

BSL41

LG0

BSL41

A61

A68

BSL36

A58

BSL38

LG0

...

Thanks guys. Sorry about the confusion.

I need to show how many rows there are of the min and max values in each grouping. Lets say that there are 100 rows...

Thanks Greg!

Quinn

Alister,

I am having trouble locating where that file is located.

I will let you kow when I find it.

Quinn