Hello all.
I have uploaded a table into sql management studio express. However, when I right click on the table and try and open it, I get an error message saying;
"SQL Execution Error.
Executed SQL statement: select columnName1, columnName2 etc....
Error source: Microsoft. VisualStudio.DataTools
Error Message: Exception has been thrown by the target of an invocation"
Because of this error, I cannot manually edit the table. However, when I write a query running select * from Table X, the table does appear that way.
Any help regarding how to open the table would be very much appreciated!!
I have same issue now. What is your solution?|||Hi,
If you wanna modify data. you'd rather build a T-SQL script (e.g. with insert, update and/or delete
statements).
To prevent problems also consider enclosing the modification in a transaction, e.g.:
begin tran
-- do modifications
-- verify results
commit tran -- if results were ok
rollback tran -- if results were wrong
BTW, the question may be asked better at Sql server express :)
No comments:
Post a Comment