I'm going to reiterate what I said earlier.

Use DDL triggers to log changes to a table in an Admin database. Use a Datetime column to log the time the...

Glad we could help. @=)

And thanks for posting your solution.

We actually have this working with attachments, but it's been a while since we set it up.

However, just got a new Dev cluster, so I'll play with it in the...

As soon as I find some data and code I can post without having to sanitize it first, I'll put up an example.

RBarry,

Depends on the situation. You can't always fix the Group By. Sometimes it screws up your result set if you do.

Believe me, I've tried that. Sometimes fixing the Group By...

Wait a minute. I just looked at your data again. You're not doing a pivot. Not even close. Pivot is where you change your columns into rows and rows into...

Matt's correct. You have to have a PIVOT to aggregate your rows onto the column. Otherwise, what's the use of the pivot?

Of course, you can put a dummy aggregation in...

Oy, I wish!

However, there's a minor workaround.

Register all your servers in the "Registered Servers" sidebar. Keep that pinned open so every morning, all you have to do is doubleclick...

Aha! Remembered what it was. This is a poor example because I can't give you my real data and I had a much more complex query. Suffice to say, though,...

Sounds to me like the test script is trying to alter some other account's login / permissions information. That might be why it needed SA access. Of course, the account...

PerfMon can also be used to check things like RAM usage, even for SQL Server. I can't remember which SQL Server counter it is, though, off the top of my...

Fernando,

You actually have a pretty good solution. Unless the table information needs to be further processed, that proc is a quick and dirty way to get the list. The proc...

You're asking us to diagnose a problem without telling us what your error is or your expected results from the comparison. If you truly believe a table JOIN is not...

A note on "sessions". In SSMS, a session is one continuously open query window or, in other SQL apps, one continuous connection. You can't do Identity Insert in two separate...

Did any of our comments help? Is your problem resolved?