GilaMonster (8/19/2009)

Do that...

All the job data is in the msdb database. I haven't used SQL 2000 in a couple of years, so I'm a little rusty on where to look, but...

You're welcome.

The screen shot looks correct.

If that's not doing what you need, then there's something about the file that isn't matching up. Perhaps the code page?

Yes. Depending on the complexities, we can come up with all kinds of ways of removing various patterns of strings from other strings.

I still think my first suggestion of...

It sure helps.

A lot of what you'll do in administration can be done more efficiently with T-SQL scripts than it can through Management Studio's GUI. Some things need to...

The query I wrote will give you the hour without the minutes on the ones you want that way.

It also handles last year the way you asked.

You don't need to...

SSIS could definitely be used to smooth out the import process and make it more self-correcting.

On integrating the dev and production servers, the easiest way to do that is to...

GilaMonster (8/19/2009)

Nothing really...

You get a DBA and a Domain Admin to look at what he was logging in to and what rights he has, and they will fix it for you or...

This will get you the data:

declare

@BeginDate datetime,

@LastBeginDate datetime,

@ConcludeDate datetime,

@LastConcludeDate datetime;

select

@BeginDate = dateadd(day, datediff(day, 0, getdate()), 0),

@ConcludeDate = dateadd(hour, datepart(hour, getdate()), dateadd(day, datediff(day, 0, getdate()), 0)),

@LastBeginDate...

It depends on what you're looking for. Most of the white papers I use on those are on the MSDN site.

Yes, that can be done in SSIS. It doesn't need a script task.

You would use a Data Transformation task to output all of the text files. You'd need...

You do that with Update...From in T-SQL.

Would look like this:

update cust -- use the alias for the target table

set OID = OID_ACTUAL, FCID = FCID_ACTUAL

from myschema.customers cust -- alias the...

There are tools that can do that for you, like Data Compare (RedGate) or SQLDiff (ApexSQL).

Otherwise, you're going to have to write a query that compares the data in the...