In Management Studio, Object Explorer, you have a Management folder. Click that, and in there is the "SQL Server Logs" folder.

There are also logs under SQL Server Agent.

GilaMonster (5/18/2011)

---

*screams*

When will people stop recommending Emergency mode repair as the default action with a suspect DB. That's about the 4th time I've seen that garbage this week.

Forget shrink database,...

Any ideas? It's for me, and not critical, but I found it interesting:

http://www.sqlservercentral.com/Forums/Topic1111177-392-1.aspx

Thanks for the update. I was thinking that it was an unwieldy amount of data for even small sets of data. 550B. Wow.

not yet

I've set up notifications, not just for objects, but also sp_configure changes and agent jobs, just to try and catch any "undocumented" changes.

My Posts definitely has a limit in how many is shows. It's partially a performance thing, and partially just poorly implemented. Have you tried the search in the upper right,...

Good question. A few people learned that the bulk logged mode allows for log shipping.

I think that's working longer.

Harder means doing things that are more challenging and more risky,...

It's not clear. Are you saying all permutations of numbers from one table, including non-existent values?

Because 44 isn't a permutation that's a combination of your input set. However if you...

A cross join will give you all combinations.

Dropping into a new table with an identity property will give you a count. Or you could use ROW_NUMBER() to artificially generate these...

Grant Fritchey (5/17/2011)

---

True, but this one time, I'm taking the supposed high road. I've posted that I have sessions. I'm done. Vote or not. I'm in or not. I'd love...

OCTom (5/17/2011)

---

Steve,

It's interesting that you mention plumbing. I spent most of last weekend replacing piping in my house. I find plumbing to be easy and enjoyable. I can sweat pipes...

dma-669038 (5/17/2011)

---

To me 'hard' is finding energy and smartness to pack as much as you can do in the time you have. Say i have 3 tasks to do -...

congrats