Viewing 15 posts - 31,036 through 31,050 (of 39,824 total)
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...
October 11, 2007 at 6:08 am
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?
October 10, 2007 at 11:10 am
That's strange. Did the service start?
Are you sure that name matches the Windows name exactly?
October 10, 2007 at 10:06 am
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...
October 10, 2007 at 10:04 am
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...
October 10, 2007 at 10:02 am
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...
October 10, 2007 at 9:42 am
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...
October 10, 2007 at 8:03 am
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...
October 10, 2007 at 7:59 am
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...
October 10, 2007 at 7:50 am
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...
October 10, 2007 at 7:49 am
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...
October 10, 2007 at 7:46 am
Doh, I thought I corrected those typos. Must not have saved it in my ID -10-T moment :w00t:
October 10, 2007 at 7:43 am
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...
October 10, 2007 at 7:39 am
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...
October 10, 2007 at 7:19 am
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,...
October 9, 2007 at 5:56 pm
Viewing 15 posts - 31,036 through 31,050 (of 39,824 total)