Query Analyzer : Open Window

[tleish]

How do I set up a DB in SQL Server to allow an individual to open up a table window in SQL Query Analyzer that is not "Read-Only" ...so as to allow them to edit the date in the table like an excel sheet? - tleish

 

[aalmeida]

ON QA you have to run UPDATE Queries to achive that as:

UPDATE Table_A set Date_Column = getdate() AL Almeida
NT/DB Admin
"May all those that come behind us, find us faithfull"

 

[tlbroadbent]

QA doesn't allow updating of query result sets. Enterprise Manager (EM) allows opening a table and some views in Edit mode. I don't recommend EM as a good client tool for most users. You should provide the user with a client program built in VB, ASP, Delphi, C++, Access, ... Use a development tool you are familiar with. Terry L. Broadbent
Programming and Computing Resources

http://tlbroadbent.home.attbi.com/prog.htm

 

[fluteplr]

One other possibility if the users have MS Office installed they can use Microsoft Query to do what you want there is a menu option that allows the data to be editable.

That being said I have to agree with Terry, giving the users the ability to edit data in that fashion is a disaster waiting to happen.

If this is the course you follow I suggest backing up very often, and making sure you spend a lot of time on security so the users can only change fields/tables they have the right to change.