In Oracle, Each Object can have double quotes. that means the table can have quotes, and it's column names can have quotes...but you can't wrap them all in-one..they each get...

You are looking for the BREAK keyword.

a simple example to break out of what would otherwise be an endless loop:

--RAISERROR immediate message

--print error immediately in batch

DECLARE

@i ...

you can join the table against itself, and use the modulus operator to limit it to the "odd" rows for the first value, leaving the second value as the date-ish...

excellent! glad we could guide you in the right direction; I for one am very glad you were able to solve this with just a gentle nudge!

ouch; remote-second hand assistance is tough,

I feel for you and what headaches are involved in getting your information once-removed from the client.

creating a view that auto-decrypts the data makes the data no longer HIPAA compliant, doesn't it?

I'd say that is no different from storing the data unencrypted in the first...

hmmm; i'd say there is always files that can be moved or deleted.

files in temp folders on the operating system, log files, , the already suggested moving of backup files,...

This looks an awful lot like homework, so I'll frame my answer with that in mind.

It looks like the purpose of this exercise is to learn how to use the...

do a find and replace to add QUOTENAME, so you can accommodate weird database names with dashes/spaces

FROM '+@pDatabase+'

--should be

FROM '+ QUOTENAME(@pDatabase) +'

i think you want DataGridView.Visible = false; enabled would be more like displaying, but removing editablity due to permissions or something.

visible is what you need to hide/show

aaron i'm sure you know that SQL doesn't order data in any specific order without an explicit ORDER BY clause.

in your case, i'm thinking you might do what you...

Blair Dee-474691 (4/29/2013)

---

hey thanks for the tip. I did download and install that and it looks like it will generate the script to copy the data over but it...

since the accessing of data is done after the login, the log isn't going to help you.

you would need to add a new level of auditing to capture those...

ok here's my version, which i adapted from a DDL trigger i made for another post.(add new objects to this role)

this will generate three roles, one for each requirement, then...

actually, both powershell and ssms are using smo under the covers.

the batch separator is an option you can select, i believe.

see this thread for an example on teh same question:

http://www.sqlservercentral.com/Forums/Topic996028-1351-1.aspx#bm996236