If you are using Full Text, the processing occurs outside of SQL Server and Full Text is more optimized for searches of this sort. I know you have an aversion...

Finally! Here is how to remove SQL Server 2000 instances manually:

http://support.microsoft.com/default.aspx?scid=kb;en-us;q290991

There are some registry steps as well, so as always, take the proper cautions.

K. Brian Kelley

http://www.truthsolutions.com/

Author: Start to Finish Guide...

I'm a big fan of the "lab" approach. Create some scenarious that require a candidate to code. Also create some scenarios that require a candidate to do some basic administration...

There's an KB article for manually cleaning up SQL Server 2000 instances, but I'm not having luck finding it tonight, though I keep hitting the SQL Server 7 one. It...

1st question: Was anyone using cluadmin at the time looking at the cluster? Perhaps there was someone doing something they shouldn't have been?

This one is an even greater stab...

Like it looks like they've applied here, you'll also want to throw on some full text indexes as well since you are interested in searching. The one catch with full...

Putting users in the db_ddladmin role will give them permissions to create objects. So long as they maintain their ownership, they'll have full permissions on their own objects. So that...

More on the licensing issue... you're not going to like what I'm about to say: it depends. I love the ambiguity!

We had this disucussion on a Citrix discussion list...

The asterisk is what is known as a "mask." Even though underneath the program knows what the password is.

If you store the password in the database, you won't be...

Running sp_helptext on any of the trace stored procedures returns a (server internal) message so Microsoft has chosen to hide it well. I suppose it's just as well.

I understand the...

The GO "command" is actually a batch separator for your client program. When a program like QA sees it, it'll say, "That's the end of one batch." So if you've...

If you could post what's in the first dump file, we may be able to get a handle on what broke.

K. Brian Kelley

http://www.truthsolutions.com/

Author: Start to Finish Guide to SQL Server...

Hi bglass, I had a long conversation with one of your developers (Chad S) last night on this issue as I know he's more than a bit disgruntled at not...

You can get the performance counters through WMI and through Perl scripts (with the right packages installed). It looks like Win XP Pro has a program called LogMan which allows...

Do you still have the original log files? If not, look in your LOG directory and see if you can find any .dmp files. These are text outputs of what...