Oh I understand that part. I liken a schema to a namespace or interface in OOP. My question is implementation-related

My question is actually more specific. I'm creating a topic in the 2008 security forum. Getting the details in right now.

Ah but the question "What landed me on this post in the 1st place?"

I'm a SQL DBA and I've never given a crap about schemas. I know what they are...

Sean Lange (3/27/2014)

---

robin.pryor (3/27/2014)

---

MarkusB (1/7/2009)

---

You call yourself SQL DBA and ask such a...

MarkusB (1/7/2009)

---

You call yourself SQL DBA and ask such a basic question ?...

Thanks for all the advice! I ended up deciding against restoring the system db's. There's too much complexity in the security and the jobs to chance bringing it down and...

liteswitch (1/23/2014)

---

Either there's a proxy account, or the Replication is being executed under his account, which is possible. Have a look a the publication and subscription properties, and check the...

Yes - permission issue. The dev boxes can't access hqdat directly. Only via a proxy that's set up with one of the sys admin's credentials.

For example, when the backup is...

I am the documentation nazi! It's a big reason I got the gig. They needed someone to not only figure it out and clean it up, but also to document...

I have a lot of confusion around the fact that I have to use DEVSQL03.CDB.ORG to connect to the server, but SELECT @@SERVERNAME returns DEVSQL03. That has to cause some...

That did it. I have no idea why I was unable to see the solution without asking. Brain fry. Everything starting to look the same!!! Thanks!

I'm not sure how, but this stopped being a problem. I do however have a new one, so I'll create a new thread.

Running successfully now. Thanks again! BIG TIME!

Thanks..

OnProgress,LMCVSQL1,LAMUCO\robin.pryor,Load U2 Data Contacts,{839F3385-A68F-49F6-B357-76A5A0FCE65C},{1D70D3CF-C85E-4619-93C0-EB38CD9F39EE},8/10/2010 12:09:51 PM,8/10/2010 12:09:51 PM,0,0x,Validating

Diagnostic,LMCVSQL1,LAMUCO\robin.pryor,From_U2,{C05CA7A6-1A6E-45FA-99FC-A8F16113FCDF},{1D70D3CF-C85E-4619-93C0-EB38CD9F39EE},8/10/2010 12:09:51 PM,8/10/2010 12:09:51 PM,0,0x,ExternalRequest_pre: The object is ready to make the following external request: 'IDbConnection.Open(ConnectionType: System.Data.Odbc.OdbcConnection, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089

ConnectionString: uid=sagitta;Dsn=Sagitta;)'.

Diagnostic,LMCVSQL1,LAMUCO\robin.pryor,From_U2,{C05CA7A6-1A6E-45FA-99FC-A8F16113FCDF},{1D70D3CF-C85E-4619-93C0-EB38CD9F39EE},8/10/2010 12:09:51...

I'm looking at BIDS right now and not seeing where to make this setting