You're welcome.

I still recommend moving away from this data model. Can't recommend a specific solution without more details about your structure, but there's got to be something better.

Not in the same database.

update dbo.Staff

set Col1 = (select count(*) from dbo.Activities where StaffID = Staff.StaffID);

Something like that.

Would snapshot isolation handle your locking/concurrency issues? That's pretty much what it's designed for.

First, having Activity1Count, Activity2Count, etc., is a violation of normal form basics.

Second, I wouldn't store those in a table. I'd calculate them at runtime in a query of the...

Do you have policies that are being applied to those logins? Like "Apply Password Policy" or anything like that?

I'd compute it in the proc that inserts the record. Parameters for region and dept, then insert and return the full name. That'll be easier than a computed...

That's WAY outside the realm of what a stored procedure can do.

Have you taken a look at SSRS? It can do some pretty amazing reports, with the features you're...

I have a daily and weekly summary that gets e-mailed to me before I arrive in the morning. Outlines what backups were taken, other auto-maintenance performed by a variety...

I'm assuming you've double-checked the recovery model and nobody has "accidentally" changed it. Right?

I saw that once, and since "everyone knows it's in Simple mode", there was a lot...

Well done and congrats.

sturner (11/19/2010)

---

VB is a language a lot of people use or have used but it has contributed to more poor programming techniques and software in general over the years (in...

You're trying to get SSIS to output an Excel file, right?

Just about any documentation on SSIS will tell you how to do this. Just Bing/Google/whatever "ssis export excel" and...

That kb article is about clusters, not about instances on a single machine. Given the data about the cause of the issue, I'm not surprised it didn't resolve the...

A proc? No. SSIS can do that easily.