I should have prefaced my OP with, "This is how it was set up long before I arrived here".

The security event log for my SQL Server doesn't show a failure...

That did it, thanks.

Tony is Steve's British alter ego.  Tony says "Hullo" instead of "Hello" when you ring him up, watches the telly, puts his luggage in the boot, goes upstairs in the...

I had a login mapped to the user in the database, so I don't think there were any orphans.  But what about the empty tables?

What error are you getting?  What client are you using?  (QA, application, EM?)

I concur.  The problem is that most books on programming, when they get to the section on database access, are woefully simplistic in how they accomplish it.  They just want...

A kind soul on usenet solved my problem.  Rearrange the code in the cleanup section so that the connection to the server is disconnected last:

''clean up 

    Set oTable =...

Barkingdog, what are you trying to accomplish?  Typically, a FIPS or Zip code is an attribute of an address.  Zip is useful if you're delivering mail, FIPS if you care...

The short answer is yes, it is possible.  Look at DATEADD in BOL.  Post some DDL so we can better understand what you're working with.

Hiking amongst the redwoods at Muir Woods on Saturday; haven't decided whether to climb or drive up Mt. Diablo.  Hanging ceiling fans and washing the trucks and motorcycles on Sunday. ...

Check out Bulk Insert in BOL and on this site.  You can build a format file that links the columns in the flat file with columns in a table.

Is it a permissions problem?  Are you in the sysadmin group on that server?  Are you connecting using a domain account or a SQL Server account?

One way I've done it is to create a calendar table, like so:

CREATE TABLE dbo.CompanyCalendar (

CompanyDate smalldatetime,

Holiday char(1),  -- 'Y' means it's a holiday like Christmas

BusinessDay char(1),   -- 'Y' means...

"What about Robyn Page at SimpleTalk.com?"

Can't be real.  That's got to be like when you buy a picture frame there's a photo of a babe in it.  I'm sure I...

Roger, I'm glad you're in this discussion; your experience brings some good points out that would not occur to most of us.  But what about the single sign-on problem?  For...