When a client first connects to a SQL Server, it talks to the server's UDP/1434 port. That's the destination port for the client. The source port on the client is...

And you won't be able to. Without a domain controller, that means all computers are in a workgroup. Even if they all are in the same workgroup, there is no...

I cover mine in my eBook, but it doesn't cover scans in the detail you're looking for... I was more geared towards overall health of the server. My homepage (Professional...

When a login doesn't map into a database by any other context (user), if guest is enabled for the database, the user gets the rights assigned to guest. The databases...

The best architecture books are:

Inside SQL Server 2000 by Kalen Delaney

The Guru's Guide series by Ken Henderson. The last of the series is specific to internals.

SQL Server 2005 books...

Most tend to be cumulative... kind like how they deal with DNS. Closest thing to versioning:

SQL Server Version Database

About the only other thing you can do is find out...

SQL Server you can usually tell by the results of @@VERSION. Or are you speaking of the OS?

This is all true... however, I can personally attest to the fact that my organization was required to ensure no personably identifiable information of this sort was allowed out. Since...

No reason to cross-post.

Domain local groups should be seen by the SQL Server if it's in the same domain. The mode (native vs. mixed) doesn't have an impact on the domain local group......

I look for periods where I know there's going to be "dead time." For instance, when you get into a meeting and you wait for everyone to show up... that's...

The DTSRun utility is making a connection back to the SQL Server you have specified with the /S parameter. The DTS package is stored in the msdb database and as...

Gone through both as well as a couple of Systrust categories. SAS70, in general, was not as strict as SOX. Ours did a review of access, as indicated by kc,...

When you get the error, does it indicate the login failed for that particular user or does it give a different error message? When you say "all the users in...

The problem is DTS executes through the use of an executible, dtsrun.exe. Therefore, from within a stored procedure the only way to do this is to you xp_cmdshell... not exactly...