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

you cannot refernece a column without saying what table it comes from...looks like you need "FROM dbo.payloads"

ie:

maybe like this:

SELECT (Select dbo.payloads.ContentReference as ImportFileName

FROM dbo.payloads

FOR

XML...

looks like it's a combination of Splitting and a pivot;

for specific values, this seems to get teh data back into "column" form; you'd need three split+ pivots in your example,...