Mat,

You may be better served to post a new thread, especially since only NoelD and I posted on this one. Also, you may want to post the original code...

We are installing SS2008 Express on a Dell server in our lights-out data center. The virtual server's operating system is Windows 2008 Standard Edition SP 2. All necessary...

@halcyon

Installing using the built-in admin account. Followed the directions in KB article 2000257 and found I needed to turn on the debug permission, backup and audit/security logging...

For details, you can look at this web page, containing a few more details: http://serverfault.com/questions/186550/can-not-install-sql-server-2008-express-or-standard

Did you check the logs in

c:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\date_time\Summary <server name>_date_time.txt

where you replace <server name> with the name of your server? You will find extensive diagnostic information...

This may seem like an obvious question, but what's the full name of your installer file?

It turns out that, by UNINSTALLING the installer (and .NET for good measure), and then rerunning the installer, the installation got past the points where I was experiencing difficulties (other...

The C2 audit feature captures everything. That is more than we need. One of the validating aspects of capturing logout as well as login, is to understand duration...

One last observation: I unformat the current system date-time (using substring and cast) and append to the log file name in the stored procedure, thereby making the stored...

Yes, Jim, you're right. Audit would make life much easier. Unfortunately, it's painfully difficult to justify an Enterprise Edition over Standard Edition for a single server.

I'll have to...

Does your VB process use a single login to the database or pass the user's login credentials through to the database? You may need to capture this information inside...

It looks to me like the trace file ID suffix is being captured in hexadecimal, and needs to be converted to decimal in order for the file name to be...

Brian,

Are you positive that Audit is NOT available in Standard Edition? There seem to be some capabilities built into SE. If it is NOT available in SE,...

Jasmine D. Adamson (10/30/2009)

---

arms.dan (10/30/2009)

---

Your off-hand comment about naming the field "Gender" rather than "Sex" piqued my curiosity. Why? As I understand the words, sex means biological differences: chromosomes and...

Stephen.Richardson (10/30/2009)

---

-- Create table

CREATE TABLE dbo.xSource (Name VARCHAR(50), Age TINYINT, Sex CHAR(1))

INSERT INTO xSource VALUES ('Stephen', 43, 'M')

INSERT INTO xSource VALUES ('Stephen', 43, 'M')

INSERT INTO xSource VALUES ('Stephen', 43, 'M')

INSERT...