0
votes
0answers
14 views

Using SSMS, how do I add a row to when a column is read only?

How do I add a row to when a column is read only? I think this issue I am having is because I am using an ID field (column) that is automatically generated and incremented whenever a new row is added ...
2
votes
2answers
54 views

SSMS import large table

I'm trying to move several tables of data between 2 MSSQL 2008 databases, I have generated data insert scripts for one table which is quite large (around 3.5M rows) The script is around 3GB. When I ...
1
vote
2answers
310 views

Results copied from SSMS splitting across columns when pasted into Excel

SSMS 2008 -> Excel 2003 This isn't happening all the time, but sometimes when I 'copy with headers' from sql server management studio, the results in Excel look as though I've used the 'text to ...