bob.willsie (4/14/2009)

---

Ok, I'm lost. I can understand an end user not really caring where the connection physically ends up at, but I would think a DBA would have to...

blandry (4/14/2009)

---

...Because it suggests giving up control of vital, private and often sensitive data.

...

Right now this is a "we can do this" idea. But there is very little out...

Surprisingly, most of your concerns were what I heard in 95-99 about web apps. I think this will follow a similar path. There are plenty of people that host their...

I went back and looked and the question really needs to have someone about the update load. An indexed view adds overhead for inserts/updates, and space (less significant). Is it...

Part of wording the questions is that I have to limit the scope. One way to do that is exaggerate a bit to get you to focus on that one...

Thanks, Johan. I also pulled it down over the weekend and installed it. No issues on my SS2K8 VM

Sounds backwards, symmetric key should encrypt data for specific column.

Asymmetric key should encrypt symmetric key.

What I've seen is that reencryption can be change the asym key, reencrypt the sym key...

First, please format your post into paragraphs so it's a bit more readable.

If it's a large transaction, it's possible that there are memory issues with that transaction. Adding more memory...

Very strange, Wayne.

Are you sure the ODBC connections haven't changed? I'm guessing they're NT auth, perhaps some strange connection item?

How are the admin reports run?

I would add another statement to reset the errorlevel. a

select 1

ought to do it.

Strange. I might recommend that you grab the file and process tools from sysinternals and use them to watch what happens when you execute xp_deletefile. I wonder if there are...

First, please separate the clauses so it's easier to read. It helps us, and I bet it will help you with coding.

Second, I'd suggest that you use ANSI joins, which...

You should have experience on the platform. Which one have you worked with? If it's 2005, get that cert. If it's 2008, get that.

Achieving the certification without using the...

If you are trying to do this from some application, you could just run a .sql script with the proc code.

If you are building the proc dynamically, why?

Salesforce.com (and similar entities)

Lots of online payroll companies.

It can, and is working. For every system no, but it does make sense in places.