anyone know how to rotate a textbox

I need to rotate a textbox on a report...i know there is theWritingMode property (sometimes just labeled Mode) of a textbox todetermine whether it is written vertically (tb-rl) or horizontally(lr-tb)...but i need it to betb-lr

any ideas?

HI,bopritchard :

To get text rotated in reporting services all you have to do is set the WritingMode to "tb-rl". You may also want to set the TextAlign and VerticalAlign to position the text correctly. Remember though the text is rotated so to get the text appearing on the left you have to set the VerticalAlign to Bottom. To get the text to align with the bottom of the text box you have to set the TextAlign to Right

|||

i need it to betb-lrnot tb-rl

Any way to keep a table in read only mode ?

I would like to keep a table in readonly mode vs having the entire database
in read only ? I also do not wish to change any login settings,etc..
DENY INSERT, UPDATE, DELETE ON table_name
TO user_name_1, user_name_2, user_name_3
David Portas
SQL Server MVP
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:%239J8hAnkFHA.3568@.TK2MSFTNGP10.phx.gbl...
>I would like to keep a table in readonly mode vs having the entire database
> in read only ? I also do not wish to change any login settings,etc..
>
>
|||search for these titles in BOL:
Understanding Locking in SQL Server
Locking Hints
Hope this will help.
Regards,
Mansih
|||Do you know the query i could use ?
select * from table (tablockx) .. Will this do and prevent others from
modifying the data ?
I would like to read and not update
<manish19@.gmail.com> wrote in message
news:1122447284.950431.215450@.g49g2000cwa.googlegr oups.com...
> search for these titles in BOL:
> Understanding Locking in SQL Server
> Locking Hints
> Hope this will help.
> Regards,
> Mansih
>
|||Hassan
by using SELECT statement you cannot UPDATE the data. As David pointed out
use DENY permission on objects
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:e1SiiDokFHA.1044@.tk2msftngp13.phx.gbl...
> Do you know the query i could use ?
> select * from table (tablockx) .. Will this do and prevent others from
> modifying the data ?
> I would like to read and not update
>
> <manish19@.gmail.com> wrote in message
> news:1122447284.950431.215450@.g49g2000cwa.googlegr oups.com...
>

Any way to keep a table in read only mode ?

I would like to keep a table in readonly mode vs having the entire database
in read only ? I also do not wish to change any login settings,etc..DENY INSERT, UPDATE, DELETE ON table_name
TO user_name_1, user_name_2, user_name_3
--
David Portas
SQL Server MVP
--
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:%239J8hAnkFHA.3568@.TK2MSFTNGP10.phx.gbl...
>I would like to keep a table in readonly mode vs having the entire database
> in read only ? I also do not wish to change any login settings,etc..
>
>|||search for these titles in BOL:
Understanding Locking in SQL Server
Locking Hints
Hope this will help.
Regards,
Mansih|||Do you know the query i could use ?
select * from table (tablockx) .. Will this do and prevent others from
modifying the data ?
I would like to read and not update
<manish19@.gmail.com> wrote in message
news:1122447284.950431.215450@.g49g2000cwa.googlegroups.com...
> search for these titles in BOL:
> Understanding Locking in SQL Server
> Locking Hints
> Hope this will help.
> Regards,
> Mansih
>|||Hassan
by using SELECT statement you cannot UPDATE the data. As David pointed out
use DENY permission on objects
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:e1SiiDokFHA.1044@.tk2msftngp13.phx.gbl...
> Do you know the query i could use ?
> select * from table (tablockx) .. Will this do and prevent others from
> modifying the data ?
> I would like to read and not update
>
> <manish19@.gmail.com> wrote in message
> news:1122447284.950431.215450@.g49g2000cwa.googlegroups.com...
>> search for these titles in BOL:
>> Understanding Locking in SQL Server
>> Locking Hints
>> Hope this will help.
>> Regards,
>> Mansih
>

Any way to keep a table in read only mode ?

I would like to keep a table in readonly mode vs having the entire database
in read only ? I also do not wish to change any login settings,etc..DENY INSERT, UPDATE, DELETE ON table_name
TO user_name_1, user_name_2, user_name_3
David Portas
SQL Server MVP
--
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:%239J8hAnkFHA.3568@.TK2MSFTNGP10.phx.gbl...
>I would like to keep a table in readonly mode vs having the entire database
> in read only ? I also do not wish to change any login settings,etc..
>
>|||search for these titles in BOL:
Understanding Locking in SQL Server
Locking Hints
Hope this will help.
Regards,
Mansih|||Do you know the query i could use ?
select * from table (tablockx) .. Will this do and prevent others from
modifying the data ?
I would like to read and not update
<manish19@.gmail.com> wrote in message
news:1122447284.950431.215450@.g49g2000cwa.googlegroups.com...
> search for these titles in BOL:
> Understanding Locking in SQL Server
> Locking Hints
> Hope this will help.
> Regards,
> Mansih
>|||Hassan
by using SELECT statement you cannot UPDATE the data. As David pointed out
use DENY permission on objects
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:e1SiiDokFHA.1044@.tk2msftngp13.phx.gbl...
> Do you know the query i could use ?
> select * from table (tablockx) .. Will this do and prevent others from
> modifying the data ?
> I would like to read and not update
>
> <manish19@.gmail.com> wrote in message
> news:1122447284.950431.215450@.g49g2000cwa.googlegroups.com...
>

Answer: Access creates DB in MSDE in SQL Server Authentication mod

I've confirmed that MS Access will create an ADP project in MSDE only if the server is set to Mixed (SQL Server and Windows) authentication mode. Trials in Windows Authentication mode failed. This is still hard to believe, I know, but its a reality.
To all those who tried to help, my sincere thanks.
Lou Arnold
Ottawa, Canada
Lou,
Did you have to create users in the SQL database itself so that Domain
Users could access the MSDE, and if so, with what tool did you use?
"Lou Arnold" <Lou_Arnold@.nospam.com> wrote in message
news:EB2211E6-F5BD-4DD8-AC32-65B7B0DC0ECA@.microsoft.com...
> I've confirmed that MS Access will create an ADP project in MSDE only if
> the server is set to Mixed (SQL Server and Windows) authentication mode.
> Trials in Windows Authentication mode failed. This is still hard to
> believe, I know, but its a reality.
> To all those who tried to help, my sincere thanks.
> --
> Lou Arnold
> Ottawa, Canada