Interesting, Matt. I just double-checked and had my Windows Update re-check, and it still does not offer September BOL. You must be one of the lucky "early adopters"...

Matt, was your update for the September 2007 update? Or the...

Re: Books Online update.

Steve; I don't see a SQL Server Books Online downloadable update yet. The downloadable version is still May 2007. Online version is dated September 2007,...

Pam;

SQL Server 2008 will install on Vista.  If you want Reporting Services, though, it requires IIS 7.0, and only Vista Business and Vista Ultimate can install IIS 7.0.

You may want...

I saw a script here before (when I had to do the same search as you are doing) that used vbscript and WMI to scan the network looking for SQL...

I assume you've checked on typical Stop: 0x000007f problems (mismatched memory modules, bad memory).  Since it appears to be hardware/driver issue, and only when remote connection, my guess would be...

William;

While I have not tried much to use Remote Desktop TO Vista, I did have a suggestion you may want to make sure you are doing. 

Are you using the new...

Here's a slightly modified function that I use in these instances (modified to fit your example table, but not tested).  You have to ensure that you will not have any...

shailendra;

You might be more efficient having WHILE loop in the function instead of a recursive function.  Recursive functions certainly have their place, but I'm not sure this is one of...

Thanks, Brian, for clearing up the differences.  Makes sense now.

Real DBA might not use SMO.  But real GOOD DBA's do!

>However, if you want to go directly from client system to database server, that's where you're going to break down.

Brian: But how is it different with a web...

Consider also using uniqueidentifiers (or Guids), especially if using replication.  You cannot use identity if inserts can be done in more than one database. (which identity counter is current and...

I certainly do not want to contradict Brian (who can run circles around anyone else here on security), and I do not have the details, since it was our network...

I don't think so.  Database Mail is an SMTP Client, not an SMTP server.  You set it up to send mail to an SMTP server; that server will use MX...