mw112009 (10/1/2015)

---

Ok thx

Can you help me with this then ?

I like to write a query where I pass a name of a table and column and then it will simply...

where

(@VendorNumber is null or (hh.vndno = @VendorNumber))

and hh.chkdts = @CheckRunDate

and dd.DPSTF = 'N'

and hd.FILET = 'H'

and cd.EDI835Exclude = 0

and (@CompanyCode IS NULL OR ( cd.CMPCD = @CompanyCode))...

as i remember it, oracle doesn't auto cast strings to date nicely the way SQL Server does. you have to use the TO_DATE(' '2015-09-30 13:13:09.73688','YYYY-MM-DD HH:MI:SS') i think would work.

http://www.techonthenet.com/oracle/functions/to_date.php

jxj363 (9/29/2015)

---

I thought that each server had to have its own key that is unique to the machine. We have a dev server with reports, and now want to...

DECLARE @ObjectName sysname = 'UsedInView'

SELECT

SCHEMA_NAME(so.SCHEMA_ID) AS SchemaName,

so.name AS ObjectName,

so.type_desc,

sed.referenced_server_name,

...

basically, yes. you might be able to create a procedure featuring execute as owner,a nd grant an end user permissions to that, but thye cannot run dbcc themselves.

here's an older...

actually, the dll is uploaded into the database, and can be extracted to disk,...

my quick proof of concept looks like it would work:

i just grabbed an Ms template, saved it, and started combing through the raw text.

not sure if this would work in your situation, but what about putting placeholders in an existing doc as a template, then saving it as rtf?

store it as a varchar(max),...

"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...