can we telecommute from the US?

hehe just kidding, since the location is India; i thought a little role reversal would be funny.

I know there is usually a reason behind everything in your posts , Jeff...I love reading your posts specifically because I learn something (and I'm...

i love logon traces, but for tracking/ accessing specific databases, i don't think it would work;, a logon trigger occurs before a user connects to a database...so in the trigger...

the parameter @recipients for msdb.dbo.sp_send_dbmail expects a semicolon delimited list of recipients; there's no limit to the # of recipients, since it is a varchar(max) definition;

so if you are...

As a solution to my own question, one of the real problems is that a CREDENTIAL is created to hold the password for the SMTP user; i do not know...

yeah, digging for stuff is turning into a pain...

just going for the account info, for example, the password associated to the username used for SMTP AUTH command appears to use...

it's easy!

there is a link named "Control Panel" just left of the oh so familiar "Recent Posts"

click that, and down on the left is a link to "Edit Avatar"

click that...

the example i gave you will work with absolutely any SQL command; try it before you dismiss it.

Declare @cmds Nvarchar(MAX)

Declare @obfoo varbinary(MAX)

Set @cmds = '

ALTER procedure [dbo].[sp_find]

@findcolumn varchar(50)

AS

BEGIN

...

are you sending the actual scripts fo rhte client to run, or an executable which will then execute the script after the client provides connection information to the server?

you could...

yep, so your WHERE statement would reference the THREE columns that make up your primary key:

...WHERE TableName.IdContrato = INSERTED.IdContrato

AND TableName.EiCanalId = INSERTED.EiCanalId

...

i had to infer a lot of...

if the query has a WHERE statement, you could make the arguments non-SARG-able, and force it to use a table scan, but it would still use an index(probably the clustered...

I always felt those two functions should be renamed, as they are really misleading; something like ISREFERENCED would be a much better name

I always felt those two functions should be renamed, as they are really misleading; something like ISREFERENCED would be a much better name .

i think that's the only way to do...