You saved my life! lol

The only thing missing was the 'T' between the date and the time, everything works perfectly!

Thanks a lot!

1 : You're confirming what I thought, I dropped that idea, will never work.

2 : Well I went with the idea that if I can do something like this it...

lmu92 (1/7/2010)

---

What xml element/attribute describes the column name?

Your examle is only using data from a column. There is nothing indicating any relationship between node_a and localname, meaning: How do you...

Or a way to populate a temp table with the XML and build a dynamic SQL update statement from the temp table...

What values did you use? I got the same problem and can't seem to find what should go in those two fields.

Average CPU usage falls below : ( x )...

Thanks, I'll try it tonight. I don't know much about the SQL system tables, is there a way I can find deadlocks and kill them?

nekonecny (5/21/2009)

---

It seems problem with spn. When sql server starts, it creates spn in Active Directory. The SPN is an object in Active Directory. You can set the permissions with...

Found the link : http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_22542188.html

Which seems to be very similar :

SQL Server is cutting off client connections intermittently and I'm having a hard time figuring out why....

The situation is this : the problem persisted for several days, one week to be +/- exact... and now everything's back to normal, why? Didn't find out yet...

When I go...

DBCC results for 'TBL72VTESINPUT'.

There are 1276304 rows in 50618 pages for object "TBL72VTESINPUT".

DBCC execution completed. If DBCC printed error messages, contact your system administrator.

So it seems the table is not...

It gives me "Command(s) completed successfully.", nothing else.

Does that mean the database is not corrupted? Or that there is something I don't see right now on my screen?

Just the pop-up : "ODBC Error on tblSales"

I'm running the DBCC, I'll post the results as soon as possible.

Well, I don't think tables change structure everyday, but there's at least a new table every week.

The primary goal is to get the same structure without all the data because...

Didn't...

SELECT BON, TXND, SUM(1) AS CNT

FROM TBL_TEST

GROUP BY BON, TXND

That should do the trick.

Values in the table :

BON...