ok, now i am confused; i thought the insert was SELECT 0, 'test'

from Customer....but it's just SELECT 0, 'test'

for that, i'd expect an estimate of one row....

well, first the two queries are not the same; one is a straight insert of static values for every row in the table , or 500K.

the other is a...

you have this line

that is missing the join criteria..

ON sometable.column = DimIteration.column

shouldn't it look something like this?

CREATE FUNCTION udf_ConvertDB2toSQL(@CSC_DATE varchar(7))

RETURNS DateTime

AS

BEGIN

DECLARE @SQLDate Datetime

...

i should add that if the procedure uses dynamic SQL instead of direct DDL commands, then the ownership chaining is not used, and the specific permissions, like SELECT or DELETE...

there is an ownership chaining assumption in SQL Server:

if you create a procedure ie dbo.myProc, and you grant a user EXECUTE rights to that proc, no matter what that...

hmbtx (12/27/2011)

---

Lowell:

Thank you for the detailed instructions. I have three questions if you have the time to answer them but if your time is limited an answer to question #1...

the solutions is fairly simple, but it varies a bit based on your specific setup. it all boils down to the group or login needs to be part of the...

wait...everyone knows there's ten reindeer;

the original 8,

plus Rudolph,

plus Olive, the other reindeer!

try this example, one line at a time; it should help you see how no permissions, all permissions, and then deny for a specific user will work.

USE [SandBox]

GO

--I'm currently logged...

I end up going to as many e programming or SQL Server related events as I can, like the SQL Rally not long ago, or some of the one day...

offhand, i can think of three different ways so far.

ideally, you do it via permissions...if the only permissions you grant is SELECT, they cannot do anything else.

since DENY trumps other...

i didn't se the specific error , just the "it fails" part even though it's set up right elsewhere;

typically that's due to permissions.

whever calls the sp_send_dbmail needs to be a...

bitbucket-25253 (12/24/2011)

---

Lowell your posting of this link to assist an OP

TallyCalendar_Complete_With_DST.txt

Lowell -Fantastic amount of work - from a IT standpoint thanks for sharing - Glad you were willing to...

see if either of these extended stored procedure examples help:

EXEC master..xp_logininfo

@acctname = 'mydomain\lowell',

@option = 'all' -- Show all paths a user gets his auth from

go

EXEC master..xp_logininfo

@acctname = 'mydomain\authenticatedusers',

@option...