网狐棋牌6.6.1编程手册(2012版)

相关主题

1、下载文档前请自行甄别文档内容的完整性，平台不提供额外的编辑、内容补充、找答案等附加服务。
2、"仅部分预览"的文档,不可在线预览部分如存在完整性等问题,可反馈申请退款(可完整预览的文档不适用该条件!)。
3、如文档侵犯您的权益，请联系客服反馈,我们会尽快为您处理(人工客服工作时间：9:00-18:30)。

网狐棋牌6.6.1升级编程手册(2012版)

wanghu065@

1 数据库使用SQL Server2008 Express

如果附加数据库时，提示数据库没有访问权限。只要将数据库文件和日志文件的user权限改为完全控制即可。

编写批处理文件attachDB.bat将数据库目录中的所有数据库加载到SQL Server2008 Express。

attachDB.bat:

SQLCMD -S ".\SQLEXPRESS" -U sa -P 123456 -i "Attach.sql" SQLCMD -S ".\SQLEXPRESS" -U sa -P 123456 -i "用户链接.sql" Attach.sql:

EXEC sp_attach_db @dbname = N'CxGameTreasuredb', @filename1 = N'D:\QP\DB\CxGameTreasuredb.mdf',

@filename2 = N'D:\QP\DB\CxGameTreasuredb_1.ldf'; EXEC sp_attach_db @dbname = N'KYGameDB',

@filename1 = N'D:\QP\DB\KYGameDB.mdf',

@filename2 = N'D:\QP\DB\KYGameDB_log.ldf';

EXEC sp_attach_db @dbname = N'News',

@filename1 = N'D:\QP\DB\News.mdf',

@filename2 = N'D:\QP\DB\News_1.ldf';

EXEC sp_attach_db @dbname = N'QPBilliardsDB',

@filename1 = N'D:\QP\DB\QPBilliardsDB.mdf',

@filename2 = N'D:\QP\DB\QPBilliardsDB_log.ldf'; EXEC sp_attach_db @dbname = N'QPcdmjDB',

@filename1 = N'D:\QP\DB\QPcdmjDB.mdf',

@filename2 = N'D:\QP\DB\QPcdmjDB_log.ldf';

EXEC sp_attach_db @dbname = N'QPChessDB',

@filename1 = N'D:\QP\DB\QPChessDB.mdf',

@filename2 = N'D:\QP\DB\QPChessDB_log.ldf';

EXEC sp_attach_db @dbname = N'QPChinaChessDB', @filename1 = N'D:\QP\DB\QPChinaChessDB.mdf',

@filename2 = N'D:\QP\DB\QPChinaChessDB_log.ldf'; EXEC sp_attach_db @dbname = N'QPGameScoreDB', @filename1 = N'D:\QP\DB\QPGameScoreDB.mdf',

@filename2 = N'D:\QP\DB\QPGameScoreDB_log.ldf'; EXEC sp_attach_db @dbname = N'QPGameUserDB', @filename1 = N'D:\QP\DB\QPGameUserDB.mdf',

@filename2 = N'D:\QP\DB\QPGameUserDB_log.ldf'; EXEC sp_attach_db @dbname = N'QPGoBangDB',

@filename1 = N'D:\QP\DB\QPGoBangDB.mdf',

@filename2 = N'D:\QP\DB\QPGoBangDB_log.ldf'; EXEC sp_attach_db @dbname = N'QPGuanPaiDB',

@filename1 = N'D:\QP\DB\QPGuanPaiDB.mdf',

@filename2 = N'D:\QP\DB\QPGuanPaiDB_log.ldf'; EXEC sp_attach_db @dbname = N'QPLandDB',

@filename1 = N'D:\QP\DB\QPLandDB.mdf',

@filename2 = N'D:\QP\DB\QPLandDB_log.ldf';

EXEC sp_attach_db @dbname = N'QPLandCrazyDB', @filename1 = N'D:\QP\DB\QPLandCrazyDB.mdf',

@filename2 = N'D:\QP\DB\QPLandCrazyDB_log.ldf'; EXEC sp_attach_db @dbname = N'QPLandEXVDDB', @filename1 = N'D:\QP\DB\QPLandEXVDDB.mdf',

@filename2 = N'D:\QP\DB\QPLandEXVDDB_log.ldf'; EXEC sp_attach_db @dbname = N'QPLandSCDB',

@filename1 = N'D:\QP\DB\QPLandSCDB.mdf',

@filename2 = N'D:\QP\DB\QPLandSCDB_log.ldf'; EXEC sp_attach_db @dbname = N'QPLandVDDB',

@filename1 = N'D:\QP\DB\QPLandVDDB.mdf',

@filename2 = N'D:\QP\DB\QPLandVDDB_log.ldf'; EXEC sp_attach_db @dbname = N'QPLLShowDB',

@filename1 = N'D:\QP\DB\QPLLShowDB.mdf',

@filename2 = N'D:\QP\DB\QPLLShowDB_log.ldf'; EXEC sp_attach_db @dbname = N'QPServerInfoDB', @filename1 = N'D:\QP\DB\QPServerInfoDB.mdf',

@filename2 = N'D:\QP\DB\QPServerInfoDB_log.ldf'; EXEC sp_attach_db @dbname = N'QPShuangKouBBDB', @filename1 = N'D:\QP\DB\QPShuangKouBBDB.mdf',

@filename2 = N'D:\QP\DB\QPShuangKouBBDB_log.ldf'; EXEC sp_attach_db @dbname = N'QPShuangKouDB', @filename1 = N'D:\QP\DB\QPShuangKouDB.mdf',

@filename2 = N'D:\QP\DB\QPShuangKouDB_log.ldf'; EXEC sp_attach_db @dbname = N'QPSparrowDZDB', @filename1 = N'D:\QP\DB\QPSparrowDZDB.mdf',

@filename2 = N'D:\QP\DB\QPSparrowDZDB_log.ldf'; EXEC sp_attach_db @dbname = N'QPTreasureDB',

@filename1 = N'D:\QP\DB\QPTreasureDB.mdf',

@filename2 = N'D:\QP\DB\QPTreasureDB_log.ldf'; EXEC sp_attach_db @dbname = N'QPUpGradeDB',