Viewing 15 posts - 601 through 615 (of 1,292 total)
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...
December 9, 2009 at 12:45 pm
Lynn Pettis (12/9/2009)
How the .... did this person get a job in IT?????The force in this one is not only weak, I think it is nonexistant.
December 9, 2009 at 12:37 pm
Hey Gus, how is it going on at your workplace? Are things settling down?
December 9, 2009 at 12:23 pm
Greg Edwards-268690 (12/9/2009)
Bru -Note the Intel x86 in the string that Lynn was pointing out.
You must be having a long day.
Greg E
Greg, I did read Lynn's reply earlier, I sent...
December 9, 2009 at 12:13 pm
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...
December 9, 2009 at 11:38 am
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....
December 9, 2009 at 11:20 am
Lynn Pettis (12/9/2009)
Krasavita (12/9/2009)
Microsoft SQL Server 2000 - 8.00.2040 (Intel X86) May 13 2005 18:33:17 Copyright (c) 1988-2003 Microsoft Corporation ...
December 9, 2009 at 11:15 am
Oops I see it now.
I am habituated working in SSMS even with SQL 2000 Servers.
December 9, 2009 at 11:06 am
Krasavita (12/9/2009)
How to know if I in 32 bit or 64 bit enviroment.
Right click on SQL Instance in SSMS, select properties, the initial properties windows lists the Server information, Product...
December 9, 2009 at 11:02 am
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.)
December 9, 2009 at 10:35 am
So after repeated attempts, the installation is failing with the same error?
December 9, 2009 at 10:12 am
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...
December 9, 2009 at 9:53 am
Krasavita (12/9/2009)
I created a user and password and user doesn't rememeber password,how can I find out his password?
As Jonathan has mentioned, change the pwd and let the user know it.
December 9, 2009 at 9:47 am
Alvin Ramard (12/9/2009)
Bru Medishetty (12/9/2009)
Grant Fritchey (12/9/2009)
I always forget this one. How do you flip the "run faster" switch to the on position in SQL Server?
I see 4 Switches on...
December 9, 2009 at 8:47 am
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...
December 9, 2009 at 8:42 am
Viewing 15 posts - 601 through 615 (of 1,292 total)