The firewall is a Vista thing. Check the control panel, Firewall. Be sure that it allows SQL Server or 1433, 1434 through.

Cathy,

There's also a Forcibly Shrink the log script here [/url]on the site that will run a few transactions and shrink the log. It repeats this to clear out VLFs and...

I'd suggest you reformat the query as Bryan has, but use aliases for the tables. It will make it much easier to read.

Then if you can't get it, explain more...

Also, if there's something specific you are wondering about, let me know. I've written some updates from past summits, but I'm not sure I'm capturing the event. My blog here...

This is my first time to Connections, so I can't answer. You might ping Brad McGehee from his blog and ask him.

I think that most conferences have a lot of...

ApexDiff should allow you do generate a script you can give to people. SQLCompare does.

The restore should allow you to restore to a different name and path with the MOVE...

Be sure you allow remote connections. This is disabled by default in some places.

Also, check the firewall. That would be my guess that it's preventing TCP 1433 from coming through.

I'd really recommend you look at one of the compare tools out there. I work for Red Gate, but ApexSQL and other companies have similar tools.

It's not that this is...

They do repeat some popular sessions at PASS on the last day, but no guarentee they'll be the ones you want. They record all sessions, and they offer some online...

Very strange. I might look at the Process utility from sysinternals and see if you can get some clue about process might be stuck there.

I'd be curious to know what you decide to do and why. It's a good debate, and others can learn from this. If you have a blog, post it there...

Be sure you log on as the SQL Agent account to check things. It's possible that there was a security difference.

The other thing to look at is could the...

I'd say PASS, but get a list of questions on internals that you want to learn more about. Have a notepad, and ask a few of the experts or MS...

I use it for the same reasons, but I don't believe you can do this with tempdb.

tempdb is used for all sorts of operations in databases. If you take tempdb...

You would need to determine what queries are being run. This will be in the code or you can use Profiler to check what is happening.

From there, try running that...