随笔分类 -  Database

How to enable sa user account in SQL Server 2005
摘要：How to enable sa user account in SQL Server 2005Step 1.You would enable the TCP/IP Protocol Name in the path of Start->Microsoft SQL Server 2005->Configuration Tools->SQL Server Configuration... 阅读全文
posted @ 2009-12-16 17:24 Louis Yan 阅读(411) 评论(0) 推荐(0)
String or binary data would be truncated
摘要：Error Message：String or binary data would be truncatedReason：一般出现这个问题是因为数据库中的某个字段的长度小，而插入数据大solution：修改数据库表结构，使表字段大小相同或者大于要插入的数据的长度 阅读全文
posted @ 2009-05-31 14:47 Louis Yan 阅读(536) 评论(0) 推荐(0)