Closing this thread.

Please post an answer, or one response, and then do not belabor the point.

Right click Logins, under security in SSMS for the instance, then "New Login".

Enter the credentials (SQL or Windows type login), then on the mapping tab, select the databases they need...

Thanks. Haven't done much special prep, so we'll see. I do think it's a good experience for me, and I've made a few notes after every exam of things to...

perhaps, this help?

http://social.msdn.microsoft.com/forums/en-US/sqldatabaseengine/thread/7e36aa04-00ce-46a8-9a29-f63f4ac3b6b5/

when I've taken these in the past, that's what happens. As Gail mentioned, these are used to try and evaluate the questions. They'll somehow come up with a score and...

DDL trigger?

or spatial data?

Quick overview: http://www.sqlservercentral.com/articles/SQL+Server+2008+R2/87858/

Are you running a push or pull subscription? If it's pull, you should be able to query the jobs to see if they are in running status.

Thanks, we'll take a look in a week or so. No one's submitted one yet.

Does this help? http://support.microsoft.com/kb/248391/en-us

The service account needs to have these permissions to create the user that is the proxy.

It could be policy of some sort. I'd think PBM would throw...

Rename the windows host

Rename the SQL instance.

Did you follow a similar procedure as what was outlined in Seth's link?

Just trying to figure out where things might have gone wrong. You should use a proxy, but it...

How did you set up the proxy?

CDC/CT will do this, but it has cleanup jobs that remove data over time. Auditing has not been a great strength in SQL Server over time, and I don't know...