>>A user can view any thing that they can access. Just give them CONNECT access to the database and they will be able to see it (though not necessarily much...

>>What's wrong with that standard approach?

Nothing is wrong (or "a lot is wrong" if you wish...). It's just irrelevant.

Pablo:

You are talking about access to a database - one of a...

Excellent code, ALZDBA, thanks.

Could you please help me with my problem:

Given:

Login: pacrat

User: pacrat with default schema: [pacrat]

view pacrat.tv (as select getDate())

BOL states that under these circumstances query 5 in...

BOL claims:

"In SQL Server 2005, each user has a default schema, which specifies the first schema that will be searched by the server when it resolves the names of objects....

The problem is that there is a ton of code that uses just simple object name without schema name. And I want on one hand somehow improve DB organization with...

select name, default_schema_name

from sys.database_principals u

where u.name='pacrat' and u.name='PacRaT' and u.name='PACRAT'

name default_schema_name

------ ----------------------

pacrat ...

... unless the user has "Default Schema" name defined that is different from "dbo". It is "pacrat" as you can see from the very last query results and from this...

I googled the question, and this time I succeeded:

http://books.google.com/books?id=6aMJH43GwpIC&pg=PA18&lpg=PA18&dq=join+sql+associativity&source=web&ots=MmZ-8z0kLe&sig=YCiWsv4TNPMA-CZCl1cM1ju_2m4&hl=en

I bought this book.

TicketID = CASE WHEN TicketID > 0 THEN @TicketID ELSE TicketID END

Thank you SQLBill for your answer, but it looks like there is kind of misundersanding.

1) From Query Analyzer I issue a statement.

2) This statement contains braces.

3) SQL Server successfully executes this statement.

My question...

My apologies to peterhe and to the forum.

Thanks, Enthusiast. Although I am not going to use it I am just curious:

Can these braces be used in any other context?

... set ' + @column + '='' +@value + '''

... set ' + @column + '='' +@value + '''

where ...

As I mentioned in my post of 7/29/2005 12:23:00 PM I am trying to avoid creating a new subject to maintenance like a set of text .sql files (let SQL backup...