首先:SQL语句实现附加数据库很简单由于本人经常管理服务器,期间也常给客户附加数据库或服务器出问题时都得对数据库进行操作,以前一两个时不管出什么问题都好解决,现在SQL Server 2000数据库便宜了,一堆一堆的人要SQL数据库,这样一来服务器如果进行调整或升级,就会有各种问题,感觉麻烦,尤其是附加数据库时,与时有了下边的文章,代码很简短,但可以实现很多图形化操作非常难实现的操作.而SQL语句实现附加数据库操作非常方便,在您的使用过程中如果按下面的方法不成,可以给我留言,我会尽快解决.-------------------------------------------------------------------------------- --附加数据库sp_attach_db '数据库名','数据库全路径','数据库日志全路径'GOUSE 数据库名--添加一个登录前指定默认数据库EXEC sp_addlogin '登录名','密码','数据库名'GO--处理空登录名(使登录用户和数据库的孤立用户对应起来，在这个用户有对象时用)sp_change_users_login 'update_one','登录名','登录名'GO--修改数据库的逻辑文件名（数据）ALTER DATABASE NEWMODIFY FILE(NAME='Old_Data',NEWNAME='New_Data')GO--修改数据库的逻辑文件名（日志）ALTER DATABASE NEWMODIFY FILE(NAME='Old_Log',NEWNAME='New_Log')GO-------------------------------------------------------------------------------- 可能会用到的操作:--更改当前数据库名称为dbo的登录名为abcEXEC sp_changedbowner 'abc'--删除一个登录EXEC sp_droplogin '登录名'--赋予这个登录访问数据库的权限EXEC sp_adduser '登录名','用户名','db_owner'手动实现方法：[无错版]SQL Server 2000using System;using System.Collections.Generic;using ponentModel;using System.Data;using System.Drawing;using System.Text;using System.Windows.Forms;using System.Data.SqlClient;namespace System{public partial class Form1 : Form{public Form1(){InitializeComponent();}public string ConnectionString;private SqlConnection Conn;private SqlCommand Comm;public string StrSQL;public string DataBaseName;public string DataBase_MDF;public string DataBase_LDF;public string DataBaseOfBackupName;public string DataBaseOfBackupPath;private void Form1_Load(object sender, EventArgs e){C;DataBaseName = "risheng";DataBase_MDF = @ "E:\risheng_Data.MDF";DataBase_LDF = @ "E:\risheng_Log.LDF";AddDataBase();}/// <summary>/// 执行创建/修改数据库和表的操作/// </summary>public void DataBaseAndTableControl(){try{Conn = new SqlConnection(ConnectionString);Conn.Open();Comm = new SqlCommand();Comm.Connection = Conn;mandText = StrSQL;mandType = CommandType.Text;Comm.ExecuteNonQuery();MessageBox.Show( "数据库操作成功！", "信息提示",MessageBoxButtons.OK, rmation);}catch (Exception ex){MessageBox.Show(ex.Message, "信息提示", MessageBoxButtons.OK, rmation);}finally{Conn.Close();}}/// <summary>/// 附加数据库/// </summary>public void AddDataBase(){try{Conn = new SqlConnection(ConnectionString);Conn.Open();Comm = new SqlCommand();Comm.Connection = Conn;mandText = "sp_attach_db";Comm.Parameters.Add(new SqlParameter(@ "dbname", SqlDbType.NVarChar));Comm.Parameters[@ "dbname"].Value = DataBaseName;Comm.Parameters.Add(new SqlParameter(@ "filename1", SqlDbType.NVarChar));Comm.Parameters[@ "filename1"].Value = DataBase_MDF;Comm.Parameters.Add(new SqlParameter(@ "filename2", SqlDbType.NVarChar));Comm.Parameters[@ "filename2"].Value = DataBase_LDF;mandType = CommandType.StoredProcedure;Comm.ExecuteNonQuery();MessageBox.Show( "附加数据库成功", "信息提示", MessageBoxButtons.OK, rmation);}catch (Exception ex){MessageBox.Show(ex.Message, "信息提示", MessageBoxButtons.OK, rmation);}finally{Conn.Close();}}/// <summary>/// 分离数据库/// </summary>public void DeleteDataBase(){try{Conn = new SqlConnection(ConnectionString);Conn.Open();Comm = new SqlCommand();Comm.Connection = Conn;mandText = @ "sp_detach_db";Comm.Parameters.Add(new SqlParameter(@ "dbname", SqlDbType.NVarChar));Comm.Parameters[@ "dbname"].Value = DataBaseName;mandType = CommandType.StoredProcedure;Comm.ExecuteNonQuery();MessageBox.Show( "分离数据库成功", "信息提示", MessageBoxButtons.OK, rmation);}catch (Exception ex){MessageBox.Show(ex.Message, "信息提示", MessageBoxButtons.OK, rmation);}finally{Conn.Close();}}/// <summary>/// 备份数据库/// </summary>public void BackupDataBase(){try{Conn = new SqlConnection(ConnectionString);Conn.Open();Comm = new SqlCommand();Comm.Connection = Conn;mandText = "use master;backup database @dbname to disk = @backupname;";Comm.Parameters.Add(new SqlParameter(@ "dbname", SqlDbType.NVarChar));Comm.Parameters[@ "dbname"].Value = DataBaseName;Comm.Parameters.Add(new SqlParameter(@ "backupname", SqlDbType.NVarChar));Comm.Parameters[@ "backupname"].Value = @DataBaseOfBackupPath + @DataBaseOfBackupName;mandType = CommandType.Text;Comm.ExecuteNonQuery();MessageBox.Show( "备份数据库成功", "信息提示", MessageBoxButtons.OK, rmation);}catch (Exception ex){MessageBox.Show(ex.Message, "信息提示", MessageBoxButtons.OK, rmation);}finally{Conn.Close();}}/// <summary>/// 还原数据库/// </summary>public void ReplaceDataBase(){try{string BackupFile = @DataBaseOfBackupPath + @DataBaseOfBackupName; Conn = new SqlConnection(ConnectionString);Conn.Open();Comm = new SqlCommand();Comm.Connection = Conn;mandText = "use master;restore database @DataBaseName From disk = @BackupFile with replace;";Comm.Parameters.Add(new SqlParameter(@ "DataBaseName", SqlDbType.NVarChar));Comm.Parameters[@ "DataBaseName"].Value = DataBaseName;Comm.Parameters.Add(new SqlParameter(@ "BackupFile",SqlDbType.NVarChar));Comm.Parameters[@ "BackupFile"].Value = BackupFile;mandType = CommandType.Text;Comm.ExecuteNonQuery();MessageBox.Show( "还原数据库成功", "信息提示", MessageBoxButtons.OK, rmation);}catch (Exception ex){MessageBox.Show(ex.Message, "信息提示", MessageBoxButtons.OK, rmation);}finally{Conn.Close();}}// 还原数据库private void button0_Click(object sender, EventArgs e){C;DataBaseName = "MyDatabase";DataBaseOfBackupName = @ "back.bak";DataBaseOfBackupPath = @ "D:\Program Files\Microsoft SQL Server\MSSQL\Data\";ReplaceDataBase();}// 附加数据库private void button1_Click_1(object sender, EventArgs e){C;DataBaseName = "MyDatabase";DataBase_MDF = @ "D:\Program Files\Microsoft SQL Server\MSSQL\Data\MyDatabase_Data.MDF";DataBase_LDF = @ "D:\Program Files\Microsoft SQL Server\MSSQL\Data\MyDatabase_Log.LDF";AddDataBase();}// 备份数据库private void button2_Click(object sender, EventArgs e){C;DataBaseName = "MyDatabase";DataBaseOfBackupName = @ "back.bak";DataBaseOfBackupPath = @ "D:\Program Files\Microsoft SQL Server\MSSQL\Data\";BackupDataBase();}// 分离数据库private void button3_Click(object sender, EventArgs e){C;DataBaseName = "MyDatabase";DeleteDataBase();}}}用sp_attach_db 將你的數據庫綁定上去-----------------------use masterEXEC sp_attach_db @dbname = N'pubs',@filename1 = N'c:\Program Files\Microsoft SQL Server\MSSQL\Data\pubs.mdf', @filename2 = N'c:\Program Files\Microsoft SQL Server\MSSQL\Data\pubs_log.ldf'。
