Thursday, March 22, 2012

cannot open table in sql server management studio express

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