I agree, The database owner change should have no effect on people using the database if it has not had any effort so far.

Mr. Celko does enjoy stretching people's patience and tolerance.

I haven't often imaged the system, usually because in the event of a move to a new system, I'm dealing with new hardware, or I might be.

This is one place...

It's working for me.

Are you sure you're logged in?

Going here: http://www.sqlservercentral.com/articles/StreamInsight/70160/

This login is linked to a user in that database, correct? Verify that. The name being the same does not mean they are linked.

CirquedeSQLeil (9/30/2010)

WayneS (9/30/2010)

If he's in his...

You can read the code from the table and store it in a variable

select @col = col1

from mytable

And then execute it

exec(@col)

It you need to change databases, I'd query...

The files are being written to, but I am not sure that the file timestamp gets updated on every write. It might not occur until the file closes. SQL Server...

You can pay at the door. I'll have Grant standing there intimidating people into giving up $30 or a ticket :-P:w00t:

It's why I like doggie doors 🙂

There is no event set up right now in the Boston area. What you can do is go to your local user group and ask if they want to run...

In Seattle, I have used the Gray Line (N end of the airport) to get to downtown. It hits most Summit hotels for like $11.

There's also the new light rail...

Nice article.

I think the power of PowerShell comes not with handling tasks like this once, but with the reuse that can come with CMDLETs, across multiple systems and across time.

I'd...

Late

It's late start Thursday. Kids go to school an hour late, so I can sleep in.

The answer choices have been corrected and points awarded back.