You could query INFORMATION_SCHEMA.COLUMNS for the column level collation info.

However, I don't think that the collation thing is the cause of your security issue.

Have you tried deleting the database...

You're...

I don't know about a Windows Jobs tracking software.

For SQL Server there's SQLJobVis that seems to be what you're looking for.

Hope this helps

Gianluca

I don't think that the user access issue is related to the collation conflict.

The collation conflict error you get in SSMS is due to the queries issued by SSMS...

I don't understand your question, sorry.

What do you mean with "grid"?

Can you please clarify, possibly with an example?

Thank you

Gianluca

You mean that if you add data it fails because of "Could not allocate a new page for database" error?

I hope this is not your real SA password...

It would not be a wise move posting it on a public forum.

Some advice:

1) Don't use sa.

2) Use Windows Authentication (should be...

Could also be a different schema. Try qualifying the object with the schema name.

You have the same column name multiple times:

<snip>

null as perc_cs_privado, null as perc_cs_privado,

<snip>

Change one of the column aliases to a different name.

That should not be hard to do.

Can you post:

1) Table scripts

2) Sample data

3) Expected results based on the sample data?

If in doubt, see the first article linked in my signature...

Can you attach the actual execution plans for both statements?

What do you mean with "alias"?

The DNS network name?

With RESTORE DATABASE. 🙂

You can fire that from the GUI in SSMS if you're not familiar with the T-SQL syntax.

On the object explorer right click the "Databases" node and select...

It highly depends on the view definition vs T-SQL code you're running.

Can you post the actual code and actual execution plans?

However, a couple of pointers should apply anyway:

* Are you...

Nice method. Thanks for the good article.

And thanks to Paul Randal for the sage advice.