Try this thought on.....

Can you add a date field to the table that defaults to the time added. Then you go and strip out and group the photos/directories that have...

Aaaaagggghhhhh!

Are you using the same path name for everything? Or until you known the actual location of the photo's file?

Are they broken into...

Try this:

select (max(tempbookings.end_date) 
where  tempbookings.end_date Not In
   (select (max(tempbookings.end_date))

It will probably be something like

if NOT exists (select * 
           FROM dbo.sysobjects 
      ...

You all need to try http://www.metacrawler.com.

It searches google, yahoo, ask jeeves, and other sites. I get a better return there on more arcane searches than I ever have with...

I find that if I get the blank after submit that if I hit the back button and then submit it will work. I'm using Opera.

Note that I at least...

I've run into something similar on a regular basis with my servers. Mine occurs on the full .bak as well as the .trn. I'm assuming SQL2K on Win2K(3).

If you have...

I did try the setspn and it didn't go away.

Like I said...this is just an irritant, not a show stopper.

I know it technically is a non-issue.

I just hit the event viewer one day after having to do multiple starts and stops on a server - filter out all information...

Per http://www.aspfaq.com/show.asp?id=2160 at How do I know which version of SQL Server I'm running? that is 8.00.837 = SP3 / SP3a + KB #823514 (Updated 2005-02-22)

Have a good day....

We burn our Accounting databases to CD/DVD. I keep a snapshot of the database at calendar year end and another after they close the prior year end. This is...

Can you give us an example of what the dates look like in the table?

We have an imaging systems from Hyland Software.

They store the images (mostly .tif) on disk and go with the pointers. We have close to 750GB of images and the DB...

Take a look at this script SQL Server Database File Sizes.

It also will give you file sizes and both physical and logical data file names.

Try this....it will take everything but the last 3 characters of the name.

Public Function Auto_Rename_Tables()

Dim RS As Recordset
Dim SQL As String

SQL = "SELECT NAME " & _
   ...