I'm not familiar with the inner workings of the extended proc xp_logininfo, but it does query the domain controller for the groups a user belongs to, or the users that...

another possibility, but where you would have to grant execute permissions to Everyone ON xp_logininfo (or the trigger has to Execute AS a power user's context) so they can...

when i googled the same error, the first few i looked at all implied that a service pack was applied, but somehow some of the post-install scripts failed to execute;...

the first link i got whens earching for the error took me here:

http://social.msdn.microsoft.com/Forums/eu/sqldatabaseengine/thread/214b0b8f-ab78-4ab1-bd73-3eeee0c8999a

it seems to imply there is something wrong with "corruption of Server Principal Name(SPN)."

can you look at...

yeah i had added a seperate line "GRANT EXECUTE TO [ClassicReadWriteExecute]"

to cover the execute permissions as well.

i would create a role like this example, and then add your user dtAdmin to that role:

Create LOGIN [dtAdmin] WITH PASSWORD='NotTheRealPassword'

USE [WHATEVER]

Create USER [dtAdmin] FOR LOGIN [dtAdmin]

CREATE ROLE [ClassicReadWriteExecute]...

maybe you are scripting the table in SSMS, and it doesn't show the foreign keys because the scripting option for that is False instead of True?

you just need a basic example? here' s one writing two properties about a procedure, and reading them back;

to do it for all of them, you build a select statment...

i've only done it the wat SQLKnowitAll describes it:

1. run the query in SSMS, with Show Actual. Execution plan enabled.

2.review the execution plan.

3. change the indexes.

4. run the query again...

sample, consumable data is the key to getting answers here.

if you put your data in a format a volunteer can copy/paste /adapt, you can get instant, tested answers.

i couldn't tell...

not necessarily;it depends on the user context the preocdure is running under, i think.

if...

to develop reports, the user generally needs to be able to see the metatadata/structure of the tables as well, which db_datareader will not give them.

you'll probably want to grant VIEW...

Jason did you happen to install any SSMS add ons that might not be letting go?

What add-ons for SSMS do you have installed so far?

I have three or...

could the table exist under a different user/schema? so instead of dbo.FRAGResultTable it's Bob.FRAGResultTable?

sample data extracted for useability:

With tenant_history(hmy, dtdate, htent, sevent, dtoccurred, dtmovein, dtmoveout )

AS

(

SELECT '176340','2011-08-26 00:00:00.000','55496','Notice Given ','2011-08-26 14:32:53.000','2006-03-01 00:00:00.000','2011-09-26 00:00:00.000' UNION ALL

SELECT '176375','2011-08-29...