I don't keep each patch downloaded, I usually do try to keep my environments the same version. I know it is difficult and outright impossible in some business cases.

But...

A bit different...

EXEC sp_detach_db 'DBName'

Thanks.

1) Databases cannot be located at UNC path when attaching SQL Server will not allow it.

2) After installing SQL Server Express on the computer you can just use following connection...

[font="Courier New"]

SELECT 'ALTER LOGIN [' + name + '] WITH PASSWORD=N''password'''

  FROM MASTER.sys.server_principals

WHERE TYPE = 'S' AND principal_id <> 1

[/font]

Pretty much what has been said just without help of excel...

Only other thing I can suggest is try removing him from group and re-adding it? My last job the ad guy knew how to check if security token were...

should be security.

Please check when he attempts a logon to SQL Server in Windows Security logs Login any kerberos issues recorded?

I don't think it can be this issue as no...

This is a very open ended question, trying to answer how to do performance tuning is not easy. But for starters I would recommend checking your database servers, check...

Hmm no SSPI errors, users defaults are correct, hmmm

If user is able to access it directly and not via AD group.. there is one other issue have found. If...

Sorry for late reply.

Well its not as scary as it looked, heh I didn't know you already multiplied by 1000, so I was worried a bit heh.

Drive D seems to...

I have weird errors like that too, are there any SSPI errors logged?

Answered in here.

Correct, because dynamic management views are not real objects. They are exposing the underline information with in SQL Server. In this particular DMV, the statements actually get pulled out...

saravanansoft (8/18/2010)

---

DECLARE @sql NVARCHAR(1000);

SET @sql = 'CREATE LOGIN ' + @UserName + ' WITH PASSWORD= ''TestUser123'',CHECK_POLICY = OFF'

EXECUTE(@SQL)

.....

CREATE LOGIN...

State 11 indicates she doesn't have access to her target database/default database. So when you add her manually is her default database different?

Notes on Disk subsystem troubleshooting, the spike in usage is not a concern.

You should look at the average over a fixed time, aka when your systems were the most...