trueben

博客园 首页 新随笔 联系 订阅 管理

2013年1月7日 #

摘要: I recently had to reinstall Reporting Services 2008, and had to remind myself how to set it up correctly. Installing Reporting Services on Vista, and later operating systems, can be tricky. I've seen several forum posts of people spending days on installation problems... The culprit is the new s 阅读全文
posted @ 2013-01-07 09:52 trueben 阅读(315) 评论(0) 推荐(0)

摘要: 1:向表中添加字段Alter table [表名] add [列名] 类型2: 删除字段Alter table [表名] drop column [列名]3: 修改表中字段类型(可以修改列的类型,是否为空)Alter table [表名] alter column [列名] 类型4:添加主键Alter table [表名] add constraint [ 约束名] primary key( [列名])5:添加唯一约束Alter table [表名] add constraint [ 约束名] unique([列名])6:添加表中某列的默认值Alter table [表名] add const 阅读全文
posted @ 2013-01-07 09:37 trueben 阅读(420) 评论(0) 推荐(0)

摘要: 1、首先停止 SQLServer 服务2、启动cmd.exe,进入SQLServer安装目录, 在命令行提示符下执行 sqlservr.exe -m 如果是命名实例执行sqlservr.exe -m -s<Instance Name>3、启动另一个cmd.exe窗口,执行 sqlcmd -E4、在此窗口下执行下面的命令create login [domain\administrator] from windowsgoexec sp_addsrvrolemember [domain\administrator], [sysadmin]goshutdowngo5、关闭2个cmd窗口,启 阅读全文
posted @ 2013-01-07 09:29 trueben 阅读(717) 评论(0) 推荐(0)