If ALLOW_PAGE_LOCKS is off, then SQL will not take page locks on that index. It will only take locks at the row or table level.

IF ALLOW_ROW_LOCKS is off, then SQL...

When you set up the counters you can specify which DB it's for, or specify counters for all databases overall.

Developer (as it's name implies) is licenced for development usage only. I would suggest you replace the version on the test server with dev edition and put standard edition...

jcrawf02 (9/19/2008)

---

With the knowledge I've gained here at SQLServerCentral, I've gone from (December 2007) a guy who didn't know how to join tables at all and wouldn't have been...

In 2005 and higher the system tables are no longer visible and cannot be queried.

Objects like sysobjects, sysdepends, etc are known as compatibility views and are only included for...

It's not possible. All data modifications are logged and the log entries cannot be discarded from the log until the transaction has committed and the data pages changed by that...

Yup. sysdepends is as inaccurate as ever in 2008, and deprecated to boot. It hasn't been fixed, it's been replaced

Can you open the services manager and try to start the SQL Service. If it gives an error, please note exactly what error it gave. Also check the SQL error...

Ok, the deadlock is occurring in the procedure "dbTest.tsuser.jxc_158". It looks like both processes are running the same proc.

It looks like there's an update (line 10) (UPDATE "timesheet_cache" SET...

harsha.bhagat1 (9/19/2008)

---

Hi,

I anybody have any dml statments that while deleting the records it does not goes into the log or the moment 1 delete is complete it should truncate the...

Ok, so if Node 1 is active you can see S drive and it has a whole directory structure, if node 2 is active you can see S drive but...

Hang on, you can see S drive from both nodes?

If so, that means that different 'drives' are getting mapped as S on the two nodes. You should be able to...

Then set the DB into simple recovery mode so that the...

I did. It depends on the number of rows affected by the query and the amount of lock memory...

If you log onto node 2 (remote desktop), can you see drive S in windows explorer?

If you open cluster administrator, is drive S a dependency of the SQL group (it...