O rly???

Learner44 (7/23/2013)

---

I tried this one..

deny VIEW DEFINITION ON SYMMETRIC KEY::SymmetricKey1 TO [sqlserver\ackj];

deny VIEW DEFINITION ON Certificate::Certificate1 TO [sqlserver\ackj];

GO

but it didn't help.

still [sqlserver\ackj] user can see the data with above...

Jack Corbett (7/23/2013)

---

Stefan Krzywicki (7/23/2013)

---

Jan Van der Eecken (7/23/2013)

---

Jack Corbett (7/23/2013)

---

Sean Lange (7/11/2013)

---

OK I will show my true American colors here. My wife's company just got...

Here is an odd...

Stefan Krzywicki (7/23/2013)

---

Sean Lange (7/23/2013)

---

Stefan Krzywicki (7/23/2013)

---

Here's a fun choice to have to make.

We have a fully functioning website that's on a Linux platform.

I want to add a new section...

Try this.

It actually...

Hi and welcome to the forums. In order to help we will need a few things:

1. Sample DDL in the form of CREATE TABLE statements

2. Sample data in the form...

Luis Cazares (7/23/2013)

---

If this...

Learner44 (7/23/2013)

---

You are 101% right..Sean

but, things here are ongoing..with millions of data across the 40+ tabels..

and account number is used as reference in almost 32+ tables.

Due to recent raise the...

gksharmaajmer (7/23/2013)

---

I am really thankful to SSCrazy Eights and You (Ten Centuries). Your query is giving me the correct and required output. Its true that output can be...

asita (7/23/2013)

---

is it something can be done in sql, or do we need to do step by step process for this

i am trying hard but no use, could somebody...

szonkie (7/23/2013)

---

Hi Im trying to return all rows based on the query below and have used the dateadd(datediff timestamps for first day of week and last day of week for...

Stefan Krzywicki (7/23/2013)

---

Here's a fun choice to have to make.

We have a fully functioning website that's on a Linux platform.

I want to add a new section that uses a database....

I didn't just provide a solution because this looks so much like homework and the OP did not answer that one way or the other.

Here is my solution using the...

Learner44 (7/23/2013)

---

Hi Sean..

I want to make it more complex and secure..

like reading each Accountnumber and convert each character into some special character..

is it worth to do it ..from your point...