I'm pretty sure you have to change them one at a time. It's one of the few things cursors are really useful for.

Are you familiar with the view sys.all_objects? That'll give you a list of all tables, views, procs, etc., in the database. Should be able to find what you're...

Yes. I've done that.

I'd definitely do backups, but the easiest way to get the databases back online will be detach, re-attach.

On the system databases, it kind of depends on what you've got in...

The solution I posted will handle down-time that spans multiple days, crosses the boundaries between Day and Night, etc. It just depends on how big a number you allow...

Mark, that will produce a count of 1 if there are zero rows in the outer join, if I'm not mistaken. Test it and see what you get.

Here's what I come up with. You'll need to change the temp table to your real table, of course.

if object_id(N'tempdb..#T') is not null

drop table #T;

create table #T (

AUDIT_ID [int]...

I do both.

I certainly answer my share of questions on this forum. I also give blood, spend hours almost every week on community volunteer activities, donate a little more...

Dan Guzman - Not the MVP (11/30/2009)

---

The latter, though technically Irish, which, if memory serves is part of England, but my grand parents are probably spinning in their graves at...

Do a cross join between departments and grades, then a correlated subquery on employees from that.

Would look something like:

select DeptID, DeptName, GradeID, GradeName,

(select count(*)

from Employee

where DeptID = Department.DeptID

and GradeID =...

Not directly database related, but if I were naming a boat for something IT-related, "Sea Sharp" comes to mind.

GilaMonster (11/25/2009)

---

GSquared (11/25/2009)

---

Frequently. Often associated with strikes and demonstrations.

Never had a local power outage due to a thunderstorm or some idiot drunk-driving...

If what was needed was a string parser with multiple delimiters, I'd have...

Insert dbo.TheThread (Messages)

Values ("Welcome Back Barry")

Yeah, okay, I'm back to thinking in SQL after a week of thinking in turkey.

(My church flew in five-star chefs from New York for our...

roelofsleroux (11/25/2009)

---

Hahaha!

Gila you sound like Doomsday Prophet. This is South Africa. The only natural disaster we know of so far is a flood 21 years ago that destroyed a town....