Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
timothymduncan
Starting Member
2 Posts |
 Posted - 2008-04-10 : 01:17:36
|
| Hello,Any help here much appreciated.I am using sql server 2000 to perform address cleansing. there is a point in my scripting when a table i pass values to becomes read/write. i suspect this is when i run a cursor through the table. Is anyone able to confirm for me whether running a cursor changes a table's properties?Many thanks.TimPs as the table seems to be read/write it is harder to tell if NULLs are in the table and this is messing with joins I have further down the track. |
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2008-04-10 : 01:29:37
|
what do you mean by "table becomes read/write".afaik you can set the readonly property at the database level only, not at the table level.
elsasoft.org |
 |
|
|
timothymduncan
Starting Member
2 Posts |
Posted - 2008-04-15 : 00:46:59
|
| i thought so re: setting read/write at database level.what i mean by read/write is that when i am in query analyzer, i right click on a table and select Open, when that table opens, i can edit data directly in the table. Ie no DML commands are necessary to edit table data.i would prefer that other users of my staging database not be able to do this. would be quite easy to edit the table by accident.tim |
|
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2008-04-15 : 02:33:19
|
you control that through permissions. if you deny them write permission, they won't be able to clobber your data.
elsasoft.org |
|
|
|
|
|
|
does cursor convert table to read/write?