Create a temporary table. Insert into it using EXEC xp_cmdshell as the source. Then you'll have to filter through the temporary table.

K. Brian Kelley

http://www.truthsolutions.com/

Author: Start to Finish Guide to SQL...

There is a known issue with Wndows 2003 and SQL Server 2000 engines. You need to apply SP3 if you haven't already.

http://support.microsoft.com/default.aspx?scid=kb;EN-US;329329

K. Brian Kelley

http://www.truthsolutions.com/

Author: Start to Finish Guide to SQL...

They do work. They even work in the case where SP3 doesn't go on, such as with some MSDE installs.

K. Brian Kelley

http://www.truthsolutions.com/

Author: Start to Finish Guide to SQL Server Performance...

I cover this in:

http://www.sqlservercentral.com/columnists/bkelley/sqlserversecuritysecurityadmins.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

The 8.00.XXX info is usually found in the readme file that comes with each service pack. Alternately, Chip Andrews usually keeps the version numbers on his site, http://www.sqlsecurity.com/

HTH.

K. Brian Kelley

http://www.truthsolutions.com/

Author:...

quote:

---

* "I think a lot is being read into what these questions are supposed to represent. "

[This is occurring because the question...

quote:

---

What difference does it make if the rights are explicit? The user still requires them.

---

Yes...

From the command-line:

net user <user id> /domain

This will hit against a domain controller.

Keep in mind there's a lot of information that'll be returned, so you'll basically have to dump the...

You have to have Windows 2000 Advanced Server and SQL Server 2000 Enterprise Edition. Clustering is part of Advanced Server.

K. Brian Kelley

http://www.truthsolutions.com/

Author: Start to Finish Guide to SQL Server Performance...

I have a shutdown script where I shutdown one server about 30 seconds after the second just for the case you've indicated. This ensures the nodes go down gracefully and...

quote:

---

Now, your "correct" answer says that a login is all that's required, and furthermore it indisputedly implies that database permissions are *not*...

It should keep the order intact.

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 NULL value, is that the integer code coming back or what's in the temporary table from the execution of xp_cmdshell?

K. Brian Kelley

http://www.truthsolutions.com/

Author: Start to Finish Guide to SQL Server...

quote:

---

While it is correct that you JUST need a login to SQL server, you are added to master because of the default...

I didn't write the question, but here's my view:

Frank is right in that you do have a login, but you make a good point if that login is a guest...