Disaster recovery...

You can also check the "processes" section of the activity monitor. Right click on the server in the object explorer and choose "activity monitor".

See if this helps:

http://www.sqlservercentral.com/Forums/Topic411310-338-1.aspx

For instance, using Grant's example:

WITH roles (PrincipalID, RoleName, UserName)

AS

(

SELECT p.Principal_id, p.NAME

,m.NAME

FROM sys.database_role_members rm

JOIN sys.database_principals p

ON rm.role_principal_id = p.principal_id

JOIN sys.database_principals m

ON rm.member_principal_id = m.principal_id

)

SELECT rl.PrincipalID, rl.RoleName,...

The standard reports are created using reporting services. You can create your own reports with SSRS and querying the appropriate DMOs.

If you want to capture some TSQl code used for...

As far as I can see, your query

select top 100 * from dbo.StockLocationLog where mode='Dispatch'

- it's a "select all" query

- if there is any ndex on the...

David, BOL says that...

BOL contains any details you need.

Right click on the server and see if the standard reports ---> server dashboard helps.

I think that this:

IACCEPTSQLSERVERLICENSETERMS: False

is the source of your trouble...

Can you send the output of this script:

SELECT

SERVERPROPERTY('ProductVersion') AS ProductVersion,

SERVERPROPERTY('ProductLevel') AS ProductLevel,

SERVERPROPERTY('Edition') AS Edition,

SERVERPROPERTY('EngineEdition') AS EngineEdition;

Do you take any log backups?

See http://www.sqlservercentral.com/articles/64582/

Jeff Williams is right, check the rights of the SQL Server service account on that location.

Actually both the "database owner" fixed database role and the "dbo" user can back up the database, see

http://msdn.microsoft.com/en-us/library/ms189612.aspx

http://msdn.microsoft.com/en-us/library/aa905208%28SQL.80%29.aspx

Am I missing something?w

See here

http://technet.microsoft.com/en-us/library/bb510680.aspx

the behaviours influenced by the compatibility level.

As far as I know the compatibility level has nothing to do with performance issues.

However you should review your code in...

BOL is your friend 🙂

You don't need to set the collation for the server.

You can set the collation at the database or column level.

http://msdn.microsoft.com/en-us/library/ms177439.aspx

http://msdn.microsoft.com/en-us/library/ms187582%28v=SQL.100%29.aspx