More information needed.

Is the user specifying the correct password? Did you reset his password and tell him to use the new one?

EDIT: Nevermind, after re-reading I'm not sure what the problem is. Maybe someone else does or there could be a problem with your disk, or something?

Thanks,

I tested and you are correct!

Just letting you know I found the solution to this problem. You can create csv reports from each day's performance log. You open csv with excel, use avg(col range) to...

Well, I just realised I could view the counter values from several days in the system monitor, but it just takes the the logs and concatenates them together.

What I was...

Ok, sounds good. Thanks for your help.

EDIT: Nevermind.

Thanks for your response but I figured it out. I realized that I could set a break point on the replay trace, so I used that before it hit any...

Security permissions as in, not share permissions but permission on the folder itself?

I actually just tested it by giving everyone all permissions, tried it, it didn't work, then I removed...

You can retake as many times as you want, but you must wait 14 days between each take, it also costs $125 dollars each time.

Nevermind, I found out today... plus I passed! Yay!

UMS is a User Mode Scheduler which handles processor scheduling. Each processor that Sql Server uses gets a UMS. When connections are made to sql server the SPID is allocated...

I'm using the practice exam cd that comes with the Microsoft Sql Server Implementation and Maintenance book. I think this is the most common one people use to study with....

This is good, because it means you went the extra mile while most others didn't. If everyone had it, it would be less of a distinguishing factor.

Ok, I figured out what was wrong.

When I created the login in sql server for the snapshot agent to login with I didn't give that login any additional permission...

Alright, thanks, that seems to have fixed the problem. 🙂