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.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 trouble deleting row in SSMS GUI

Author  Topic 

mcolli00
Starting Member

19 Posts

Posted - 2011-01-28 : 17:35:21
When I try to delete in SSMS GUI table by right clicking and choosing delete then I get an error that binary data will be truncated. The error doesn't list the column name. However, when I delete using simple sql delete query in the query editor the row then gets deleted. What do you think causes the error in the GUI?

Thanks
MC

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2011-01-28 : 17:49:41
The GUI has issues. Don't use the GUI. Run your DML statements in a query window instead. You won't have these issues there.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

mcolli00
Starting Member

19 Posts

Posted - 2011-01-28 : 17:54:10
Thanks Tara.
MC
Go to Top of Page
   

- Advertisement -