Try this: http://support.microsoft.com/kb/307487

Only if the client sends it in. the hostname is usually in sysprocesses (sp_who2) when the person connects, but I'm not aware of a way to audit this from SQL.

What...

I'll add that to the list. I don't track a source there, but maybe the programmers can add in a "domain" item.

You can also check the website and that has...

Very nice, Phil!!!!

We'll see if we can get this added and we're working on the double/triple spacing.

John,

We use Hamachi at End to End training to connect remotely. I admit that I was a little worried about security with that project, but it's worked well and no...

Probably because we're lazy in the US. Stick with what was working, etc. 😉

I'm sure many of you in the UK and elsewhere deal with this, but I was going...

This is strange.

Check the system log for errors. Also, check the sql log folder for what's being written there.

do the master, msdb, and model databases exist in the file system?

That's strange. Did the service start?

Are you sure that name matches the Windows name exactly?

Someone is reading the db. I'd remove all connections from the db and then you can make the change.

You might need to "pause" the service, kill connections, then make the...

Definitely be aware of the Standard v Enterprise/Developer features, but you should be able to develop on your laptop.

I'd recommend weekly, if not daily builds that get dropped somewhere and...

For most of us, we drop the CD in there and click next. There's no magic to installing it on W2K3.

If you post the errors you're getting or the issues...

Ah, forgot about the editorials. The articles have a "source" (sqlteam, database journal, etc), but those don't. I can try to include a note about the domain in there, which...

Whew! That's an ugly query. Are the OR clauses supposed to apply to the whole WHERE clause or just a particular statement. Meaning is it

WHERE x = 1

and...

I think you need to provide more information about exactly the code being run. It's not clear from your post what's happening.

Jobs don't run from clients. They run from the...

Frank,

What are you querying on? Maybe you can give us the table schema and let us know how the queries are structured.

If there are indexes on those columns, and you...