Lowell,

I can't grant dbowner role to these users or else then they'd be able to write to the db or make other changes. I've got these users tied down to...

Jo,

That's a good suggestion, and I have done that, but in this scenario, each customer will have multiple databases.

From the research I've done, this looks to be a limitation on...

Lowell (9/23/2011)

---

the command you are looking for is this snippet to hide databases the end user doesn't have access to:

DENY VIEW ANY DATABASE TO [SomeUserOrRole]

[/QUOTE]

Thank you very much for...

These customers need read access to the production database and we don't have the hardware or software licenses available to create a replication environment.

The default behavior for a login created...

Wow. These are great suggestions. Some definite edges for me to pry at this problem. I'll get back to this thread tomorrow with my relevant findings.

Appreciatively,

mtf

I have continued to troubleshoot this issue. I noticed that the join is matching an int column in one table against a varchar(50) column in a larger (900,000+ rows) table....

Eric M Russell (6/23/2011)

---

Processing row by row with an insert in between is the text book definition of a poorly optimized database process. The most optimal solution for selecting 10,000...

opc.three (6/22/2011)

---

.NET class System.Data.SqlClient.SqlBulkCopy

It allows one to load data directly from an ADO.NET data structure into a SQL Server database via the bulk copy API (same one used by bcp...

opc.three (6/21/2011)

---

Heh, yeah, tell 'em I sent ya 😉

Out of curiosity brought about by something you said about "bulk", what's the client language? There may be a better way than...

Thank you for your corroboration of what I suspected. I'm going to print out your response and slam it on my boss's desk and shout, "SEE! OPC.THREE says it will...

Har-Har! I wish this were a homework assignment... This is me at my job trying...