The AD Credential thing is interesting. If there are matching AD credentials at the instance level, the authentication takes place there first, which makes sense. So if you move a...

richardd (4/12/2012)

---

Another point to consider - what if the company hosting your data goes bankrupt? The receivers will likely turn off the servers abruptly, without giving you any time to...

IceDread (4/12/2012)

---

Now your getting somewhere!

Earlier, I was under the distinct impression that you liked the cloud services. But because an idea might be good it does not mean the concept...

Comes and goes in waves.

Just remember that you can't usually win an argument with someone that isn't willing to try. A few times lately I've seen what I think are...

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...