请交用vc等程序语言,不使用企业管理器怎么启动和加载某个数据库,启动和关闭数据库服务
解决方案 »
- 没有ID3标识的mp3文件该如何读取
- 从CPropertySheet中派生的自己的类,“应用”按钮灰色,如何使其有效?并自己编写响应函数?
- 大家来看看 霍夫变换识别直线的输出让人郁闷啊 想不通~~霍夫变换有bug??
- 急:试图执行系统不支持的操作,release版中出现,debug版中正常,如何解决?
- 主程序和线程有什么区别?
- 如何用倾斜30度的文字填充整个client框?
- 如何定意全局变量?
- 为什么参数值传不回来?
- 这个警告是什么!
- 高分请教,为什么throw异常,捕获不了。详见帖子
- 请问,当长时间的处理想弹出一个MsgBox,处理后将其关闭,在VC中一般怎么写?
- InstallShield For VC++6.0 谁有???
http://www.7880.com/Info/Article-11af4860.html加载某个数据库?
附加数据库:
sp_attach_single_file_db '数据库名','mdf文件路径'
建库:
CREATE DATABASE Products
ON
( NAME = prods_dat,
FILENAME = 'c:\program files\microsoft sql server\mssql\data\prods.mdf',
SIZE = 4,
MAXSIZE = 10,
FILEGROWTH = 1 )
GO
SQL-DMO is implemented in Sqldmo.dll. These SQL-DMO objects expose the properties, methods, and events that automate administrative tasks for SQL Server. They cannot be used to connect to and operate against a SQL Server version 6.5 (or earlier) server. Therefore, it is recommended that you rewrite SQL-DMO applications.
If the application must operate against both SQL Server 2000 and version 6.5 or earlier of SQL Server, reference both Sqldmo.dll and Sqlole.dll components in the application. Develop new, separate subroutines referencing the SQL Server 2000 SQL-DMO objects from the existing subroutines.If the application will work against SQL Server 2000 only, rewrite existing subroutines to reference SQL Server 2000 SQL-DMO objects.If the application will not be used against your new SQL Server 2000 server(s), continue to use the application unchanged.