opc.three (9/7/2012)

---

na1774 (9/7/2012)

---

So accoriding to the above logic. I have to Deny View Any DB first. THen make the login owner of the DB. Then it will be not be...

Is this a DTS job or is it an SSIS job?

sqlguy-736318 (9/6/2012)

---

Hello - I think around 10 years ago there was a trend where data model designers were putting table attributes in an attribute table as opposed to defining those...

What is probably happening is that the SQL Server session and connection associated with your SqlDataReader are not being disposed of properly.

Here is where I think you might be going...

Do you have something that does what you want for a single database?

Preliminarily, here's the Query I would start with:

;WITH

cteMeasure As

(

SELECT m.[Patient_ID], m.[MEASUREMENT_DATETIME]

FROM ...

Also, the sreenshot is telling us anything useful, just the index names, which isn't a lot of help. You can get the DDL for the tables by scripting...

OK, several things:

1. The query that you posted is not the same as the one that was used in the query plan. Leaving aside the name changes (which we...

This probably belongs in one of the Reporting Services/SSRS forums.

In particular, make sure that your source text file is not in UTF-8 format.

Stefan Krzywicki (9/5/2012)

---

"Root" is the proper pronunciation as Nat King Cole...

The utilization of what? The word "utilization" does not mean anything by itself, it has to be applied to something, like a resource. "High CPU Utilization", "memory utilization",...

Post the DDL for the tables, including their keys and indexes. Also, please post the execution plan.

Duplicate Post. Please do not cross-post, it just confuses attempts to help you.

Please direct all responses to http://www.sqlservercentral.com/Forums/Topic1354967-1633-1.aspx

I think I speak for most of us when I say "What's 'the DCL'?"