Yes - and even for the experienced to remind them of the order of...

Gain

Cool beans. Glad it is straightened out.

pmadhavapeddi22 (2/12/2014)

---

jeff,

I have re written the query by joining the de norm table in from clause, but the no of

reads and cpu are high with the new query. Old query...

That's a job that I would look to tune right away.

Is it possible that some job out there could realistically run that long? Sure. But it depends on...

Agreed - thanks Steve

So you shared the portion of the script to add a login to a role. But what about the portion to grant the login access to the database?

When you...

Cloud 9

Yeah that is bizarre. Something must have short circuited that select at the time the backup was running. I haven't seen that happen before with this kind of...

phegedusich (2/11/2014)

---

I'm in the financial industry. We've purchased a data warehouse solution that allows us to maintain critical and sensitive data on-site. If MS continues their push to the cloud,...

float

I wonder if for some reason those database names are not selecting out of the sysdatabases and thus creating the failure.

What is the result of your select query that populates...

Jeff Moden (2/11/2014)

---

pmadhavapeddi22 (2/11/2014)

---

Jeff,

Sorry for the late reply,

continuation of the above topic...

As you asked, the below is one of the update statements we are using in stored procedure

Update de_norm_buscard_attr...

Lynn Pettis (2/11/2014)

---

First, this sample data really doesn't help. How do we know what stays corporate (AA) and what goes to the Atlanta Branch (AB) when everything above ends...

Good point Lynn