What do you...

If you just want to know if and how many page splits happen, there' s a performance counter SQL Server:Access Methods> Pagesplits per sec.

If you want more detailed information, like...

What exactly did you try doing when this error occured? What is the status of the database ?

My guess would be that your colleagues are member of a Windows group which has access rights to the user databases and you're not.

The reason why you can access...

Jack Corbett (9/2/2008)

---

In SQL Server 2005 SQL passwords are set by default to have to meet domain password requirements. The odds are your sa password does not meet this...

It's probably a longshot, but maybe you can find something in the default trace files.

Look under C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG for the *.trc files. Depending on the server activity...

You can catch Logon events real time by using DDL Triggers. Only catch is you need to install SP2 first.

Here you find a good article about this feature:

http://www.sqlservercentral.com/articles/SQLServerCentral.com/sqlserver2005logontriggers/2366/

Have a look at this article

http://weblogs.sqlteam.com/joew/archive/2008/08/20/60693.aspx

It shows one method of having more than two colours in a report.

Unfortunately there's no real fix for this issue when you use Standard Edition. Even though the KB article suggests a couple of workarounds, i my experience they don't really help.

What...

Spid's with an ID of -2 or orphaned sessions and you need to clean them up manually.

Unfortunately you can't kill them the easy way by running Kill -2 ,but you...

Yes, the installation process for 64bit is exactly the same as for 32-bit. Only thing you should do afterwards if you're using SQL 2005 Enterprise Edition is to set the...

madhu.arda (8/26/2008)

---

Hello,

We need to install second instance in the Active-Node3. Do we need to create a new disk group with new drive letters for the second instance? Is it...

Not exactly a reboot, but you need to restart the SQL Server Service.

Are all your instances Enterprise Edition ? Because for standard edition...

You can use this script as a starter. It doesn't sum up the database size, but you can add that without too much effort.

USE [master]

GO

SET NOCOUNT ON

CREATE TABLE #helpfile (

ObsvDate...