MS SQL Server/Experts

Recent Answers

2012-01-21 sql query:

Dear Rakesh,    It seems that you want only 4 records out of whichever has price=2000.  So, if there are 10 records which has price=2000, you want to get only 4 records from those; correct?    In that

2012-01-12 sql query:

Dear Rakesh,      I think you mean that total 15 records have price more (or less) than 2000.    It should be a fairly simple query using WHERE clause by putting all filter criteria in it.    Like---

2012-01-11 Can't open Sql server 2005:

Are the SQL Services actually running?     Do I understand that SQL Server services and SSMS are both on the Windows XP computer in question?    I would try running the services as an actual account (yours

2012-01-10 Can't open Sql server 2005 - Remote connection error:

Hi Rakesh,    It seems that you SQL Server is not configured to allow remote connections.  You need to use SQL Server Surface Area Manager for that.    Please find some information on this link: http://msdn

2012-01-10 Can't open Sql server 2005:

I need more information. I am assuming that the SQL Server engine (service) is on the Windows XP computer. What account is the service set to use? (On the "Log On" tab, under "Log on as:")    Does the

More Answers in Category MS SQL Server