CREATE / ALTER DATABASE语句中选项FILENAME的使用无效。 [英] Invalid usage of the option FILENAME in the CREATE/ALTER DATABASE statement.

问题描述

嘿伙计们，



由于某些原因，我的代码出错了......我不确定为什么......任何人都有任何想法？

Hey guys,

I'm getting an error with this code for some reason... and i'm not sure why.. anyone have any ideas?

string str = "";

         str = "CREATE DATABASE "+Name+" ON PRIMARY " +
            "(NAME =  N'"+Name+"', " +
            "FILENAME = N'c:\\Program Files\\Microsoft SQL Server\\MSSQL10_50.SQLEXPRESS\\MSSQL\\DATA\\"+Name+".mdf', " +
            "SIZE = 2048KB, MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB) " +
            "LOG ON (NAME =  N'"+Name+"_log' " +
            "FILENAME =  N'c:\\Program Files\\Microsoft SQL Server\\MSSQL10_50.SQLEXPRESS\\MSSQL\\DATA\\"+Name+"_log.ldf' , " +
            "SIZE = 1024KB, " +
            "MAXSIZE = 2048GB, " +
            "FILEGROWTH = 10%)";

        myCommand = new SqlCommand(str, Conn);

错误：CREATE / ALTER DATABASE语句中选项FILENAME的使用无效。

Error : Invalid usage of the option FILENAME in the CREATE/ALTER DATABASE statement.

推荐答案

你的语法略有错误你正在组合名称和文件名（登录）

your syntax is slightly wrong you are combining the name and filename (log on)

str = "CREATE DATABASE "+Name+" ON PRIMARY " +
   "(NAME =  N'"+Name+"', " +
   "FILENAME = N'c:\\Program Files\\Microsoft SQL Server\\MSSQL10_50.SQLEXPRESS\\MSSQL\\DATA\\"+Name+".mdf', " +
   "SIZE = 2048KB, MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB) " +
   "LOG ON (NAME =  N'"+Name+"_log' "+ "," +
   "FILENAME =  N'c:\\Program Files\\Microsoft SQL Server\\MSSQL10_50.SQLEXPRESS\\MSSQL\\DATA\\"+Name+"_log.ldf' , " +
   "SIZE = 1024KB, " +
   "MAXSIZE = 2048GB, " +
   "FILEGROWTH = 10%)";

这篇关于CREATE / ALTER DATABASE语句中选项FILENAME的使用无效。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！