We do the files on the file system for our Intranet, but that's because we keep the files on the web server. We take the IDENTITY value generated by SQL...

If you run an NBTSTAT -a on the SQL Server, you can figure out where it's resolving. Here are the NetBIOS codes:

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

We've had some problems where our servers are resolving...

All right, the catch is you can't use foreach like you'd do FOR EACH in VBScript. You have to get each item individually, and of course, the array index starts...

A bit more about the problem...

Perl's Win32::OLE

doesn't seem to handle the ADODB.Errors object well. We've been trying to figure

out how to do the equivalent of:

For Each oError in oRst.ActiveConnection.Errors

...

This should go without saying but...

Rely on the algorithms that have been tested by the crypto community and found thus far to be strong... ones where if the attacker knows...

Do you mean setting a lock timeout value?

K. Brian Kelley

http://www.truthsolutions.com/

Author: Start to Finish Guide to SQL Server Performance Monitoring

http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1

1) A primary key can be non-clustered.

2) A unique index will allow one null value. Of course, if the column is set to NOT NULL, it won't.

You're going to actually have to parse it. It's in the format:

hhmmss

Where hh is the hours in 24-hour format. Not typically what you'd expect (usually when you see integer here...

Best practice says only servers directly exposed to the outside should be in the DMZ. Unless you're doing direct B2B connections or something of that sort, get that DB server...

quote:

---

5b. When I login on a remote client as TedN, use QA with "Windows Authentication" to access the Sql server, I get...

If you set the connection to named pipes, a shared memory protocol, you shouldn't see network traffic. Keep in mind that while TCP/IP is faster across the wire, shared memory...

One word: Sa-weet! Now to see if we can get a test in-house.

K. Brian Kelley

http://www.truthsolutions.com/

Author: Start to Finish Guide to SQL Server Performance Monitoring

http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1

The SQL Server 2K Resource Kit is on-line as well:

http://www.microsoft.com/technet/prodtechnol/sql/reskit/sql2000/sql2kres.asp

K. Brian Kelley

http://www.truthsolutions.com/

Author: Start to Finish Guide to SQL Server Performance Monitoring

http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1

quote:

---

I understand that the SQL Virtual Cluster assumes the MAC address of the new server.

---

Each...

Just to piggyback on Steve... SSL protects the data stream as it goes across the wire. That means if you're worried about someone sniffing the traffic between the web server...