You make a decent point, Andrew. And Admin accounts should always be heavily audited. We have S.A.M. on our servers which actually makes us enter reasons we logged...

Thanks, Matt. I appreciate the clarification.

Looks interesting. I'm going to have to test this one and see if it does any better or quicker than what I eventually...

DOH! Found my error. I had t2.CalMonth - 1 and should have had t2.CalMonth + 1.

I feel sooooo stupid.

Thanks, guys. I appreciate it. As far as...

Okay, this doesn't appear to be a CTE problem so much as it is a confusing addition problem.

ARGH.

I've changed this to a WHILE loop only and it's still giving me...

Oh, that's a horrible thought!

I want to be able to see these jobs and know what each one does without opening them up and finding the report ID info. ...

I used to think that too, but actually no. The FROM clause is the one place where the UDF doesn't execute once per row.

Remember that a UDF...

Sounds like you need to incorporate your reports in a Dashboard tool.

I know Crystal Excelsius does something similar to what you're talking about, but it usually uses Crystal reports instead...

Andrew said:

I think thats great if you have the time, however as most have better things to do just identify what it is you need and leave it up to...

The other suggestion will not give you a vertical split. It will give you a horizontal split. There is no way, that I am aware of, of doing...

The big thing, IMHO, is whether or not your job duties require that kind of access to the server.

Where I work, the DBA team is responsible for the "soft" server...

DUDE! Who told? We had to sign a conference call NDA regarding that information....

The "view report" button is a Microsoft program thing. I haven't heard of anyone being able to change the caption on it.

Someone let me know if you've been able...

I ditto the Vista issue. Learning a new OS while trying to learn SQL Server is NOT a good combination.

As far as laptops go, I've got an older Sony...

Beta exams are invite only, as I understand. However, if you get a specific Microsoft e-newsletter, you can see where they make these announcements (and that is a sort...

It's not for internal Microsoft people any more. Anyone who is an employee of a Microsoft Certified Partner (not just a gold partner) can now attend the Architect program....