We've used serverside triggers and database triggers to track logons. It helped us to locate users abusing a userid and password that they should not have been using. ...

If you are using SQL Server 2005 to configure memory to use more than 2 GB of physical, see the following topics in SQL Server 2005 Books Online:

Memory Architecture

Server Memory...

I think Arizona has it right (no DST)

😛

Which of the results do you expect should return?

Please provide sample data and table definitions for the best chance at getting an accurate answer to your question.

Nice...Braves trade with the Yankees

http://sports.espn.go.com/mlb/news/story?id=4764085

Yankees get better in the BullPen and the Braves get Melky - hmmm not sure I like the trade.

Try defining additional Protection Groups with backup definitions in accordance with your backup strategies for each database (or group of like databases).

Nice Article

GilaMonster (12/22/2009)

---

Um, let me think. No.

We don't ever get that kind of...

Greg Snidow (12/22/2009)

---

Now, it just so happens that yesterday was my birthday, and I know I never disclosed it. I thought for a moment I had encountered some one...

kfewer (12/22/2009)

---

I am new to SQL 2005 and am not a DBA. I have questions for setting up Database Mail. I have spent 2 days searching, which has left me...

jean-paul.accarie (12/22/2009)

---

Thanks,

Finally I used following solution

If @Param_Year = '2009'

SELECT col_2009_name1 AS name1, col_2009_name2 AS name2

FROM my_table"

else

SELECT col_2010_name1 AS name1, col_2010_name2 AS name2

...

How would that intro go?

Behold the Powerful semi, sort-of,quazi,...

Lynn Pettis (12/22/2009)

---

I'm starting to notice a trend in a few questions where people expect tables to store records in a specific order. Anyone else seeing that trend?

(Okay, two...

smithsp17 (12/22/2009)

---

Am I correct in assuming that Transaction replication with Immediate Updating Subscribers also requires primary keys to be added to each table, or at least each table that gets...

GSquared (12/22/2009)

---

Jedak (12/22/2009)

---

Toreador (12/22/2009)

---

"Due to the Holiday Season, and Frosty being a part of the season, an easy question was in order. "

It might be easy if you're American. Who's...