Your thread name indicates counting rows in table and you say in your reply, select rows.

Any way.

To Count rows

SELECT COUNT(*) FROM parts where partnbr not in

(SELECT DISTINCT...

How about guy. Creating DTS...

Hey Gus, how is it going on at your workplace? Are things settling down?

Greg, I did read Lynn's reply earlier, I sent...

Yes I did read the article, and the author's concern might be right.

There are Pros and Cons for every thing (including SQL Server on VMWare), only way we keep...

I am yet to read the article.

My immediate answer is, we are using or SQL Servers in VMWare, but also have a UPS that protects us from power failure....

Lynn Pettis (12/9/2009)

---

Krasavita (12/9/2009)

---

This is what I get:

Microsoft SQL Server 2000 - 8.00.2040 (Intel X86) May 13 2005 18:33:17 Copyright (c) 1988-2003 Microsoft Corporation ...

Oops I see it now.

I am habituated working in SSMS even with SQL 2000 Servers.

Right click on SQL Instance in SSMS, select properties, the initial properties windows lists the Server information, Product...

Copy the DVD contents to one of the local drives and run the setup. (check for disk space, I assume you must be having enough space.)

So after repeated attempts, the installation is failing with the same error?

Is the installation location on a local disk? Can you check that disk is available in windows explorer?

Have you Googled for the error and check for solutions.

From what I know...

As Jonathan has mentioned, change the pwd and let the user know it.

Alvin Ramard (12/9/2009)

---

Bru Medishetty (12/9/2009)

---

I see 4 Switches on...

Is it an Interview question?

If you have Server access, then a quick check in the SQL Server COnfiguration Manager would let you know, and Windows Explorer would help.

If you are...