As if this were a news flash, obviously, my wife has a sense of humor.

> Be nice to Lee.  He's at least in the spirit of the topic.

You can find DBAs with a sense of humor.  It's just not the first place I'd look. ...

It's been a lot of fun.

So I repeat myself a lot.

So I repeat myself a lot.

More irony... An oldie but goodie...

Women marry men hoping they will change, but men don't.  Men marry women hoping they won't change, but women do.

Irony??  How about:

• You can't afford a decent sound system until you're middle-aged, right about the time that your hearing is shot.
• The things that taste good are bad for you, and...

I'll be curious to see how others respond to this.  The short answer is, of course, yes, the job can be automated.  You could set up a scheduled task that...

> How would you do that?

Given the original query:

select skillname,code,descr from skill s inner join topic t on s.skillid=t.skillid

Something along these lines:

SELECT IDENTITY (INT, 1, 1)...

I misspoke earlier when I said the SQLSERVERAGENT account; I meant to say, SQLSERVERAGENT service.  I see, however, that you interpreted my garbled message perfectly.

I haven't used BULK INSERT very...

Check to make sure that the login who owns the SQLSERVERAGENT account has read access to the folder with the data in it.

sp_changeobjectowner [ @objname = ] 'object' , [ @newowner = ] 'owner'

Birds are no problem.  My roots are from Tangier Island, VA.  During duck season, even an angel won't fly over Tangier.

There are two types of respondents: those who categorize respondents, and those who don't.

Kirsi, are you restoring the database to a different server?  If so, I'm wondering if perhaps some of your database objects are finding themselves attached to a user who himself...

I spent eight years on a project managed by an "accountant".  If offices were being shuffled and moved, every engineer, physicist, mathematician, and computer geek on the project came to...