That's correct, Exec applies to functions and stored procedures.

SELECT applies to tables and views.

Not until you deploy the scripts to production.

Script the restore along with your procs and make it one thing to run .

The typical plan from MS is to announce deprecation in a version, say SS2K8, for a feature, continue to support it in the next version, say SS2K11, and then remove...

Perhaps things are mis-worded, but I think the answer is fine.

Connecting via IP and port would be connecting to my local server as 127.0.0.1, 1433

That would not use the Browser...

Manie,

Great article and thanks to everyone else for the great complements. We try to help where we can.

Based on that log, SQL is started.

Are you connecting to one of the nodes or the virtual instance?

Works fine for me. Perhaps a firewall thing?

Wayne,

got a shot of you in here:

http://picasaweb.google.com/dkranch.stevejones/2008PASSCommunitySummit

As a side note, if you want power in a session, get there early. Jonathan tends to scope out those seats near outlets and grab them early 🙂

Good to hear you enjoyed it.

Come back next year!

Nice post above. It highlights some interesting things.

I'd still think that if you started with a good Open Source solution, you might end up with something better in the long...

Interesting video, thanks for posting.

You could import the Access db periodically and look for changes.

Either in Access or SS, I'd be wary of "real time" alerts. You often find that you didn't mean to...

Good to see that many people build their own "mini-mes" to help them out.

And some interesting solutions. I might look to modify some of our systems based on what's in...

Just use the concatenation operator, +

declare @i int, @j-2 int

select @i = 0, @j-2 = 0

select

case when @i = 1 then 'Test'

else 'Live'

end

...