Please don't cross-post. Let's hold the discussion over here.

OK, how about "all the databases you should be messing around with" can be accessed through sys.databases? :hehe:

True. Thanks...

Well, understand, I am adopting a middle way on this. Unfortunately I'm working with developers who are not. They're goal, stated, is to get DBA's out of the way so...

dsimpson (8/6/2009)

---

I am trying to combine these 2 sql querys from one table into the result set below. I am having trouble figuring out how to get one result...

Check out the system table sys.databases.

Are you planning on storing the text, as text, or were you planning on dividing it up into some kind of relational or dimensional storage so that you can run...

How about trying a GROUP BY on the incoming date and a MAX on the effective date?

SELECT e.IncomingDate

,MAX(e.EffectiveDate)

FROM dbo.Employees e

GROUP BY e.IncomingDate

Wouldn't that do it?

You can get the list of deprecated items from a search on MSDN. You can run DTS inside SSIS, but the behavior is very inconsistent. You'll need to do a...

Is there a trigger or something that relates dbo.intPolicy and dbo.afl?

If you're using the command "backup database" then you're getting a bit-by-bit copy. Nothing should be lost, data, structure, procedures... nothing.

First, two instances on the same server are likely to run into contention. In all likelihood, one of them is using all the memory and the other is starving. As...

But you're not going with VSS are you? 3rd party perhaps?

I'd think that MS must surely get TFS on to 64bit most riki tik.

Sounds like you have it well enough in hand based on what you're dealing with. Did you get the kind of information you were looking for?

GilaMonster (8/6/2009)

---

Grant Fritchey (8/6/2009)

---

Jeff Moden (8/6/2009)

---

I've not confirmed my plane reservations but I'm 99.99% sure that I'm going to be in Lil' Rhody from 9/6 to 9/12. That means...