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

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
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.
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.