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...

You can't use a text variable, but you could try breaking this up. Maybe going with the top 100, then looping through successive groups of 100.

However, I don't understand what...

Doh, I thought I corrected those typos. Must not have saved it in my ID -10-T moment :w00t:

This is a known issue and you need to create a job to run 7.0 compatible databases.

I'm not sure why, but this was a design decision to not handle 7.0...

It's hard to know. The application could support multiple names, there could be caching, etc.

I'd probably schedule this for a slow time or off hours. Change the name and try...

You shouldn't change max worker threads.

Do you mean 1000 people querying the server at the same time or 1000 connections? Both are possible, just depends on the server, app, queries,...