There are two lines of thought on the NULL usage. One is if the value is truly not known, don't put anything in there. The other says force...

Is one of the DBs active and the other stand-by, or are both active. Also, are you using SQL2K Standard or Enterprise Edition?

K. Brian Kelley

bkelley@sqlservercentral.com

http://www.sqlservercentral.com/columnists/bkelley/

NULL is pretty straight forward with a good analogy. Imagine one of those guess the marbles in the jar contents. If I take marbles from the jar, I...

Celko's contributions to the SQL community are well-documented, but I agree that his writing can be a little difficult to read.

K. Brian Kelley

bkelley@sqlservercentral.com

http://www.sqlservercentral.com/columnists/bkelley/

It is a help file, but from the Start menu it's titled Books Online:

Most of the time I go to the index section when looking for something. ...

The ability to design in the language of choice and still get the same end-product may be a pretty important key. For instance, Fujitsu is working on a COBOL...

If you have SQL Server 7, look at the Books Online documentation that installs with the software by default (though you can select not to install it). It's a...

What caught my eye was the following:

quote:

---

At the same time, we had moved Servers Also.

---

You've...

Upon further testing, I forgot runas prompts for a password, which won't work for sending through xp_cmdshell. The net command can take a password... grrr.

K. Brian Kelley

bkelley@sqlservercentral.com

http://www.sqlservercentral.com/columnists/bkelley/

It's a trade-off, and I don't really like either solution very much. However, it's probably the fastest way I can collect and parse the data I need in a...

One thing you have to be careful of is that you're client isn't setting Quoted Identifier on.

For instance, in Query Analyzer for SQL Server 2000, though Books Online...

Normally I have it as a domain user with local administrative rights to the server itself, and no more. Steve's comments well illustrate the 80-20 rule. You *can*...

I've written briefly about this in a general article on services:

http://www.sqlservercentral.com/columnists/bkelley/services.asp

Chris Kempster has focused an article solely on security that does provide coverage of the service account:

http://www.sqlservercentral.com/columnists/ckempster/sql_server_security.asp

Give the account the...

I don't like the trigger method much either because of the extra overhead from executing the trigger, if nothing else. Worrying about caching and/or recompiling and the rest that...

I don't have the docs for SQL 6.5, but SQL 7 and above, DDL would be as follows:

ALTER TABLE <Table Name>

ALTER COLUMN <Column Name> <Data Type> <Nullability>

This can be passed...