115 reputation
6
bio website
location
age
visits member for 4 years, 10 months
seen Jun 10 at 1:09

Jun
10
accepted Some rows giving “String or binary data would be truncated” error when editing in Management Studio
Feb
10
awarded  Popular Question
Oct
8
awarded  Popular Question
Mar
2
comment Some rows giving “String or binary data would be truncated” error when editing in Management Studio
There are multiple columns, see my update above.
Mar
2
comment Some rows giving “String or binary data would be truncated” error when editing in Management Studio
I'm only inserting a few characters. I updated some new findings in the post.
Mar
2
revised Some rows giving “String or binary data would be truncated” error when editing in Management Studio
updated symptoms
Mar
1
comment DOS path not resolving in VM
I'm not sure about how the VM is setup. The VM is an image of an old system used for just one and application and has a SQL Server installed on the same box as the application. The file is there (just amended my original post). It is found on the physical box by using the DOS path, but not found on the VM (although it exists on the VM). I can edit the registry so the SQL Server service points to the long file name path, but still don't know why the VM has problems with the 8.3 path.
Mar
1
revised DOS path not resolving in VM
added 286 characters in body
Mar
1
asked Some rows giving “String or binary data would be truncated” error when editing in Management Studio
Feb
25
awarded  Student
Feb
25
asked DOS path not resolving in VM
Jan
18
awarded  Scholar
Jan
18
accepted Can I query a different server in a SQL Server Agent job?
Dec
4
asked Can I query a different server in a SQL Server Agent job?
Dec
4
awarded  Supporter
Sep
25
revised Only allow ability to read the views for a particular SQL Server user over ODBC
added 309 characters in body
Sep
25
awarded  Editor
Sep
25
revised Only allow ability to read the views for a particular SQL Server user over ODBC
added 7 characters in body; edited tags
Sep
25
comment Only allow ability to read the views for a particular SQL Server user over ODBC
I'm using 2008. Under Securables in the User Properties, there is a Permissions area with a disabled "Column Permissions" button. Same if creating a role. Trying to figure that out.
Sep
25
asked Only allow ability to read the views for a particular SQL Server user over ODBC