I don't actually have a problem with using VB to create applications--VB.NET removed the most annoyingly retarded elements of VB6 and is a much more robust development environment. The issue...

And I would agree that the Windows Firewall is the place to be putting rules like this anyway, rather than hacking SQL to do the job...

I suppose the real question here is: do you intend to return more than one value from this, in which case you can't use a scalar function, or is the...

MSDN description of LocalSystem account is here:

http://msdn.microsoft.com/en-us/library/ms684190%28VS.85%29.aspx

It has links to the other two service account descriptions.

The only differences in network access between LOCAL SYSTEM, LOCAL SERVICE and NETWORK SERVICE relate to what credentials they supply when they access the network, AFAIK. LOCAL SYSTEM and NETWORK...

Is that Experience Index measured in Vista or 7? 5.9 was the highest possible value in Vista, but it got boosted in W7...

I can see a potential issue here. You say users have lost data--but what if other users have updated the same database after that data loss? If you roll it...

I would suggest firewall as well--the one in 2008 R2 is quite a bit more complex than the one from 2003 (and I think the one in 2003 was turned...

Just to also point out, LOCAL SYSTEM has the same network access privileges that NETWORK SERVICE does--both identify themselves via the computer account when connecting to network resources. It's in...

Bear in mind that...

Why does the question specify SQL 2008 when the limit for this, AFAIK, was the same in earlier versions? Thought it might be a tricksy question about filtered indexes till...

I disagree. I think it's being a bit nitpicky to say that "Oh, you can run T-SQL code in SSMS so you can therefore create database snapshots using it". Besides,...

If I'm "in the zone" and really concentrating on something I prefer absolute silence. Music just becomes a distraction, and I really don't like the phone ringing or people talking...

The Copy Database option requires SSIS, which is one of the features Express doesn't have (AFAIK). That's why you don't get that option.

I got the right answer but for the wrong reason--I thought temporary items wouldn't show up in sysobjects, so I learned something today! 🙂