set DATEFIRST 1

declare @dt datetime

select @dt = '12/09/2012'

select previousMonday = dateadd(dd,(-1)*(datepart(dw,@dt)-1),@dt)

set DATEFIRST 7

Think of a database as a unit of recoverability within an instance.

Think of a schema as a security container within a database.

Often you want to have multiple databases for a...

If the web front end/services have specific logins (as they should), then your best bet is to disable the logins

during maintenance. Or if you are using roles, you could...

Not my intention. Just trying to point the conversation in the right direction.

Will be more careful re tone...

The answer to why we should cluster is all about internals (storage...

While the accounts you supply in the GUI will be used for the actual mirroring transport, the 'owner' of endpoint(s) usually becomes the user that set up the mirror.

It is...

It looks like the cluster service service account may have lost permissions on some part of the share.

Remember share permissions are both at the NFS level and the share level.

By default public has exec on xp_instance_regread.

Have you revoked exec?

If it is a new PC, is the version of the client the same?

Are we sure the user is connecting to...

If you want a negative value, then just multiply the output column by -1

e.g. select col_name * (-1)

You should always add a clustered index on a table, unless you can show a REALLY good reason not to.

If you believe otherwise, it simply exposes your lack of understanding...

As Anthony pointed out, this is a connectivity issues, not a SQL server security/login issue.

1. ping the name

2. ping the IP

3. Find out FOR SURE what port SQL server is...

Since you are going to 2008, you should be using backup compression by default.

Since backups are more likely to be IO bound than CPU bound, you backups will be...

Have you checked for runaway queries with massive paralellism?

Just run:

[font="Courier New"]select * from sysprocesses where dbid = db_id('<database_name>')[/font]

Then kill the spid.

Sorry, that was my old role.

In my new role we use PRTG.

Nagios - SCOM as secondary. We had issues with SCOM, e.g. slowness, missing things and downtime.