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

ok, it's time to play...

NAME...THAT...VENDOR!

this is really misleading, because when you click SSMS(NOT logging in to object explorer or a query window), you launch it as yourself...probably someone who certainly can stop and start...

perfect Gail, that was exactly the push i needed.

Thank you so much!

your are confusing the two possible presentation styles of SSMS with how the actual results end up in your other .NET application...they are not the same.

you get a record...

run sp_who2 again...based on the hostname column, is it all from a single machine, maybe even your own machine, since that's the only one you KNOW is running SSMS?

wierd, on my 2008 server all my connections from SSMS say "Microsoft SQL Server Management Studio - Query" or

"Microsoft SQL Server Management Studio" ...none reference intellisense.

do you have a...

try explicitly identifying a collation for the join criteria, like this:

SELECT Customers.dbo.Lead.Last_Evaluation_Product__c

FROM Customers.dbo.Product

INNER JOIN

Customers.dbo.Lead

ON Customers.dbo.Lead.Last_Evaluation_Product__c COLLATE SQL_Latin1_General_CP1_CI_AS

= Customers.dbo.Product.Name COLLATE SQL_Latin1_General_CP1_CI_AS

WHERE (Customers.dbo.Lead.IsConverted = 0)

AND...