It is very good to know that my screw up is benefitting the database society as a whole. 😀 Keep learning.

The reason for the nulls is due to the fact that you don't have your XML paths setup correct when using the Openrowset. It is similar to above in...

Really there are two ways that I preferred to get the data out, and it really depends upon what I am doing and how often I am doing it.

The first,...

sqlqueue (4/14/2009)

---

Hi Experts,

can you confirm the query to pull out only one latest record for each name descending with date so in below case i just want to pull Harry...

I am not sure about the XSD file as I have never tried. However, for an xml file, I just cheat a little bit.

In BOL, checkout bulk...

mmitchmcp (4/14/2009)

---

I have a table with a column of data for a period of three months. The data in the column are lower by a factor of 18% due...

That looks like a great article I will have to read this weekend. Thank you very much.

Fraggle

Thanks for the updates on the flags. Good to know.

Fraggle

Well I figured out the issue and it has nothing to do with the trace flags.

The drive were we keep the logs filled up. Here is the really funny...

I have tried both Windows Authentication and Mix Authentication. I have also tried using the SA login/password for it, just to verify that it wasn't an issue there. ...

Damn, and I haven't had much luck finding anything on that article in Technet you were telling me about.

Let me know if you think of anything else. I will...

The ODBC connection that I setup uses a loging has administrator rights in sql server.

Creating a table didn't help either.

Fraggle.

I will have to take a look through Technet then. The account has administrator rights.

Let me know if you think of anything else.

Thanks,

Fraggle

Those dmv give some of the stuff I am looking for. However it doesn't have everything. I am looking for server statistics as a whole, not just the...

And the light bulb has gone off. Thanks for the great explanations guys and gals.

Fraggle