Please don't double-post.

Andy Lennon (8/5/2009)

---

GSquared (8/5/2009)

---

You also have to assess the cost of protecting it.

If your company loses an average of one laptop per year, and spends an extra $100k per year...

Here's what I could come up with:

create table #T (

ID int primary key,

NR int,

Txt char(2),

Val1 char(1));

insert into #T (ID, NR, Txt, Val1)

select 1 ,1 ,'aa' ,'A' union all

select 2 ,1...

If you want SSRS 2008, you need SQL 2008.

MSDN has online tutorials that are a good place to start.

You also have to assess the cost of protecting it.

If your company loses an average of one laptop per year, and spends an extra $100k per year on encrypting hard...

I wonder if it's a problem with SSIS holding a lock on the file. Have you tried making the e-mail into a second step in the job, instead of...

SQL Iron Chef (8/4/2009)

---

GSquared (8/4/2009)

---

It sounds like you've got a good start on it.

To keep going, just keep one thing in mind: You'll get out of it what you put...

I would need to know what the procs are that are blocking each other and what objects they are accessing. Blocks aren't necessarily a bad thing. They just...

How long should the proc take to finish?

I have some that take a few milliseconds, and some that take an hour or more, and none of them are "broken".

You need...

I realized after I wrote my bit that it could be read as discouraging book-learning, and want to clarify that that's not the point. It takes a ballance of...

Ah. I get it now.

Using the schedule table and the sysjobhistory table, you could probably join them together and get the data that way. It's not going to...

How are you sending the e-mail? Are you using DBMail (calling T-SQL) or using the SSIS SendMail task?

msdb.dbo.sysjobschedules and msdb.dbo.sysschedules should have what you need.

You could use an identity column and a calculated column that adds a "U" to the beginning of the number. Will that accomplish what you need?