I'd do one table as

create table(

id identity

, boxname varchar

, boxvalue varchar)

or with two tables, a lookup the the boxname and one for the values, FK to the boxname table.

Steve Jones

sjones@sqlservercentral.com

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

Used it (for the most part) as is. Modified the code a little, so we're behind in some areas from Snitz. Afraid to do the upgrade since it's pretty stable.

It...

The overhead for checks is small. Plus it's then distributed. I see a constant connection as a failure point, especially since if you do not check the link constantly, it...

I use SourceSafe, but script the entire db, everything, and be sure it is branched when the software code cuts. I'd keep this in a separate project with the date...

It was a problem presented to me and it was in a narrow scope. Thanks for pointing out those bugs, I should have included those limitations in the article so...

In real time or later from a log?

Would be easy to display the data in a web page. Like any other query displayed on a page. Hard to give you...

With a big stick, a loud voice, and a good audit policy

Steve Jones

sjones@sqlservercentral.com

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

Intersting. Looks like a bug. Tried this and it fails

select

len(col1)

, replace(col1, ' ', 'x')

, len(replace(col1, ' ', '-'))

, col1

from t1

From BOL, len returns the number of characters, not...

You can look at the MS Baseline Security Tool (http://www.sqlservercentral.com/columnists/sjones/reviewmicrosoftbaselinesecurityanalyzer.asp), but it has bugs.

There isn't a good patch manager for SQL. Hopefully one will get built soon.

Steve Jones

sjones@sqlservercentral.com

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

Agree with andy. It can cause disk space issues as the more your capture, the more is stored.

Steve Jones

sjones@sqlservercentral.com

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

I'd suspect you have an application problem. SQL Server should take up most everything except 128MB or so which is left for the OS. I had about 1GB of databases...

When testing Brian's suggestion, log into the server with the same account that SQL Server runs under.

Steve Jones

sjones@sqlservercentral.com

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

All services, including SQL Server, run under some account. By default, this is the local system account on the server, which CANNOT access domain resources, or any resource not located...

Do them as often as you can. Depends on time it takes to do them and your requirements.

There are scripts in the library here to do full backup. You could...

Check the event logs on each server. And set a different account for each SQL Server, it prevents this.

Steve Jones

sjones@sqlservercentral.com

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