Steve Jones - Editor (5/23/2009)

---

You have not really explained what is wrong.

SQL Server does not return ambiguous results unless you mean that

SELECT * from MyTable

doesn't return the same results in...

Steve Jones - Editor (5/23/2009)

---

You have not really explained what is wrong.

SQL Server does not return ambiguous results unless you mean that

SELECT * from MyTable

doesn't return the same results in...

Please look at my last 2 posted topics.. url has been given on first post of this topic

On home page of my website there is very simple query i.e. select * from some table" which shows a list of data... and it was working for last 2-3...

guys it looks no one is changing the password as the log says "

2009-05-20 01:22:20.300,Logon,Login failed for user 'sa' because the account is currently locked out. The system administrator can...

these are some web applications, which r connecting through ADO.Net

We usually use a different user sql server user to connect for different user so it might not be good...

One interesting thing we can see from this following log text is that each time before cachestore flush 'aspnetdb' got restarted.. what can we do here now?

2009-03-23 08:20:18.190spid89Starting up...

A lot of things could be the cause like memory pressure, poor plan reuse, auto update stats, reindexing, ddl etc. Unless you are having performance problems, they can be disregarded.

...

no but this happened suddenly while sql is fully working , it looks bcas of overload of memory ...

output of following command is below..

SELECT * FROM SYS.DM_OS_SYS_INFO

Result...

second option see some logs.. since whn problem got started ....

03:39.8Server -l c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mastlog.ldf

03:40.0ServerSQL Server is starting at normal priority base (=7). This is an informational message...