SQL Server Query Editors - any that warn of number of rows to be changed?

Posted by ciaranarcher on Stack Overflow See other posts from Stack Overflow or by ciaranarcher
Published on 2010-03-31T08:45:25Z Indexed on 2010/03/31 12:03 UTC
Read the original article Hit count: 280

Filed under:

sql-server

|

editor

|

DBA

|

recovery

We're using SQL Server 2000 Query Analyser, and one issue we have is that very occasionally, when a user is updating our live database, they insert the incorrect/no(!) where clause. I know, not good, but it happens.

Are there any editors that will warn of the number of rows that might be changed (if that is even possible) or even a way to configure an editor, if it is connected to a certain database, to prompt for confirmation before the query is run?

We have a way to recover our data in the cases where we run an incorrect query, but it takes time, and I'm just seeing if there are any ways to catch the error, or at least give the user a second chance.

Thanks in advance.

© Stack Overflow or respective owner

Related posts about sql-server

SQL SERVER – Beginning SQL Server: One Step at a Time – SQL Server Magazine

as seen on SQL Authority - Search for 'SQL Authority'
I am glad to announce that along with SQLAuthority.com, I will be blogging on the prominent site of SQL Server Magazine. My very first blog post there is already live; read here: Beginning SQL Server: One Step at a Time. My association with SQL Server Magazine has been quite long, I have written nearly… >>> More
How to install SQL Server 2005 Configuration Manager without installing SQL Server Management Studio

as seen on Server Fault - Search for 'Server Fault'
Hi, I need to configure SQL Server aliases on a public-facing production server. To do that, I need to install SQL Server Configuration Manager. I was not able to find a standalone installer for that, so I am having to install SQL Server 2005 Client Components. This approach is not ideal as we don't… >>> More
[MAJ] SQL Server 2005 Express Edition - La version gratuite de SQL Server 2005

as seen on ASP-PHP.net - Search for 'ASP-PHP.net'
Modification technique pour le site de l'article. >>> More
How to create SQL Server Express DB from SQL Server DB

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a SQL Server 2008 DB. I want to extract SOME tables (and associated schema, constraints, indexes, etc) and create a SQL Server Express DB. It isn't a sync of the target, we stomp on it. We ONLY need to do this in the file system (not across the wire). We are not fond of the synchronization… >>> More
sql server 2000 error, error trying to connect to sql server 2005

as seen on Stack Overflow - Search for 'Stack Overflow'
i am connecting to sql server 2000 on a remote computer with a dotnet application, but when i try to open the connection it gives the following error: When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections What… >>> More

Related posts about editor

Netbeans 7.2 Missing Modules Warning

as seen on Ask Ubuntu - Search for 'Ask Ubuntu'
Everytime I start Netbeans and the splash screen shows up when it gets to the part to load the modules I receive the following error message : Warning - could not install some modules: Editor Library 2 - None of the modules providing the capability org.netbeans.modules.editor.actions could be… >>> More
netbeans editor loses focus on editor and gives it to the menubar

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi all, I am newbie of using Netbeans and i have Netbeans 6.5 on XP. So, here is my problem: when i am working on Netbeans and switch to an another task and then come back later, editor of the Netbeans losts the focus and the menubar gains it. I don't want to press ALT key again to re-focus on the… >>> More
PlantUML Editor: A fast and simple UML editor using WPF

as seen on Code Project - Search for 'Code Project'
A WPF smart client to generate UML diagrams from plain text using plantuml tool >>> More
'Photo editor' and 'RAW editor' in Shotwell

as seen on Ask Ubuntu - Search for 'Ask Ubuntu'
The preference menu in Shotwell allows the user to specify both an 'External photo editor' and an 'External RAW editor', but I'm confused as to why two external editors would be required. I'm not a photographer, so this confusion may simply be a result of my ignorance, but I thought RAW images were… >>> More
Make My Own Made Java Based Text editor as default Text Editor in Windows

as seen on Super User - Search for 'Super User'
I have Made a Text Editor in Java and i want to make it default text editor ,That is like in windows we have notepad as default text whose icon shows on all text files and double clicking those file(s) opens the file(s) in notepad window.. I Want to achieve same Task of Making my texte editor as default… >>> More