"did not work" doesn't provide enough info.

it depends on what your trigger is doing. if it is doing...

i believe the function ORIGINAL_LOGIN() will return the caller, regardless of execute as.

if your DDL trigger is writing to a table, you want to either have the trigger EXECUTE AS OWNER, or maybe GRANT INSERT ON MyAuditTable TO PUBLIC, so that no...

Solomon what about the other direction for a CLR?

if i pulled data into a Datatable and want to send them to disk, how would you do it?

I've done...

when you go outside of a SQL database, SQL uses an account that you would not intuitively expect it to use . even if you are sysadmin +domain admin for...

smitty-1088185 (9/25/2015)

---

How can I allow a user to run a stored procedure but deny them the ability to see it in SSMS?

I don't mean 'view def' permissions, I mean the...

there was a recent article that demonstrated how to run all *.sql files in a given folder.

that means the scripts contain commands that already have to have the parameters to...

maybe join only on names,and filter for where the ENum <> Anum?

SELECT distinct T1.[last name],t1.[first name],ENum,t2.Anum,T2.lname ,t2.Fname,

FROM ECLINICIAN_Info T1

LEFT JOIN ACLINICIAN_Info T2

ON t1.[last name] = t2.lname

and t1.[first name]...

well if it doesn't exist, then you'd be adding a column of all null values right?

you can join the two tables together instead of an exists, but that finds things...

and here's a basic example for the command line:

sqlcmd -S . -d master -E -Q "exec sp_who"

sqlcmd or bcp are the two command line options.

bcp is designed for importing or exporting data, whereas sqlcmd can do both, but also execute commands;

i've used use sqlcmd to...

I've got a script i call missing and implied foreign keys that i built over the years.

it's basically a peel the onion kind of attack, which kind of assumes some...

because you said intellectual property, i'm thinking that your database is given to your clients, and a different DBA than yourself administers that database. if you control the db, you'd...

--whopps removing and moving to other post.

Laptop...Thumbdrive...Golf Cart...32bit...workaround...Free..."connections are only open for a second or two to retrieve a row or write a row"

a few of the keywords i'm picking up here directly telling towards the...