The only other way that might work is with a log reader tool, but you would have to purchase them.

The default trace is what I'd suggest first.

You wouldn't want the sa password to be scripted out, even encrypted. That would allow someone the chance to move it to another instance and spend time trying to crack...

I guess my...

I've never seen that before. When you say installed, do you mean media? Or an .iso you downloaded?

On one hand it's good to have that stuff posted. Helps to weed out the people that don't bother to research anything.

Horses

Grrrr, busted out this morning and forced a chase by the inept guard (me)

Indexes are built using extents (allocations of pages ) in the db file. As the index is built, it gets new pages from the file that are not necessarily contiguous,...

Note that you would take the output of Lowell's script and execute it in SSMS as a query to alter all tables.

The idea is that you are using code to...

We've done a variety of things here. Bike rides or hikes usually go over well with the kids in Colorado.

Movie night, video game times, those are fun. We've gotten Rock...

The typo is corrected and I will award back points for those that might have mistakenly picked up on that.

I know that some of these people are annoying, but let's try not to pile on too much. Just post that you expect them to do some work, or something...

The presentation talks about people writing "=null" not "is null", and gives the latter as the proper way to test for NULL.

Multi-row triggers are something that people commonly do not...

You run this as T-SQL

http://technet.microsoft.com/en-us/library/ms188787.aspx

I'll try to make it. Not sure about the timing

Express does not allow remote connections by default. Use sp_configure to change this

sp_configure 'remote access', 1

RECONFIGURE